当前位置:网站首页>Upgrade MySQL 5.1 to 5.611
Upgrade MySQL 5.1 to 5.611
2022-04-23 15:38:00 【franket】
Synchronization after a period of time
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>
Check data consistency
After synchronization , Check consistency , Spot check a key table
[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 ~]#
No inconsistent data found , Consistency check passed
Then find a business low point for business switching
Original address
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231406039159.html
边栏推荐
猜你喜欢
考试考试自用
KNN, kmeans and GMM
今日睡眠质量记录76分
Multitimer V2 reconstruction version | an infinitely scalable software timer
What exactly does the distributed core principle analysis that fascinates Alibaba P8? I was surprised after reading it
基于 TiDB 的 Apache APISIX 高可用配置中心的最佳实践
Mysql database explanation (8)
Detailed explanation of kubernetes (IX) -- actual combat of creating pod with resource allocation list
推荐搜索 常用评价指标
重定向和请求转发详解
随机推荐
什么是CNAS认证?CNAS认可的软件测评中心有哪些?
网站压测工具Apache-ab,webbench,Apache-Jemeter
深度学习——超参数设置
Advantages, disadvantages and selection of activation function
fatal error: torch/extension. h: No such file or directory
redis-shake 使用中遇到的错误整理
自动化测试框架常见类型▏自动化测试就交给软件测评机构
通过 PDO ODBC 将 PHP 连接到 MSSQL
Rsync + inotify remote synchronization
MultiTimer v2 重构版本 | 一款可无限扩展的软件定时器
群体智能自主作业智慧农场项目启动及实施方案论证会议
携号转网最大赢家是中国电信,为何人们嫌弃中国移动和中国联通?
How did the computer reinstall the system? The display has no signal
ICE -- 源码分析
考试考试自用
Node.js ODBC连接PostgreSQL
Detailed explanation of kubernetes (XI) -- label and label selector
mysql乐观锁解决并发冲突
Today's sleep quality record 76 points
服务器中毒了怎么办?服务器怎么防止病毒入侵?