Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.37
-
None
-
Slackware Linux 14.1
Description
I have a MySQL master server, lets call it MYSQL.
Furthermore I have another server, which runs MariaDB. Let's call it MariaDB.
MariaDB server acts as a slave. I have the following in /etc/my.cnf.d/server.cnf:
replicate-wild-ignore-table = %.trades,%.cacheable,mysql.user
I can confirm that SHOW SLAVE STATUS shows this:
Replicate_Wild_Ignore_Table: %.trades,%.cacheable,mysql.user
However, the slave MariaDB server replicates everything from MYSQL master, even the tables which it shouldn't. However, if I execute the following commands on MariaDB slave, it magically starts to work correctly (replicates only the tables not mentioned in wild ignore):
STOP SLAVE;
set global replicate_wild_ignore_table="%.trades,%.cacheable,mysql.user";
START SLAVE;
Again, show slave status still reports the same:
Replicate_Wild_Ignore_Table: %.trades,%.cacheable,mysql.user
I consider this a bug. It should ignore the tables in replication right from the start. By the way, if that matters, the mariadb slave is also configured to store statements in its binary log (as like it will be used as master some time later). Just a note. Attached is the content of file /etc/my.cnf.d/server.cnf (copy&pasted in windows, so probably with wrong CRLF newlines, ignore that)