… 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… in 5.5.31 will handle them all, also XB 2.1 is required for most). Finally, the HAProxy. HAProxy is one…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… reconfigure the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR] Slave I/O: The slave IO thread stops because the master has… 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: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… (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… (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql): Slave percona3 (unmanaged) And…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… here. Our goal will be to go from setup #1 to setup #2 on the picture below, following various scenarios: For these….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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… you’ll get roughly 1.67x the throughput of a single port. [Don’t try more than 2; the additional work that…) 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
…’t 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… and measuring the outbound (UP) bandwidth on that same node: # 2 nodes in the cluster eth1 DOWN:24 KB/s UP…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-…slave host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…Yves: 1. Yes, it is not easy going from Linux to illumos … to have LZ4 compressed persistent L2ARC, which is coming soon. 2. OmniOS rocks. It is the only stable illumos distro designed…-1 costs a lot. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to the backup: # innobackupex …MASTER TO 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…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed…
