简单搭建Mysql主从同步

设置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)