…_vip (ocf::heartbeat:IPaddr2): Started percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after…) Master/Slave Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try… 3130 [ERROR] Slave I/O: The slave IO thread stops because the master has GTID_MODE OFF and this server has GTID…: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…’,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…t really much different from standard mysql replication. 1 master with 5 async slaves is…mysql]# service mysql stop [root@node2 mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… are part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In MariaDB global… to switch a slave to GTID. Simply STOP SLAVE on the slave server, CHANGE MASTER to make it use GTID to connect…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… as expected: use CHANGE MASTER TO MASTER_HOST=”: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master_host=”; Query OK…, the CHANGE MASTER TO MASTER_HOST=” trick no longer works: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master to master_host…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… empty transaction with it the GTID we want to skip. STOP SLAVE; SET GTID_NEXT=”7d72f9b4-8577-11e2-a3d7-080027635ef5:5… inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… can be behind committing transactions from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES… control Simply speaking: flow control makes replication stop, and therefore makes writes (which are synchronous) stop, on all nodes until flow control…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of… that a slave was disconnected from the master, under certain conditions, upon reconnect, it would…Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help…
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… make it a chain replication , master => slave 1 = > slave 2. The only option I see to stop slave on slave2 and wait… to make sure master_log_position on slave 1 is ahead of slave 2 and stop slave 2, take the master positions off…
