… all; # For s0 s0> change master to master_host=’127.0.0.1′,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…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… be in sync with the master Change configuration for all servers and restart them Use CHANGE MASTER TO to instruct all servers to use GTIDs Disable read-only mode This procedure will switch all your servers from regular replication to…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
On Scenario #1, replace “change master to master_port=10001;” with “change master to master_port=10002;”
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
These limitations are part of the reason we decided not to merge MySQL 5.6 global transaction ID into MariaDB. In… is much easier to switch a slave to GTID. Simply STOP SLAVE on the slave server, CHANGE MASTER to make it use GTID to connect, START SLAVE. There is no need for any special configuration or to restart or…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…cluster.conf –addmethod pcmk-redirect percona3 Method pcmk-redirect added to percona3. [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –… Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona1 ] Slaves: [ percona2 percona3 ] We can see that some resources changed this is…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
Stephane, how are you coping with bug#69095 (replication fails with GTID enabled and master changes from SBR to RBR) and bug#69135 (mysql.slave_master_info is not updated) ?
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so your bandwidth requirements… adding the extra nodes. Multicast to the rescue! One way to address this bandwidth constraint is to switch to multicast UDP replication in Galera…, we can see our outbound bandwidth on our master node doesn’t change as we add more nodes when we are using…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… datadir. Follow the usual restore procedure, for example remember to change the permissions to mysql:mysql. 4- Start the new slave from that…-11e2-a604-080027635ef5:1-4″; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… to make RESET SLAVE work as expected: use CHANGE MASTER TO MASTER_HOST=”: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master…, 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=”; ERROR…
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… that points to the active server of a pair. The passive server has mysqld running and replicating from the active master. In…-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on…
