… you’re considering the binary log filtering approach, I think it’s safer to set up a relay master (it can be…; on the relay master you add binary log filters; this ensures that the top-level master and its binary logs are fully intact…] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No…: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…_Log_Pos: localhost:(none)> slave stop; Query OK, 0 rows affected (0.00 sec) localhost:(none)> change master to master_log_file=Relay_Master_Log_File,master_log_pos=Exec_Master_Log_Pos Query OK, 0 rows affected (1…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Connect_Retry: 60 Master_Log_File: db01-bin.003814 Read_Master_Log_Pos: 744615652 Relay_Log_File: mysqld-relay-bin.000953 Relay_Log_Pos: 744615788 Relay_Master_Log_File: db01-bin.003814… Thread position in Master logs (Master_Log_File:Read_Master_Log_Pos) and SQL Thread position in Master logs (Relay_Master_Log_File:Exec_Master_Log_Pos). When you…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… | +—————–+——-+ We also want to discard our manually-edited relay log file (as editing such a file manually can lead to further corruption): slave1 [localhost...) # Use Relay_Master_Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno… slave relay log. Examining the output of SHOW SLAVE STATUS, we can see that the slave is currently executing at relay log file: mysql_sandbox25162-relay…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… *************************** 1. row *************************** Master_Log_File: mysql-bin.000006 Read_Master_Log_Pos: 98 Relay_Log_File: mysql_sandbox20551-relay-bin.000028 Relay_Log_Pos: 235 Relay_Master_Log_File: mysql-bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file…
Comment: Troubleshooting Relay Log Corruption in MySQL
October 19, 2012 By 7 Comments
… on a Relay_Master_Log_File which no longer exists, as it has been expired. You can use: Change MASTER to RELAY_LOG_FILE = ‘Relay_Log_File‘, RELAY_LOG_POS = ‘Relay_Log_Pos’; to use the Relay logs…
Comment: Reasons for MySQL Replication Lag
August 13, 2011 By 9 Comments
… production environment and is in use, and has just 2 relay log files while Master B upto yesterday was working and all of… of this and one thing more there is too many relay log files in Master B /var/lib/mysql directory.
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… batch of log records to the database… … InnoDB: Apply batch completed InnoDB: Last 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 says Master_Log_File: binlog.000062 Relay_Log_File…
