MySQL 2个数据库之间的共享

来源：互联网发布：淘宝企业店铺提现编辑：程序博客网时间：2024/06/05 14:20

注：需保持2个数据库之间可以通讯

Master端：在my.ini文件中加入

log-bin = server-id = 1binlog-do-db = 同步数据库名称

Slave端：在my.ini文件中加入

server-id = 2master-host = 192.168.16.53master-user = rootmaster-password = mysqlmaster-port = 3306master-connect-retry = 60replicate-do-db = 同步数据库名称#replicate-wild-do-table = 同步数据库.同步表

注：修改 salve端配置的时候，需要把mysql的data 目录下的master.info 删除后重新启动服务才能生效

Master端：my.ini中加入

log-bin = server-id = 1binlog-do-db = 16.9数据库master-host = 192.168.16.53master-user = rootmaster-password = mysqlmaster-port = 3306master-connect-retry = 60replicate-do-db = 16.53数据库

Slave配置：

log-bin = server-id = 2binlog-do-db = 16.53数据库master-host = 192.168.16.9master-user = rootmaster-password = 888master-port = 3306master-connect-retry = 60replicate-do-db = 15.9数据库

很久以前弄得了，估计现在早过时了....

0 0