Showing entries 1 to 2
Displaying posts with tag: slave promotion (reset)
Extend MySQL Master HA (MHA) capabilities with MHA Helper

I have used many tools starting with MMM to be able to manage MySQL replication clusters. Some of the tools require additional tools and complex HA solutions such as Pacemaker and Corosync, or Zookeeper. While other tools do not do the failover well which leaves the slaves in an inconsistent state, MMM would be an example. And I must say that of all the tools I love MySQL Master HA (MHA) the most. MHA is a great tool to manage MySQL replication clusters for the purpose of HA. The most important thing about MHA is that it tries to take...

The post Extend MySQL Master HA (MHA) capabilities with MHA Helper appeared first on ovais.tariq.

New MySQL 5.6 Replication Utilities – mysqlfailover and mysqlrpladmin

With all of the new news coming out right now, it can be easy to miss or overlook some of the new features.

While there’s been a lot of talk about MySQL 5.6 Replication, I specifically wanted to mention the new ‘mysqlfailover’ and ‘mysqlrpladmin’ utilities.

These are two new MySQL replication utilities (results of the new Global Transaction Identifiers (GTIDs) in MySQL 5.6).

Let me quote the MySQL 5.6 Replication article for both of these utilities:


“Provides continuous monitoring of the replication topology, enabling failover to a slave in the event of an outage on the master.

The default behavior is to promote the most up-to-date slave, based on …

[Read more]
Showing entries 1 to 2