General Mysql Replication Questions

Problem

We use the following binary log filter for filtering out some schemata.

binlog-ignore-db = mysql, information_schema, test

What is wrong with this filter it somehow does not work: :-(

Solution

there are different things to mention:

• The dash (-) notation is for command line options (--binlog-ignore-db) the underscore (_) is for the MySQL configuration file (binlog_ignore_db = ...). The configuration accepts both but is is not good style.
• Then because MySQL database names can contain special …

Problem

My MySQL Replication Slave is lagging more and more and I have no clue why. This happens since last weekends application change. I see that one Core is running at 100% user time but the I/O system is nearly completely idle. Any help is appreciated!

Solution

I assume this is a known problem related to MySQL Row Based Replication with tables on the Slave without Primary Keys.

Please check:

• If Replication is Row Based (SHOW GLOBAL VARIABLES LIKE ‘binlog_format’; )
• If there are some tables …

Problem

MySQL Replication Slave stuck because its disk run full. After restarting the Slave MySQL replication was broken with the following error:

Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem, or a bug in the …