… 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 > show…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be applied to… when replicating from an async master, for example like the one described on these two bugs. Galera use writesets to replicate cluster events to the…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… to persist after a crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication… applied to semi-sync is: [On a semi-sync replication master] you can’t commit (at all) more than once per RTT. Applied to… them (anyone obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication with PXC and Galera is no…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… contains new innobackupex –rebuild-threads option that can be used to specify the number of threads started by XtraBackup when rebuilding… changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… modified to a default of 1.0 to allow replication to resume as soon as possible. An example configuration tuning flow control in a master… minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave cluster, therefore, it’s reasonable to increase…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if the active master server has an… that points to the active server of a pair. The passive server has mysqld running and replicating from the active master. In theory, failing over is the simple matter of moving the virtual IP. In practice, it’s slightly more complicated. To…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were … Conflicting prepared statements in multi-master use case could cause node to hang. This was happening due to prepared statement execution loop, …
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention… any easy way to skip a single transaction? There is! Injecting empty transactions. Let’s imagine that the replication in slave server… way to skip some transactions but take in account that by doing this you will end up with data inconsistencies between Master…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
… 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… want 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: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… the ins and outs of what it takes (and means) to migrate to PXC. Expect high level over view of PXC architectures…-Master setup This talks covers the basics of why multi-writing multi-master architectures without a replication technology that somehow prevents or handles replication…
