How to Set Up Asynchronous Replication Between MySQL Galera Clusters
The Galera Cluster enforces strong data consistency, where all nodes in the cluster are tightly coupled. Although network segmentation is supported, replication performance is still bound by two factors: The round trip time (RTT) to...
6 Common Failure Scenarios for MySQL & MariaDB, and How to Fix Them
It this blog post, we will analyze 6 different failure scenarios in production database systems, ranging from single-server issues to multi-datacenter failover plans. We will walk you through recovery and failover procedures for the respective...
Controlling Replication Failover for MySQL and MariaDB With Pre- or Post-Failover Scripts
In a previous post, we discussed how you can take control of the failover process in ClusterControl by utilizing whitelists and blacklists. In this post, we are going to discuss a similar concept. But this...
New Backup Management and Security Features for MySQL & PostgreSQL: ClusterControl Release 1.6.2
We are excited to announce the 1.6.2 release of ClusterControl - the all-inclusive database management system that lets you easily automate and manage highly available open source databases in any environment: on-premise or in the...
How to Control Replication Failover for MySQL and MariaDB
Automated failover is pretty much a must have for many applications - uptime is taken for granted. It’s quite hard to accept that an application is down for 20 or 30 minutes because someone has...
How to Perform Schema Changes in MySQL & MariaDB in a Safe Way
Before you attempt to perform any schema changes on your production databases, you should make sure that you have a rock solid rollback plan; and that your change procedure has been successfully tested and validated...
How to Recover MySQL Galera Cluster From an Asynchronous Slave
Introduction When running Galera Cluster, it is a common practice to add one or more asynchronous slaves in the same or in a different datacenter. This provides us with a contingency plan with low RTO,...
Disaster Recovery Planning for MySQL & MariaDB
We’re happy to announce that our new whitepaper Disaster Recovery Planning for MySQL & MariaDB is now available to download for free! Database outages are almost inevitable and understanding the timeline of an outage can...
Improve Performance of Galera Cluster for MySQL or MariaDB
Galera Cluster comes with many notable features that are not available in standard MySQL replication (or Group Replication); automatic node provisioning, true multi-master with conflict resolutions and automatic failover. There are also a number of...
Webinar Replay: MySQL & MariaDB Performance Tuning for Dummies
Thanks to everyone who participated in this week’s webinar on Performance Tuning for MySQL & MariaDB! If you’ve missed the live session or would like to watch it again, it is now available online to...
Schema Management Tips for MySQL & MariaDB
Database schema is not something that is written in stone. It is designed for a given application, but then the requirements may and usually do change. New modules and functionalities are added to the application,...
Comparing RDS vs EC2 for Managing MySQL or MariaDB on AWS
RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic...