mysql 基于 master-master 的双机热备配置
master-master 就是两台服务器互为主从:
master1-slave(master2) && master2-slave(master1)
- master1: 192.168.100.191
- master2: 192.168.100.166
master1-slave(master2)
mysql 版本最好一致
设置 master1
-
创建给 slave 登录用的用户名密码:
mysql> GRANT REPLICATION SLAVE ON *.* TO 'backup'@'192.168.100.166' IDENTIFIED BY 'yNZE7fK9*@aMA?*ppF'; # humanreadable mysql> # grant replication slave on *.* to 'backup'@'192 ...