Linux下Mysql下双机热备份与Mysql群集设置

双机热备份与Mysql群集设置

---

 

环境：

• 操作系统均为：CentOS 5.1
• Mysql SrvA：192.168.232.4
• Mysql SrvB：192.168.232.5

 

配置：

1. Mysql SrvA设置：

[mysqld]

log-bin

binlog-do-db=backup

server-id=1

#指定需要日志的数据库

master-host=192.168.232.5

master-user=backup

master-password=1234

master-port=3306

master-connect-retry=30

replicate-do-db=backup

 

1. Mysql SrvB设置：

[mysqld]

log-bin

binlog-do-db=backup

server-id=2

master-host=192.168.232.4

master-user=backup

master-password=1234

master-port=3306

master-connect-retry=30

replicate-do-db=backup

 

1. Mysql SrvA设置复制用户：

mysql > GRANT ALL ON *.* TO backup@'192.168.232.5' IDENTIFIED BY '1234';

mysql > FLUSH PRIVILEGES;

 

1. Mysql SrvB设置复制用户：

mysql > GRANT ALL ON *.* TO backup@'192.168.232.4' IDENTIFIED BY '1234';

mysql > FLUSH PRIVILEGES;

 

1. Mysql SrvA删除master.info文件：

#rm –rf /usr/local/mysql/var/master.info

 

1. Mysql SrvB删除master.info文件：

#rm –rf /usr/local/mysql/var/master.info