设置mysql主从同步
centos01
|
mysql从服务器 192.168.1.20
|
centos02
|
mysql主服务器 192.168.1.21
|
安装主服务器并修改root密码
[root@centos02 ~]# yum -y install mysql mysql-server
[root@centos02 ~]# vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=111
[root@centos02 ~]# service mysqld start
[root@centos02 ~]# mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)
安装从服务器并修改root密码
[root@centos01 ~]# yum -y install mysql mysql-server
[root@centos01 ~]# vi /etc/my.cnf
[mysqld]
log-bin=mysql-bin
server-id=222
[root@centos01 ~]# service mysqld start
[root@centos01 ~]# mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost'=PASSWORD('123456');
Query OK, 0 rows affected (0.00 sec)
主服务器设置
[root@centos02 etc]# mysql -uroot -p123456
mysql> GRANT REPLICATION SLAVE ON *.* to 'mysync'@'%' identified by 'q123456';
Query OK, 0 rows affected (0.02 sec)
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 251 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.01 sec)
从服务器设置
[root@centos01 ~]# mysql -uroot -p123456
mysql> change master to master_host='192.168.1.21',master_user='mysync',master_password='q123456',master_log_file='mysql-bin.000001',master_log_pos=251;
Query OK, 0 rows affected (0.04 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)