mysql主从同步，设置同步部分数据库

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

来源：https://mariadb.com/kb/en/mariadb/dynamic-replication-variables/

官网关于主从同步教程

来源：https://mariadb.com/kb/en/mariadb/replication-cluster-multi-master/