… should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys can…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… 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…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which it is by… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs… a master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only lagging nodes will be the slaves with…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master… slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry: 60 Master_Log_File: Read_Master…
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… 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_log…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… Executed_Gtid_Set from the SHOW SLAVE OUTPUT as we can see in the example. This slave server has retrieved transactions 1…-8577-11e2-a3d7-080027635ef5:1-5 After the START SLAVE the slave checks that transaction 5 is already in its own binary… doing this you will end up with data inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…? I am running mysqlslap against a galera-head of a master/master pair right now and don’t see the same kind… or mariadb 5.5 on the same hardware in a master/slave. I wonder if it is writing as synchronous? I was…
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… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed…
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… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed…
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…, an event will not be written to the slave‘s binary unless log_slave_updates is enabled, this is similar to Percona…
