… about different replication formats. These are covered pretty well in the MySQL manual here. Put simply, the events can be one of two types… from the master and one writing relay log on the slave, very rarely copying of replication events is a slower element of the replication. There could…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…MySQL replication between a master and one or more slaves. Upon failure of the master, one of the slaves is manually promoted to the master role and replication on the other slaves…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…know in which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID … from the master and restore it on the slave to set up a new replication server. master > show global variables… it. I will update this post and create a one when we publish a xtrabackup version …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… disk. Similarly, MySQL replication is an asynchronous process and although it is fairly fast at transferring data between the master and the slaves, there is a… budget, complexity is expensive. We will consider two types of setup. The first one is a basic proof of concept of the…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… control environment was simply a Master with log-bin enabled and one slave connected (not semi-sync). Semi…Writes were only done on one node in one colo. Tests I did two different tests to …datacenter system for high availability and disaster recovery than semi-synchronous replication in stock MySQL…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
…master and a commit on the replicas. To understand why, let’s look at what truly synchronous replication means. In truly synchronous replication…two places (on the master and at least one slave). If the master commits but a crash occurs while the master is waiting for acknowledgment from a slave…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master…MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…and off rotation without and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master…slaves lagging and need few minutes to catch up and also not downtime free. When you stopped writing on the master and waiting for slaves…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…can be a master or a slave on asynchronous replication, galera and built-in mysql replication are …one node in a 3 node cluster is synchronizing with the group, are the other two…replication between 2 PXC clusters, with one node being the master from the first cluster, and one node being the slave…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…replication? There is one good way to find out: test it. I fired up my master-and-two-slaves replication sandbox, flushed all the logs, and…
