Compare config files of all nodes in Percona cluster

During administration and performance tuning of your percona cluster you often set some parameters on one node and different parameters on another node.
 
This is the command, which will help you to compare all configs and help you to keep them synchronized:
 
pt-config-diff h=<node1> h=<node2> h=<node3> -u <user> -p <password>

Output of the command willl looks like:

15 config differences

Variable                  ...ualityunit.com ...ualityunit.com ...ualityunit.co

========================= ================= ================= ================

auto_increment_offset     1                 2                 3

base_host                 172.17.1.120      172.17.1.121      172.17.1.122

datadir                   /home/mysql/      /var/lib/mysql/   /var/lib/mysql/

gcache.dir                /home/mysql/      /var/lib/mysql/   /var/lib/mysql/

gcache.name               /home/mysql//g... /var/lib/mysql... /var/lib/mysq...

general_log_file          /home/mysql/pd... /var/lib/mysql... /var/lib/mysq...

hostname                  pdb1.lqw1.qual... pdb2.lqw1.qual... pdb3.lqw1.qua...

ist.recv_addr             172.17.1.120      172.17.1.121      172.17.1.122

pid_file                  /home/mysql/pd... /var/lib/mysql... /var/lib/mysq...

server_uuid               f07d3252-4810-... 7cf7d409-3cfd-... d7244054-4814...

slow_query_log_file       /home/mysql/pd... /var/lib/mysql... /var/lib/mysq...

wsrep_data_home_dir       /home/mysql/      /var/lib/mysql/   /var/lib/mysql/

wsrep_node_address        172.17.1.120      172.17.1.121      172.17.1.122

wsrep_node_name           nod1.aaa1.qual... nod2.aaa1.qual... nod3.aaa1.qua...

 

wsrep_start_position      746116c5-3c41-... 746116c5-3c41-... 746116c5-3c41...

 

×