当前位置:网站首页>mysql 5.1升级到5.611
mysql 5.1升级到5.611
2022-04-23 14:06:00 【franket】
同步一段时间过后
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.100.123
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000900
Read_Master_Log_Pos: 766875783
Relay_Log_File: relay-bin.000004
Relay_Log_Pos: 766875942
Relay_Master_Log_File: mysql-bin.000900
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: mysql,feeddb,mytempdb
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 766875783
Relay_Log_Space: 766876148
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 3
Master_UUID:
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
mysql>
检查数据一致性
同步完成后,检查一致性,抽查一个关键表
[root@upgrade-slave ~]# pt-table-checksum --nocheck-replication-filters --nocheck-binlog-format --replicate=test.checksum --tables key_db.users h=upgrade-master,u=root --ask-pass
Enter MySQL password:
Checksumming key_db.users: 8% 05:38 remain
Checksumming key_db.users: 16% 05:13 remain
Checksumming key_db.users: 25% 04:29 remain
Checksumming key_db.users: 35% 03:48 remain
Checksumming key_db.users: 43% 03:20 remain
Checksumming key_db.users: 50% 03:02 remain
Checksumming key_db.users: 55% 02:55 remain
Checksumming key_db.users: 59% 02:45 remain
Checksumming key_db.users: 63% 02:37 remain
Checksumming key_db.users: 68% 02:23 remain
Checksumming key_db.users: 73% 02:04 remain
Checksumming key_db.users: 78% 01:40 remain
Checksumming key_db.users: 84% 01:14 remain
Checksumming key_db.users: 90% 00:48 remain
Checksumming key_db.users: 95% 00:22 remain
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
11-26T22:56:42 0 11 14940167 153 0 562.858 key_db.users
[root@upgrade-slave ~]#
[root@upgrade-slave ~]# pt-table-sync --replicate test.checksum h=upgrade-slave,u=root --ask-pass --sync-to-master --databases=key_db --tables=users --print > /tmp/users.sql
Enter password for upgrade-slave:
[root@upgrade-slave ~]#
[root@upgrade-slave ~]# wc -l /tmp/users.sql
1 /tmp/users.sql
[root@upgrade-slave ~]# cat /tmp/users.sql
[root@upgrade-slave ~]#
没有发现不一致数据,一致性检查通过
然后找一个业务低点进行业务切换
原文地址
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://cloud.tencent.com/developer/article/1986106
边栏推荐
- leetcode--357. Count the number of different figures
- Three point positioning based on ibeacons (wechat applet)
- 使用DialogFragment的一些感受及防踩坑经验(getActivity、getDialog为空,cancelable无效等)
- 烟雾传感器(mq-2)使用详细教程(基于树莓派3b+实现)
- 室内外地图切换(室内基于ibeacons三点定位)
- pthread_ Why does self() repeat
- 不同时间类型的执行计划计算
- 帆软报表设置单元格填报以及根据值的大小进行排名方法
- PySide2
- Jira截取全图
猜你喜欢
随机推荐
可否把模板的头文件和源文件分开编译
VMware Workstation 无法连接到虚拟机。系统找不到指定的文件
HyperBDR云容灾V3.2.1版本发布|支持更多云平台,新增监控告警功能
leetcode--380. O (1) time insertion, deletion and acquisition of random elements
Jmeter安装教程以及我遇到的问题的解决办法
How QT designer adds resource files
更改plsql工具栏的图标大小
DDT+Excel进行接口测试
星界边境文本自动翻译机(高级版)使用说明
FBS (fman build system) packaging
jsp学习3
Postman的安装使用及填坑心得
Understand the concepts of virtual base class, virtual function and pure virtual function (turn)
Nifi 快速安装及文件同步操作
PySide2
There is a mining virus in the server
visio安装报错 1:1935 2:{XXXXXXXX...
浅谈基于openssl的多级证书,Multi-level CA的签发和管理,以及双向认证
星界边境文本自动翻译机使用说明
政务云迁移实践 北明数科使用HyperMotion云迁移产品为某政府单位实施上云迁移项目,15天内完成近百套主机迁移