复制单表或者多个表以上,需要使用replicate-do-table参数来实现。
vi /etc/my.cnf
replicate-do-db=db_name
replicate-ignore-db=tb_name
replicate-do-table=db_name.tb_name
有几个表需要复制,就写几条replicate-do-table=
起初没有加db_name. 重启mysql时无法成功,查看日志:
140216 22:56:12 mysqld_safe mysqld from pid file /usr/local/mysql/data/xxx.hichina.com.pid ended
140216 22:56:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
140216 22:56:20 [ERROR] Could not add do table rule ‘TB_NAME’!
确认表名没错,就在/etc/my.cnf中修改要复制的表前加上数据库名,启动解决。
原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/2059.html