MySQL数据库实现主从同步数据
发布日期：2025-04-17 23:06:27
浏览次数：27
分类：精选文章
本文共 1275 字，大约阅读时间需要 4 分钟。
MySQL ???????????
1. ??
???????????????????????????????????????????????????????? MySQL ???????????????????
2. ????
??????? MySQL ???????????????????
??
- ?????????????????????
- ???????????????????????????
????
- IP?????????????? IP ???????
- ????????????? MySQL ?????? 3306????
3. ??????
1. ??????
??????????? my.ini ? my.cnf ???
2. ??????
? [mysqld] ?????????
# ???????log-bin = mysql-bin# ???????? ID????? IP ???????server-id = 203# ??????binlog-do-db = refrigrator
3. ????
???? GRANT ?????Slave ???
GRANT REPLICATION SLAVE ON *.* TO 'myaccount'@'%' IDENTIFIED BY '123456';
4. ????????
???????????????
SHOW MASTER STATUS;
4. ??????
1. ??????
? [mysqld] ?????????
# ???????log-bin = mysql-bin# ???????? ID????? IP ???????server-id = 130
2. Slave ????
?????????????? Slave?
CHANGE MASTER TO MASTER_HOST='10.10.107.203', MASTER_USER='myaccount', MASTER_PASSWORD='123456', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=107;
3. ??Slave ??
????????Slave ???
SHOW SLAVE STATUS;
5. ????
???????????????????
1. ???????
?????????????????????????
2. ??????
?????????????????
3. ????
????????????? MySQL ???????????????????
6. ????
- ??????????????????????????????
- ????????????????????????????
- ???????Slave ????????????????????
??????????? MySQL ???????????????????????????
发表评论
最新留言
不错！
[***.144.177.141]2026年06月23日 18时46分42秒
关于作者
喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！
-- 愿君每日到此一游！
推荐文章
白红宇的个人博客 - 记录点点滴滴的事 - 您是第 475230412 位访客