… prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix…::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically the steps are: Make the master read-only…: # 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 test…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication …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
… it possible to replicate only some tables from master to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to set… monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it and attempt to run…
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) ?
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
…’t be able to use the GTID features to automatically pick the correct binlog position when switching to a new master. Old-style replication will work. That being said, I agree that compatibility is good. If you have any suggestion of how to make MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration…/pt-table-sync, to check if data on replicas is in sync with data on the master pt-stalk, to gather data when… to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times How to…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… how do you safely disconnect a replication slave? In short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST… 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…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
….0 to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql… expensive replication conflicts more likely and therefore time-consuming to the application. How to tell if flow control is happening and where it…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… the step-by-step guide on how to create a new GTID based slave…mysql‘s datadir. Follow the usual restore procedure, for example remember to change the permissions to mysql:mysql…slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION …
