… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much… law applied to semi-sync is: [On a semi-sync replication master] you can’t commit (at all) more than once per… slave position to ensure it’s caught up with the master?). Synchronous replication with PXC and Galera is no different in that…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous…? There is! Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error… doing this you will end up with data inconsistencies between Master and Slave servers. pt-table-checksum can help you here…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… it needs replication to pause and when it is ready for replication to continue. This prevents any node in the synchronous replication group….0 to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might… interval small, which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave cluster, therefore, it…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… the cluster node acting as async slave for replicated events from the async master to be applied to the other nodes, that… differently when replicating from an async master, for example like the one described on these two bugs. Galera use writesets to replicate cluster… jobs and getting them through the replication stream expect some replication lag. This is because because synchronous replication inside PXC has an additional…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… straightforward. 1- Take a backup from any server on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there…”; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
… master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up now with master… swing slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to… ahead of slave 2 and stop slave 2, take the master positions off of it and start slave until these positions…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if the active master server has an… a pair. The passive server has mysqld running and replicating from the active master. In theory, failing over is the simple matter…. The standby server does not process query traffic except for replication. The buffer pool and adaptive hash index on the standby…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
…-Master setup This talks covers the basics of why multi-writing multi-master architectures without a replication technology that somehow prevents or handles replication… considered an architecture that uses standard MySQL async replication with any kind of circular replication and multi-node simultaneous writing, you should…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… (Alex Yurchenko). Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo…. 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…
