使用MySQL 5.6,搭建主从复制。关于5.6的安装,可以参考《MySQL 5.6 rpm安装方法和碰见的问题》。
主库创建slave用户,设置复制权限,
mysql> create user 'slave'@'1.1.1.2' identified by 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> grant replication slave on *.* to 'slave'@'1.1.1.2' identified by 'root';
Query OK, 0 rows affected (0.00 sec)
编辑my.cnf配置文件,设置主库server-id=1,定义需要复制的库为test,忽略mysql数据库
[root@vm-kvm10000-app mysql]# vi /etc/my.cnf
[mysqld]
server-id=1
log-bin=mysql-bin
binlog_do_db=test
binlog_ignore_db=mysql
重启主库MySQL服务,
[root@vm-kvm10000-app mysql]# service mysql restart
Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
看一下主库状态,
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000002 | 120 | test | mysql | |
+------------------+----------+--------------+------------------+-------------------&#