Comments - Replication Filters
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Replication filters not working. IDK how to make them working...
On master i do CREATE USER 'replica'@'%' IDENTIFIED BY 'replica@'; GRANT REPLICATION SLAVE ON *.* TO 'replica'@'%'; FLUSH PRIVILEGES; FLUSH TABLES WITH READ LOCK; SELECT @@global.gtid_binlog_pos;
On slave i do
SET GLOBAL gtid_slave_pos = "0-1-2"; CHANGE MASTER TO master_host = "master.mdb", MASTER_PORT = 3306, master_user = "replica", master_password = "replica@", master_use_gtid=slave_pos; START SLAVE;
Make changes in Tango and Charlie and all see all changes on slave When i add next STOP slave; SET GLOBAL replicate_do_db='Charlie'; START slave; and repeat adding data, nothing changes
what i do wrong?