In this blog post, we are going to set up two Galera clusters running on Percona XtraDB Cluster 5.7, one of the production environment and one for the disaster recovery (DR). Both production and disaster recovery sites will be replicating through encrypted master-slave asynchronous replication where database nodes in AWS are the master cluster (production) while database nodes on Azure are the slave cluster (DR).

In this blog post, we are going to perform an online migration with minimal downtime from MySQL 5.6 standalone setup without GTID to a new replication set running on MySQL 5.7 with GTID, deployed and managed by ClusterControl.

Multi-Cloud deployments are a common part of disaster recovery plans. In this blog we will show you how to setup and optimize a MySQL Replication deployment across multiple clouds.

Replication lag is a common challenge when running multi-cloud database deployments. In this blog we will take a look at lag and provide options for how to address it for MySQL, PostgreSQL, & MongoDB.

Split-brain is a serious issue that may affect multi-cloud MySQL database deployments. There are some methods you can use to minimize the risk and ensure your data will stay consistent.

Many SysAdmins & DBAs use MySQL Workbench as a tool to help manage their databases. In this blog post we’re going to take a look at the user experience of the tool and how it compares to ClusterControl.

ProxySQL can sometimes be tricky to configure, but there are tools that can help you do it. In this blog post we will take a look at the proxysql-admin tool from Percona and compare it to how ClusterControl manages ProxySQL

Percona has a tool to analyze queries callled pt-query-digest, part of  the Percona Toolkit. In this blog we will take a look at this tool and how it compares to the Query Management features of ClusterControl.

Point-in-Time Recovery (PITR) is a common part of a disaster recovery plan (DRP). In this blog we’ll take a look at how PITR is performed on Amazon RDS for PostgreSQL, MySQL & MariaDB. We will also look at how ClusterControl does it and see how it compares with RDS.

MySQL Workbench is a popular tool used by SysAdmins and DBAs to manage their MySQL databases. In this blog post, we are going to compare and contrast MySQL database user management features between MySQL Workbench and ClusterControl.

MySQL Workbench is a popular tool used by SysAdmins and DBAs to manage their MySQL databases. In this blog we take a look at how ClusterControl handles configuration management and how it compares to workbench.

In the second part of our blog “Preparing a MySQL or MariaDB Server for Production” we continue to share tips to configure and prepare a MySQL server for production usage from a system administrator’s perspective.

Logical backups, like Mysqldump, are not the fastest nor the most space-efficient way of backing up MySQL databases, but they have a huge advantage over physical backups. In this blog we will show you how to restore a single MySQL table using mysqldump

We are sometimes asked, how can you deploy ClusterControl and make it highly available from the application layer to the database layer? This blog will show you how to deploy a MySQL Replication as the CMON database storage engine with automatic failover and recovery in case of disaster.

In this two-part blog series, we are going to show you 9 tips and tricks on how to configure and prepare a MySQL server for production usage from a system administrator perspective.