A Guide to Pgpool for PostgreSQL: Part Two
This is the second part of the blog “A Guide to Pgpool for PostgreSQL”. The first part covering load balancing, session pooling, in memory cache and installation can be found here. Many users look towards...
Transparent Database Failover for Your Applications
ClusterControl is a great tool to deploy and manage databases clusters - if you are into MySQL, you can easily deploy clusters based on both traditional MySQL master-slave replication, Galera Cluster or MySQL NDB Cluster....
Failover for MySQL Replication (and others) – Should it be Automated?
Automatic failover for MySQL Replication has been subject to debate for many years. Is it a good thing or a bad thing? For those with long memory in the MySQL world, they might remember the...
MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions
For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...
MySQL Replication Failover – MaxScale vs MHA: Part Four
In the earlier blogs in this series, we concluded that MaxScale with MariaDB Replication Manager still has some way to go as a failover solution. The failover mechanism relied on MariaDB GTID, needed a wrapper...
How ProxySQL Adds Failover and Query Control to Your MySQL Replication Setup
In a previous blog post, we discussed the installation of ProxySQL and its configuration system. In today’s post, we’ll set up ProxySQL to work in a MySQL Replication environment managed by ClusterControl. We will take...
MySQL Replication Failoverv – Maxscale vs MHA: Part Three
In our previous two posts we described in depth how MySQL Master-HA (MHA) and MaxScale + MariaDB Replication Manager (MRM) both perform their so called slave promotions (also known as master failover). MHA has been...
MySQL Replication Failover – Maxscale vs MHA: Part Two
In our previous post, we described how MySQL Master-HA (MHA) performs a so called slave promotion (also known as master failover) and ensures all remaining slaves in the topology get attached under the new master...
MySQL Replication Failover – Maxscale vs MHA: Part One
In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach...
Architecting for Failure – Disaster Recovery of MySQL Galera Cluster
Failure is a fact of life, and cannot be avoided. No IT vendor in their right mind will claim 100% system availability, although some might claim several nines :-) We might have armies of ops...