…) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script. As… last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial, but… content “Slave_SQL_Running: Yes” is used for to say that this server is a slave, but later the test of “Slave_SQL_Running…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show_relaylog_eventsblogpercona.commanual Com_show_slave_hostsblogpercona.commanual Com_show_slave…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…master_log_pos=207; slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… and 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 on…/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman/5.1/en/change-master-to.html [5…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… (cannot change to 2….Com_begin’, ’0′ ‘Com_change_db’, ’155′ ‘Com_change_master‘, ’0′ ‘Com_check…show_new_master‘, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status‘, ’13834′ ‘Com_show_status‘, ’194766′ ‘Com_show…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… master fairly easily, especially if data is changed on the slave.  It is possible for a statement to execute successfully on a slave… sec) Rows matched: 1 Changed: 1 Warnings: 0 On the slave, SHOW SLAVE STATUS now reports an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By Leave a Comment
…to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE; MASTER…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to restart replication. With slightly modified 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…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… 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 stop; Query…
