During the administration and performance tuning of a Percona Cluster, it’s common to configure different parameters on individual nodes. To ensure consistency and maintain synchronization across all nodes, you can use the following command to compare configuration settings:
pt-config-diff h=<node1> h=<node2> h=<node3> -u <user> -p <password>
This command helps identify configuration differences between nodes, making it easier to keep your cluster settings aligned and optimized.
The output of the command looks like this:
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...