← Back to team overview

maria-discuss team mailing list archive

Re: after set replicate_wild_do_table, binlog file could not update ?

 

Hi,

On Fri, Jul 15, 2016 at 9:13 PM, Ljr Yang <dbmsprog@xxxxxxxxx> 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-variables/#replicate_wild_do_table

"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


References