Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Release Roundup March 18, 2024

03/17/2024 | Percona
Percona software releases and updates March 5 - March 18, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software

Learn More »

Continuent Tungsten Value Proposition

03/08/2024 | Continuent

Continuent Tungsten Clustering is positioned as a reliable and comprehensive solution for enterprise MySQL database management, addressing critical business needs for continuous operations and global scalability.

This webinar provides a clear understanding of the Continuent Tungsten Clustering value proposition — what makes our enterprise-grade software worth the cost?

It highlights Tungsten Clustering's extensive capabilities, such as high availability and disaster recovery th

Learn More »

MySQL install ‘n’ config one-liners

03/04/2024 | MySQL-Med

Back again, now with MySQL installs. And this means using the MySQL repository this time around.

I’ve been installing and configuring InnoDB Clusters and ClusterSets and thinking about the Ansible and Terraform users amongst us, maybe one-liners might help someone out there.

So, what about if I share how to install the MySQL repo, install the MySQL instance, create an InnoDB Cluster, add a MySQL Router, create a ClusterSet, make sure the Router is ClusterSet-aware, and then test it o

Learn More »

Release Roundup March 4, 2024

03/03/2024 | Percona
Percona software releases and updates February 21 - March 4, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona softwa

Learn More »

Setting Up Your Environment for Kubernetes Operators Using Docker, kubectl, and k3d

03/03/2024 | Percona
If you are just starting out in the world of Kubernetes operators, like me, preparing the environment for their installation should be something we do with not much difficulty. This blog will quickly guide you in setting the minimal environment. Kubernetes operators are invaluable for automating complex database operations, tasks that Kubernetes does not handle directly. Operators make it easy for us – they take care of essential tasks like backups and restores, which are crucial in database m

Learn More »

First Row of Many Similar Ones

02/28/2024 | SQL for Devs
SQL is a straightforward and expressive language, but it sometimes lacks constructs for writing queries in a simple way. It's more complicated than it should be to write a query to get, e.g., only the most expensive order for every customer of the current fiscal year. You can use PostgreSQL's vendor-specific DISTINCT ON feature or window functions for every other database - like MySQL.

Learn More »

Webinar recording: Mastering Galera Cluster, Best Practices and New Features

02/28/2024 | Galera Cluster

This exclusive webinar is tailored for database administrators and IT professionals aiming to enhance their systems’ efficiency and reliability using Galera Cluster. This session focuses on practical best practices, showcases new features, and provides an extended platform for your queries.

What You Will Learn:

* Core Best Practices: Dive into essential practices, from employing primary keys and leveraging InnoDB to deciding if to optimise read/write splits and managing AUTO_INCREMENT settings.

Learn More »

MySQL Keyring Component Installation for TDE

02/27/2024 | MySQLHK


MySQL Plugin has been extensively used with MySQL.   It is being evolved into COMPONENT deployment.   This article is written to share the steps with MySQL Keyring Component Installation.   

MySQL Enterprise Edition includes encrypted file component for Keyring.    This provides a more secure way to store the master key with TDE.

Installation of component with keyring has to be static rather than running SQL command "INSTALL COMPONENT".   There are 2 scopes with co

Learn More »

MariaDB Encryption ( data at rest )

02/24/2024 | Another MySQL DBA

Here is a simple example showing a couple options for MariaDB Encryption. 

You have to consider what you want to encrypt . The data communication (data in transit) or the data on the instance (data at rest). 

This post is going to focus on the data at rest option using a AWS free tier node running on Amazon Linux. I will be using the world database on 2 different instances to show updating current tables with encryption as well as new loading tables to be auto-encrypted. 


1st we

Learn More »

Release Roundup February 21, 2024

02/20/2024 | Percona
Percona software releases and updates February 5 - February 21, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona sof

Learn More »

Pages