mysql 的主从复制配置

最新推荐文章于 2025-01-07 16:45:41 发布

Little White_007

最新推荐文章于 2025-01-07 16:45:41 发布

阅读量141

点赞数 2

分类专栏： MySQL Linux

MySQL 同时被 2 个专栏收录

3 篇文章

订阅专栏

Linux

3 篇文章

订阅专栏

本文详细介绍了如何在MySQL中配置主从复制，包括创建复制用户、授权、更新主机设置、刷新权限、查看主节点信息及从服务器配置等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先部署多个实例，主实例配置：

mysql> CREATE USER 'repuser1'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT REPLICATION SLAVE ON *.* TO 'repuser1'@'localhost';

mysql> update user set host = '%' where user = 'repuser1';

mysql> flush privileges;

mysql> ALTER USER 'repuser1'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 

mysql> ALTER USER 'repuser1'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; 

mysql> flush privileges;

查看主节点信息：

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------------------------------+ | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set                         |
+------------------+----------+--------------+------------------+-------------------------------------------+ | mysql-bin.000006 |     2888 |              |                  | b7b40a9f-a1cb-11e8-80f3-525400ecc0ac:1-31 |
+------------------+----------+--------------+------------------+-------------------------------------------+ 1 row in set (0.07 sec)

记录File和Position；

从服务器：

mysql> CHANGE MASTER TO MASTER_HOST='localhost',MASTER_PORT=3308,MASTER_USER='repuser1',MASTER_PASSWORD='password',MASTER_LOG_FILE='mysql-bin.000006',MASTER_LOG_POS=1218; //填入对应的File和Position

mysql> start slave; 

mysql> show slave status\G;//查看从节点状态