主从Mysql配置

来源:互联网 发布:淘宝有什么促销活动 编辑:程序博客网 时间:2024/05/16 17:46
主从Mysql配置:
Master(ip:192.168.79.110):
my.ini
log-bin=mysql-bin
server-id=1
binlog-ignore-db=mysql
binlog-do-db=radius
sql
GRANT FILE,SELECT,REPLICATION SLAVE ON *.* TO backup@192.168.79.13 IDENTIFIED BY '123456';
Slave(ip:192.168.79.13):
my.ini
server-id=2
master-host=192.168.79.110
master-port=3306
master-user=backup
master-password=123456
master-connect-retry=60
replicate-do-db=radius
原创粉丝点击