… rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if the active master server has… -q -O – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set… 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
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … 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…
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: 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…? There is! Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error… inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… 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…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…restore procedure, for example remember to change the permissions to mysql:mysql. 4- Start the new slave from that GTID position: … 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…
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…an architecture that uses standard MySQL async replication with any kind of circular replication and multi-node simultaneous writing,…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
Is mysql ‘start 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… swing slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to…
