Live Migrations Using MySQL Replication
Migrating your database to a new datacenter can be a high-risk and time-consuming process. A database contains state, and can be much harder to migrate as compared to web servers, queues or cache servers. In...
Building a Highly Available Database for Moodle Using MySQL Replication
Moodle is an open source learning management system, widely used by schools and universities around the world. The project started in 2002 by Martin Dougiamas, with the aim to provide learners, teachers, educators a secure,...
Multi-Cloud Deployment for MySQL Replication
In recent years, the use of platform infrastructure has shifted from on-premise to cloud computing. This is based on the absence of cost capital costs that must be incurred by the company if used when...
Setting Up a Geo-Distributed Database Cluster Using MySQL Replication
A single point of failure (SPOF) is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity...
Comparing Failover Times for Amazon Aurora, Amazon RDS, and ClusterControl
If your IT infrastructure is running on AWS, you have probably heard about Amazon Relational Database Service (RDS), an easy way to set up, operate, and scale a relational database in the cloud. It provides...
Announcing ClusterControl 1.7.3: Improved Support PostgreSQL & New Cloud Deployment Options
We’re excited to announce the 1.7.3 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. In this release we have added support for...
Master High Availability Manager (MHA) Has Crashed! What Do I Do Now?
MySQL Replication is very popular way of building highly available database layers. It is very well known, tested and robust. It is not without limitations, though. One of them, definitely, is the fact that it...
MySQL Replication for High Availability
We’re happy to announce that our newly updated whitepaper MySQL Replication for High Availability is now available to download for free! MySQL Replication enables data from one MySQL database server to be copied automatically to...
Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN
Why Choose MySQL Replication? Some basics first about the replication technology. MySQL Replication is not complicated! It is easy to implement, monitor, and tune as there are various resources you can leverage - google being...
Hybrid OLTP/Analytics Database Workloads: Replicating MySQL Data to ClickHouse
How to run Analytics on MySQL? MySQL is a great database for Online Transaction Processing (OLTP) workloads. For some companies, it used to be more than enough for a long time. Times have changed and...
MySQL Performance Cheat Sheet
MySQL is extensive and has lots of areas to optimize and tweak for the desired performance. Some changes can be performed dynamically, others require a server restart. It is pretty common to find a MySQL...
Deploy MySQL Replication and ProxySQL With Automatic Failover
MySQL replication is a very popular choice to build highly available setups. It is fairly predictable, robust and efficient. It is also quite easy to setup - install MySQL software, create replication users and configure...