主配置:
/etc/my.cnf
log-bin=mysql-bin #配置二进制日志
server-id = 128 #配置server ID
从配置:
/etc/my.cnf
server-id = 129
relay-log=mysql-relay
授权:
mysql> grant replication client,replication slave on *.*
-> to 'repl'@'192.168.%.%' //分配账号,@在那些ip发挥作用
-> identified by 'repl';//密码
查看主配置最后使用的二进制日子
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000066 | 268 | | |
+------------------+----------+--------------+------------------+
通知从服务器配置:
mysql> change master to master_host='192.168.140.128',
-> master_user='repl',master_password='repl',
-> master_log_file='mysql-bin.000066',
-> master_log_pos=268;
Query OK, 0 rows affected (0.03 sec)
查看状态:
show slave status \G
启动slave:
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
到此配置成功,然后测试:主server
mysql> create database testdb charset utf8;
Query OK, 1 row affected (0.01 sec)
从server :
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| testdb |
+--------------------+