简单搭建Mysql主从同步

最新推荐文章于 2025-08-22 11:53:05 发布

原创最新推荐文章于 2025-08-22 11:53:05 发布 · 285 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

26 篇文章

订阅专栏

本文详细介绍了如何在CentOS环境下配置MySQL主从同步。主要内容包括：安装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;

+------------------+----------+--------------+------------------+

+------------------+----------+--------------+------------------+

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