… these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try… replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal…’,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> start slave; Those of you who have already done these operations with file-based replication know…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database… 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…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication… async replication you have the luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag for…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER… inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last week… an overview of MySQL 5.6 GTID that can help people to start working with this new feature in MySQL 5.6. Here are…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… a replication slave? In short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run STOP SLAVE and then RESET SLAVE…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…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: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It… logic (I usually get less than 5 people who do out of 100). …obsessively testing slave position to ensure it’s caught up with the master?). Synchronous replication with …
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6… the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed by not…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… node giving the cluster permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below… to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set…
