…’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script… last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial, but… for to say that this server is a slave, but later the test of “Slave_SQL_Running: Yes” fails, because the server…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062 Relay_Log…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… it is disable) and not print the position of slave thread in master logs at all. Here is some old post of… FLUSH TABLES WITH READ LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that info…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… on the master ? If logs on the master are OK you can just run SHOW SLAVE STATUS on slave experiencing error and use CHANGE MASTER TO to re-point replication to Relay_Master_Log_File:Exec_Master_Log_Pos: localhost:(none)> slave…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… on the Master to bring up first slave. This command output is pretty simple and leaves no room for mistakes: mysql> show master status \G… to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_function_statusblogpercona.commanual Com_show_grantsblogpercona.commanual Com_show_innodb_statusblogpercona.commanual Com_show_keysblogpercona.commanual Com_show_logsblogpercona.commanual Com_show_master_statusblogpercona.commanual Com_show…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… the passive master has executed the looping statements and pick up a position from SHOW MASTER STATUS on the master still replicating, change the master with… the master position is increased… Step 6: the slave position on the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… Here is the SHOW SLAVE STATUS output after an error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave_SQL_Running: Yes [...] Last_IO_Errno: 2003 Last_IO_Error: error reconnecting to master…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… process you can clone slaves from the slaves without stopping them – you just need to use SHOW SLAVE STATUS instead of SHOW MASTER STATUS to find out appropriate binary log position. Be careful however – cloning slave from the slave also clones…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… based replication slave can get out of sync with the master fairly easily, especially if data is changed on the slave. … slave, SHOW SLAVE STATUS now reports an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave…
