[MDEV-9174] When "replicate_do_db" and "replicate_wild_do_table" both specified,both options will be invalid Created: 2015-11-24  Updated: 2015-12-25  Resolved: 2015-12-25

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.0.22
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: guo feng Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

CentOS 7(X64)


 Description   

In a slave I just want to replicate two types of database from master, so I use following SQL to replicate mydb1 and mydb2, but result is no database is been replicated!

STOP SLAVE;
 
SET GLOBAL replicate_do_db = "mydb1";
 
SET GLOBAL replicate_wild_ignore_table = "mydb2.tb%";
 
START SLAVE;



 Comments   
Comment by Elena Stepanova [ 2015-12-25 ]

You haven't specified which binlog format you are using. I've checked STATEMENT, works all right for me.

Please make sure that you understand very clearly how these options work; it is nothing like what a person would intuitively expect. There is extensive documentation about it, if you have never read it before, I recommend MySQL manual, it's very detailed.

If after studying documentation you still think that in reality it works differently, please comment to re-open the issue.

Generated at Thu Feb 08 07:32:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.