… 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_host… my.cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql> stop slave; Query OK…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… from the cluster. gcs.fc_master_slave The fc_limit is modified dynamically if you have fc_master_slave disabled (which it is by… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc… a master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only lagging nodes will be the slaves with…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be…. However, this may work differently when replicating from an async master, for example like the one described on these two bugs…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then… inconsistencies between Master and Slave servers. pt-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last week…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… slave was disconnected from the master, under certain conditions, upon reconnect, it would report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… been made FATAL. Bug fixed #1116177. innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available. Fixed…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running…. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang. This was happening…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day… be run against Amazon RDS instances? A: It depends. Most MySQL tools can connect to remote hosts and will work with… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended the MySQL webinar!
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
Is mysql ‘start slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their master? I have a set up… swing slave 2 behind slave1 to make it a chain replication , master => slave 1 = > slave 2. The only option I see to stop slave on slave2 and wait a few seconds to make sure master_log…
