Mysql的主从复制

深碍√TFBOYSˉ_ 2024-04-03 10:59 63阅读 0赞

#### 文章目录 ####

*  \`MySQL\`的主从复制
 *   *   *   *  \*\*1.需要两台服务器，这里我就创建两个虚拟机\*\*
             *  \*\*2.修改主库的配置文件\*\*
             *  \*\*3.修改从库的配置文件\*\*

--------------------

\*\*加粗样式\*\*

## `MySQL`的主从复制 ##

##### **1.需要两台服务器，这里我就创建两个虚拟机** #####

![image-20220925134340524][]

![image-20220925134437176][]

![image-20220925134514171][]

##### **2.修改主库的配置文件** #####

*第一步*：

`log-bin=mysql-bin #[必须]启用二进制日志`

`server-id=128 #[必须]服务器唯一ID`

![image-20220925134644912][]

*第二步*：

`systemctl restart mysqld`

![image-20220925134815434][]

*第三步*：登录`Mysql`数据库，执行下面`SQL`

`GRANT REPLICATION SLAVE ON *.* to 'xiaoming'@'%' identified by 'Root@123456';`

![image-20220925134901870][]

*第四步*：登录`Mysql`数据库，执行下面`SQL`，记录下结果中File和Position的值

`show master status;`

![image-20220925134941775][]

##### **3.修改从库的配置文件** #####

第一步：`server-id=129 #[必须]服务器唯一ID`

![image-20220925135436733][]

第二步：`systemctl restart mysqld`重启服务

![image-20220925135715620][]

第三步：`change master to master_host='192.168.226.126',master_user='xiaoming',master_password='Root@123456',master_log_file='mysql-bin.000001',master_log_pos=441;`

`<u>start slave;` 启动线程

![image-20220925140828946][]

第四步：登录`Mysql`数据库，执行下面`SQL`，查看从数据库的状态

`show slave status;`

![image-20220925140011301][]

补充：

遇见的错误：

第一步：`cd /var/lib/mysql`

第二步：`rm -rf auto.cnf`

第三步：`systemctl restart mysqld`

[image-20220925134340524]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/ec1f01f796fe432fbf61f14f57f45c3c.png
[image-20220925134437176]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/16bdd33f452248c78940437536dc5064.png
[image-20220925134514171]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/dc0d2fc2e5664a41918d1cf80a9ce126.png
[image-20220925134644912]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/a976bfb1c14447aaa11f6b3ba49099bc.png
[image-20220925134815434]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/3ca123ef72184975aecd88ae0886226f.png
[image-20220925134901870]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/9bf3e39d5dc045eda4d39f3b3d311f9f.png
[image-20220925134941775]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/ff890081ca4949c4a4d35658e730f309.png
[image-20220925135436733]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/4a07c397693c45c8a3701f12b9a2236d.png
[image-20220925135715620]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/4775b4ed91f3464fa0c67bf542b37f2e.png
[image-20220925140828946]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/c410758f89ae49f895149a1425bf63cd.png
[image-20220925140011301]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/003bf34ae285405db47d10c3da16dec3.png