Slackware Linux 14.1

Hi,

Did you try to configure it according to the documentation?
https://mariadb.com/kb/en/mariadb/mariadb-documentation/replication-cluster-multi-master/replication/replication-and-binary-log-server-system-variables/#replicate_wild_ignore_table

replicate_wild_ignore_table

Description: Slave threads will be prohibited from replicating tables that match the specified wildcard pattern. For example replicate-wild-ignore-table=foo%.bar% will not do updates to tables in databases that start with foo and whose table names start with bar. Will work with cross-database updates. The commandline directive does not accept a comma-delimited list, and needs to be used multiple times to specify multiple wildcard patterns.

Hello, thank you very much for your suggestion. I've already read the documentation and noticed that the command line directive does not accept coma-delimited list. However as I explained in the bug report, I am not specifying wild ignore parameters in command line, but rather in MariaDB configuration file /etc/my.cnf.d/server.cnf

So I tried to do similar thing in the config file, I put there three lines:

replicate-wild-ignore-table = %.trades
replicate-wild-ignore-table = %.cacheable
replicate-wild-ignore-table = mysql.user

After the MariaDB server is restarted, this works - the mentioned tables are indeed ignored during replication, that is what I want.
So I think that either the documentation should be updated so the user understands that he can actually put three these lines in config file, or the MariaDB code should be modified so it accepts comma-delimited list of parameters through the config file.

Thanks

Ian,

Could you please somehow address it and re-phrase the description?
It's presumed and usually understood that what's true for a command-line option is also true for the same option put in a config file, but apparently it's not obvious.

One note to add though.
When the wild ignore tables are specified in config file as comma-delimited list, MariaDB doesn't properly ignore the tables, BUT issuing the "SHOW SLAVE STATUS" statement still shows the comma-delimited list in Replicate_Wild_Ignore_Table: %.trades,%.cacheable,mysql.user ... And the output is the very same as like if the tables are specified one by one. That's confusing.

From my point of view, if mariaDB doesn't understand the comma-delimited list, it SHOULD NOT print that list in SHOW SLAVE STATUS output in the same way as like if it understood it, because in that case people may think that the server understood the list and accepted it, which is not the case.

So updating the documentation is one thing, but fixing the server code is IMHO still necessary, to better handle the situation.

MariaDB (and MySQL, for that matter) understands the list, but it treats it as a single schema name, because a schema name can contain commas. It is specifically documented in MySQL manual.

See http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html

To specify multiple databases you must use multiple instances of this option. Because database names can contain commas, if you supply a comma separated list then the list will be treated as the name of a single database.

SHOW SLAVE STATUS also in this case shows a single schema name containing commas.

The documentation has been updated.