[Maria-discuss] after set replicate_wild_do_table, binlog file could not update ?
Hi, all Today, we setup new master/slave (both MariaDB 10.1.14), add log_slave_updates=1, log_bin , relay_log parameters in slave's my.cnf file. in mariadb client , execute below command, when master update, slave replication normal , and log_bin and relay_log file could update normal too. stop slave; set global replicate_wild_do_table='test01.%,mysql.%' ; start slave; IF add replicate_wild_do_table='test01.%,mysql.%' in slave's my.cnf file and restart salve, replication normal, relay_log file could update, but log_bin file could not update. we test four machines, all have the problem . Please help confirm ,thanks . Ljr
Hi, On Fri, Jul 15, 2016 at 9:13 PM, Ljr Yang <dbmsprog@gmail.com> wrote:
IF add replicate_wild_do_table='test01.%,mysql.%' in slave's my.cnf file and restart salve, replication normal, relay_log file could update, but log_bin file could not update.
You cannot specify more than one pattern here. You need to use this option more than one time. https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-v... "The directive does not accept a comma-delimited list, and needs to be used multiple times to specify multiple wildcard patterns (on both the commandline and in configuration files)." Hope this helps. -will -- Will Fong, Senior Support Engineer MariaDB Corporation
participants (2)
-
Ljr Yang
-
Will Fong