… debug async replication while its broken or do the master-master/master-slave switchover when master is dying/dead. Yes, there are wrappers/scripts around…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… writer_vip (ocf::heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /etc/redhat… writer_vip (ocf::heartbeat:IPaddr2): Started percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… slave host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… a slave s1> stop slave; s1> reset slave all; # For s0 s0> change master to master_host=’127.0.0.1′,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR] Slave I/O: The slave IO… GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… master (it can be on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the bottom of the replication topology. On the top-level master, you leave all filters disabled; on the relay master…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to… the luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag for a bit, not…/s So, we can see our outbound bandwidth on our master node doesn’t change as we add more nodes when…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 22, 2013 By 8 Comments
… 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…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…, because multi-threaded slave may put events in a different order on one slave than on another (or on the master). So in… missing. Well, if the user is not using multi-threaded slave, perhaps the notion of “last executed” and “specific point” does…
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) ?
