… Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER… his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial… 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
… if it is disable) and not print the position of slave thread in master logs at all. Here is some old… it: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in… 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…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… MySQL binlog file position 0 15906301, file name ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… the Slave or you’re cloning the 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL …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… innodb_status_fileblogpercona…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
… SLAVE IO Thread will disconnect and try to connect again. Here is the SHOW SLAVE STATUS output after an error: mysql_slave > show slave status\G [...] Slave_IO_Running: Connecting Slave… the number of beats received. mysql_slave > SHOW STATUS LIKE ‘%heartbeat%’; +—————————+——-+ | Variable_name | Value | +—————————+——-+ | Slave_heartbeat_period | 1.000 | | Slave_received_heartbeats | 1476 | +—————————+——-+ Conclusion…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… to your MySQL database. For those who do not have a thorough understanding of the MySQL binary log format or the slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be a daunting task. This talk will show you how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql-bin.000007′, 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 like ‘%temp%’; +————————+——-+ | Variable…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… is done by running SHOW MASTER STATUS – This is binary log position you’ll need to point your MySQL Slaves created from this snapshot… 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…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… to create the function on your slave the replication will be broken. After executing a SHOW SLAVE STATUS you will see a message like… all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this_year…/860910. In a master-master setup a master can show a wrong ‘SHOW SLAVE STATUS‘ output when using SET user-variables and then using…
