… from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before…. Bugs fixed #1131189 (Alexey Kopytov). In the event that a slave was disconnected from the master, under certain conditions, upon reconnect… would report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
…’t stop replication on RDS read replica, because you don’t have (and won’t get) privileges to do that: replica> STOP SLAVE…); master> INSERT INTO percona.test VALUES (1); replica> show slave status\G … Slave_SQL_Running: No Last_Error: Error ‘Duplicate entry ’1′ for… procedure, you can try removing the conflicting record from replication slave and replication should resume shortly. That worked for me.
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
…:31 Reconnected to slave 2012-09-10T12:40:31 slave running 83 seconds behind 2012-09-10T12:40:31 STOP SLAVE until 2012-09-10T12:49:08 at master position mysql-bin.000001/83915317 2012-09-10T12:41:31 Reconnected to slave 2012-09-10T12:41:31 slave stopped at master position mysql-bin.000001/100072820 [...] 2012-09-10T12:49:31 START SLAVE until…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… executed. Then that event is replicated to the slaves (the I/O slave thread filters out only the events with a different… try to skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again. This method is not… Server 3 is a normal slave Step1 Stop the replication on the active master (server 1): mysql> stop slave; Step 2: there are writes…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… is executed on the slave. The easiest way is to stop the SQL thread: slave1 [localhost] {msandbox} ((none)) > stop slave sql_thread; Query OK…)) > stop slave; Query OK, 0 rows affected (0,01 sec) # Use Relay_Master_Log_File and Exec_Master_Log_Pos from SHOW SLAVE… slaves, the corruption will be obvious as replication will stop with an error: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: No Slave…
Post: MySQL and predictive option handling - beware
October 29, 2012 By 2 Comments
… stop the server while mysqladmin uses “shutdown”. I mixed this while trying to stop Percona Server: root@smt2:/var/lib/mysql# mysqladmin stop Slave stopped It would be quite confusing if mysqladmin would have “stop” command…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…’t see it coming. Especially if the slave‘s load is pretty uniform, a slave that’s at 90% of its capacity… how steep the backside of that slope is. If you stop a slave for an hour, then start it again and it… threads on the slave) to see how much of the time the slave thread was actively processing statements. If the slave threads are…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… as “writer” and roles stay consistent. 2. on db1: stop replication mysql> STOP SLAVE; we don’t want schema changes to be replicated…: 4. on db2: start replication mysql> START SLAVE; On step #1 MMM should have stopped db1 => db2 replication so at this stage… to go. 6.1 on db1: start replication mysql> START SLAVE; db1 will receive the updates that were executed by changes…
Comment: The new cool MySQL patch has landed! Check your queries performance!
December 17, 2007 By 16 Comments
… seeing the slave thread stop logging (though not stop executing) after a particular query. If I do a STOP SLAVE and then START SLAVE, the log…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
June 21, 2012 By 102 Comments
…. When promoting a server as new master, its “slave” state should be resetted (“show slave status” should be empty). This would help…, with one slave stopped). If I had to do it (I will try in my test setup), I would do “stop slave; change master to master_host=”, master_user=”, master_password=”; reset slave;”. Thanks, SLiX.
