MySQL的Slave备份配置
Master端：
1,分配Slave链接Master的用户权限
mysql> grant replication slave on *.* TO slave_user@"%" identified by '[slave_userpassword]';
2,设置/etc/my.cnf文件
log-bin=mysql-bin
server-id=1
binlog-ignore-db="backup_db"
3, 启动Mysql服务器,显示当前Master状态
show master status;
+------------------+--------------------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+--------------------------+------------------+
| mysql-bin.000112 | 79 | | bakcup_db |
+------------------+--------------------------+------------------+
1 row in set (0.00 sec)
记下 File和Position供Slave使用
4, 关闭MySQL服务器，压缩/var/lib/mysql/bakcup_db 数据库，并拷贝到Slave 端
Slave端配置：
1，编辑/etc/my.cnf
server-id=2
master-host = [IP of Master Server]
master-user = slave_user
master-password = [slave_userpassword]
master-port = 3306
replicate-do-db=bakcup_db
relay-log=slave2-bin
2，启动MySQL
3，mysql--uroot -p登录运行
mysql> STOP SLAVE;
mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000112',
MASTER_LOG_POS=79;
mysql> START SLAVE;
mysql> SHOW SLAVE STATUS;
