30. pt-upgrade


用来测试新老版本数据库对sql的结果是否一致。
两台开发测试数据库,一台是老版本,一台是新版本,来做比较,生产库别用。


pt-upgrade h=192.168.100.101,P=3306,u=admin,p=admin h=192.168.100.103,P=3306,u=admin,p=admin --database db01 pt-upgrade.sql

cat pt-upgrade.sql
select * from t01 where code>1;


#-----------------------------------------------------------------------
# Logs
#-----------------------------------------------------------------------

File: pt-upgrade.sql
Size: 33

#-----------------------------------------------------------------------
# Hosts
#-----------------------------------------------------------------------

host1:

DSN: h=192.168.100.101,P=3306
hostname: server01
MySQL: MySQL Community Server (GPL) 5.7.20

host2:

DSN: h=192.168.100.103,P=3306
hostname: server03
MySQL: MySQL Community Server (GPL) 5.7.20

#-----------------------------------------------------------------------
# Stats
#-----------------------------------------------------------------------

empty_query 1
failed_queries 0
not_select 0
queries_filtered 0
queries_no_diffs 0
queries_read 1
queries_with_diffs 0
queries_with_errors 0

wechat: nick753159 qq: 417966852 email: nzq42@qq.com base: shanghai
原文地址:https://www.cnblogs.com/cyberbit/p/pt-upgrade.html