….0 to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be…_master_slave=YES; gcs.fc_factor=1.0″; Working with flow control What happens during flow control Simply speaking: flow control makes replication… interval small, which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave cluster, therefore, it’s…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
… slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up now with master… to swing slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to stop slave on slave2 and wait a few seconds to make sure master…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n… is! Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error: Last_SQL… doing this you will end up with data inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be applied… differently when replicating from an async master, for example like the one described on these two bugs. Galera use writesets to replicate cluster…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before…. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang. This was happening…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… been made FATAL. Bug fixed #1116177. innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… load growths 50% – Master and slaves will start use 90% of their resources for replication (forget for the second replication being single thread, which… cached in memory by MySQL cache or OS cache. As slaves replicate the same data and often queried in random or round… application. So in which case I would go using simple master slave replication ? – Small database size. Small meaning working set fits in memory…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… are in multi-master replication, the other master should also replicate events : Closer look: Infinite Replication Loop flow: If you have master-master with slaves or if you want to backup one master…
