上一篇：MySQL主从同步架构中你所不知道的“坑”（上）本文是上一篇文章的后续介绍，介绍在指定同步中遇到的一些“坑”case指定同步库数据库情况1.binlog_format=ROWmode?mysql>usetestdb;Databasechangedmysql>showtables;+----------------+|Tables_in_testdb|+------------------+|测试01||test1|+----------------+3rowsinset(0.00sec)mysql>insertintotest1values('zhng','man');QueryOK,1rowaffected(0.05sec)mysql>insertintotest1values('meimei','woman');QueryOK,1rowaffected(0.04sec)mysql>select*fromtest1;+--------+-------+|编号|姓名|+--------+--------+|张|男人||郑|男人||美美|woman|+--------+------+3rowsinset(0.00sec)Viewfromdatabasemysql>usetestdb;Databasechangedmysql>showtables;+----------------+|Tables_in_testdb|+-----------------+|测试01||测试1|+----------------+2组中的行（0.01秒）mysql>select*fromtest1;+--------+-------+|编号|姓名|+--------+--------+|张|男人||郑|男人||美美|女人|+------+--------+3rowsinset(0.01sec)2.binlog_format=STATEMENTmode?主库配置如下binlog-do-db=testdb从库配置如下按照replicate-wild-do-table=testdb.%Maindatabaseoperationmysql>createdatabasetestdb;QueryOK,1rowaffected(0.01sec)mysql>usetestdb;Databasechangedmysql>createtabletest01(->idvarchar(10)notnull,->namevarchar(10)notnull->);QueryOK,0rowsaffected(0.04sec)mysql>insertintotest01values('zhang','man');QueryOK,1rowaffected(0.01sec)mysql>从testdb.test01中选择*;+--------+------+|编号|名字|+------+-----+|张|man|+------+-----+1rowinset(0.00sec)Viewmysql>usetestdb;Databasechangedmysql>select*fromtest01;+--------+------+|编号|名字|+------+-----+|张|man|+------+-----+1rowinset(0.00sec)测试默认库是否会同步数据而不指定忽略库mysql>createusertestdb_user;QueryOK,0rows受影响（0.03秒）mysql>selectuserfrommysql.user;+--------------+|用户|+-------------+|testdb_user||mysql.sys||root|+------------+[root@mysql-s~]#mysql-uroot-p-e"selectuserfrommysql.user;"输入密码：+----------+|用户|+------------+|mysql.sys||root|+------------+注意：默认库中的数据没有被同步点击-->移民大哥，关注微信公众号，在对话框中回复关键词box：1024，即可领取最新2048G技术干货：包括系统运维、数据库、redis、MogoDB、电子书、Java基础课程、Java实战项目、架构师综合教程、架构师实战项目、大数据、Docker容器、ELKStack、机器学习、BAT面试精华Speaking视频等。
