pt-config-diff

pt-config-diff的功能是diff不同的MySQL配置文件以及不同的服务器变量设置

本地与远程服务器配置对比

[root@tcandyj bin]# pt-config-diff h=localhost,P=38383,u="root",p="wtc.com"  h=$ip,P=38383,u="root",p="wtc.com" --report-width=200
17 config differences
Variable                   tcandyj                                 iZ2ze2yo6lh2hmy6pm4wafZ
========================== ======================================= =======================================================
datadir                    /opt/app/mysql/data/                    /opt/mysql/data/
general_log_file           /opt/app/mysql/data/tcandyj.log         /opt/mysql/data/iZ2ze2yo6lh2hmy6pm4wafZ.log
hostname                   tcandyj                                 iZ2ze2yo6lh2hmy6pm4wafZ
innodb_log_group_home_dir  /opt/app/mysql/redolog                  /opt/mysql/redolog
innodb_undo_directory      /opt/app/mysql/undolog                  /opt/mysql/undolog
innodb_version             5.7.37                                  5.7.36
log_bin_basename           /opt/app/mysql/binlog/mysql-bin         /opt/mysql/binlog/mysql-bin
log_bin_index              /opt/app/mysql/binlog/mysql-bin.index   /opt/mysql/binlog/mysql-bin.index
log_error                  /opt/app/mysql/log/mysqld.log           /opt/mysql/log/mysqld.log
relay_log                  /opt/app/mysql/relaylog/relay-log       
relay_log_basename         /opt/app/mysql/relaylog/relay-log       /opt/mysql/data/iZ2ze2yo6lh2hmy6pm4wafZ-relay-bin
relay_log_index            /opt/app/mysql/relaylog/relay-log.index /opt/mysql/data/iZ2ze2yo6lh2hmy6pm4wafZ-relay-bin.index
server_id                  2                                       1
server_uuid                c7d079fa-7a89-11ec-afb4-00163e35e84d    122574bd-7926-11ec-85dc-00163e366a62
slow_query_log_file        /opt/app/mysql/data/tcandyj-slow.log    /opt/mysql/data/iZ2ze2yo6lh2hmy6pm4wafZ-slow.log
socket                     /opt/app/mysql/socket/mysql.sock        /opt/mysql/socket/mysql.sock
version                    5.7.37-log                              5.7.36-log

本地与本地配置进行对比

[root@tcandyj bin]# pt-config-diff /etc/my.cnf /etc/my.cnf1 
2 config differences
Variable                  /etc/my.cnf /etc/my.cnf1
========================= =========== ============
binlog_format             row         statement
innodb_file_per_table     ON          OFF

本地配置文件与服务器配置对比

[root@tcandyj bin]# pt-config-diff /etc/my.cnf h=$ip,P=38383,u="root",p="wtc.com" --report-width=200
8 config differences
Variable                   /etc/my.cnf                       iZ2ze2yo6lh2hmy6pm4wafZ
========================== ================================= ============================
datadir                    /opt/app/mysql/data/              /opt/mysql/data/
innodb_log_group_home_dir  /opt/app/mysql/redolog            /opt/mysql/redolog
innodb_undo_directory      /opt/app/mysql/undolog            /opt/mysql/undolog
log_error                  /opt/app/mysql/log/mysqld.log     /opt/mysql/log/mysqld.log
pid_file                   /opt/app/mysql/pid/mysql.pid      /var/run/mysqld/mysqld.pid
relay_log                  /opt/app/mysql/relaylog/relay-log 
server_id                  2                                 1
socket                     /opt/app/mysql/socket/mysql.sock  /opt/mysql/socket/mysql.sock