注:需保持2个数据库之间可以通讯
Master端:在my.ini文件中 加入
log-bin =
server-id = 1
binlog-do-db = 同步数据库名称
Slave端: 在my.ini文件中加入
server-id = 2
master-host = 192.168.16.53
master-user = root
master-password = mysql
master-port = 3306
master-connect-retry = 60
replicate-do-db = 同步数据库名称
#replicate-wild-do-table = 同步数据库.同步表
注:修改 salve端 配置的时候,需要把mysql的data 目录下的master.info 删除后重新启动服务才能生效
Master端:my.ini中加入
log-bin =
server-id = 1
binlog-do-db = 16.9数据库
master-host = 192.168.16.53
master-user = root
master-password = mysql
master-port = 3306
master-connect-retry = 60
replicate-do-db = 16.53数据库
Slave配置:
log-bin =
server-id = 2
binlog-do-db = 16.53数据库
master-host = 192.168.16.9
master-user = root
master-password = 888
master-port = 3306
master-connect-retry = 60
replicate-do-db = 15.9数据库
如果是linux可以如上图配置。
如果windows想做数据库同步则可以使用SQLyog工具,中的同步工具
也可以使用