**Percona XtraDB Cluster(PXC 5.7)
1#配置pxc清华yum源并安装 2[root@pxc1 ~]#vim /etc/yum.repos.d/pxc.repo 3[percona] 4name=percona_repo 5baseurl =https://mirrors.tuna.tsinghua.edu.cn/percona/release/$releasever/RPMS/$basearch 6enabled = 1 7gpgcheck = 0 8 9[root@pxc1 ~]#scp /etc/yum.repos.d/pxc.repo 10.0.0.17:/etc/yum.repos.d/ 10[root@pxc1 ~]#scp /etc/yum.repos.d/pxc.repo 10.0.0.27:/etc/yum.repos.d/ 11[root@pxc1 ~]#scp /etc/yum.repos.d/pxc.repo 10.0.0.37:/etc/yum.repos.d/ 12 13[root@pxc1 ~]#yum install Percona-XtraDB-Cluster-57 -y 14[root@pxc2 ~]#yum install Percona-XtraDB-Cluster-57 -y 15[root@pxc3 ~]#yum install Percona-XtraDB-Cluster-57 -y 16[root@pxc4 ~]#yum install Percona-XtraDB-Cluster-57 -y 17 18#配置各个节点mysql和集群配置文件 19[root@pxc1 ~]#vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf 20[mysqld] 21server-id=7 22datadir=/var/lib/mysql 23socket=/var/lib/mysql/mysql.sock 24log-error=/var/log/mysqld.log 25pid-file=/var/run/mysqld/mysqld.pid 26log-bin 27log_slave_updates 28expire_logs_days=7 29 30[root@pxc2 ~]#vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf 31[mysqld] 32server-id=17 33datadir=/var/lib/mysql 34socket=/var/lib/mysql/mysql.sock 35log-error=/var/log/mysqld.log 36pid-file=/var/run/mysqld/mysqld.pid 37log-bin 38log_slave_updates 39expire_logs_days=7 40 41[root@pxc3 ~]#vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf 42[mysqld] 43server-id=27 44datadir=/var/lib/mysql 45socket=/var/lib/mysql/mysql.sock 46log-error=/var/log/mysqld.log 47pid-file=/var/run/mysqld/mysqld.pid 48log-bin 49log_slave_updates 50expire_logs_days=7 51 52[root@pxc4 ~]#vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf 53[mysqld] 54server-id=37 55datadir=/var/lib/mysql 56socket=/var/lib/mysql/mysql.sock 57log-error=/var/log/mysqld.log 58pid-file=/var/run/mysqld/mysqld.pid 59log-bin 60log_slave_updates 61expire_logs_days=7 62 63[root@pxc1 ~]#vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 64[root@pxc1 ~]#grep -Ev "^#|^$" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 65[mysqld] 66wsrep_provider=/usr/lib64/galera3/libgalera_smm.so 67wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27 68binlog_format=ROW 69default_storage_engine=InnoDB 70wsrep_slave_threads= 8 71wsrep_log_conflicts 72innodb_autoinc_lock_mode=2 73wsrep_node_address=10.0.0.7 74wsrep_cluster_name=pxc-cluster 75wsrep_node_name=pxc-cluster-node-1 76pxc_strict_mode=ENFORCING 77wsrep_sst_method=xtrabackup-v2 78wsrep_sst_auth="sstuser:s3cretPass" 79 80[root@pxc2 ~]#vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 81[root@pxc2 ~]# 82[root@pxc2 ~]#grep -Ev "^#|^$" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 83[mysqld] 84wsrep_provider=/usr/lib64/galera3/libgalera_smm.so 85wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27 86binlog_format=ROW 87default_storage_engine=InnoDB 88wsrep_slave_threads= 8 89wsrep_log_conflicts 90innodb_autoinc_lock_mode=2 91wsrep_node_address=10.0.0.17 92wsrep_cluster_name=pxc-cluster 93wsrep_node_name=pxc-cluster-node-2 94pxc_strict_mode=ENFORCING 95wsrep_sst_method=xtrabackup-v2 96wsrep_sst_auth="sstuser:s3cretPass" 97 98[root@pxc3 ~]#vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 99[root@pxc3 ~]#grep -Ev "^#|^$" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 100[mysqld] 101wsrep_provider=/usr/lib64/galera3/libgalera_smm.so 102wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27 103binlog_format=ROW 104default_storage_engine=InnoDB 105wsrep_slave_threads= 8 106wsrep_log_conflicts 107innodb_autoinc_lock_mode=2 108wsrep_node_address=10.0.0.27 109wsrep_cluster_name=pxc-cluster 110wsrep_node_name=pxc-cluster-node-3 111pxc_strict_mode=ENFORCING 112wsrep_sst_method=xtrabackup-v2 113wsrep_sst_auth="sstuser:s3cretPass" 114 115#启动PXC集群中第一个节点 116[root@pxc1 ~]#systemctl start mysql@bootstrap.service 117[root@pxc1 ~]#ss -ntl 118State Recv-Q Send-Q Local Address:Port Peer Address:Port 119LISTEN 0 128 *:22 *:* 120LISTEN 0 128 *:4567 *:* 121LISTEN 0 100 127.0.0.1:25 *:* 122LISTEN 0 128 [::]:22 [::]:* 123LISTEN 0 100 [::1]:25 [::]:* 124LISTEN 0 80 [::]:3306 [::]:* 125 126[root@pxc1 ~]#grep "temporary password" /var/log/mysqld.log 1272020-10-17T06:59:53.765387Z 1 [Note] A temporary password is generated for root@localhost: Vkyf+nVci9wW 128[root@pxc1 ~]#mysql -uroot -pVkyf+nVci9wW 129mysql: [Warning] Using a password on the command line interface can be insecure. 130Welcome to the MySQL monitor. Commands end with ; or \g. 131Your MySQL connection id is 11 132Server version: 5.7.31-34-57-log 133 134Copyright (c) 2009-2020 Percona LLC and/or its affiliates 135Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. 136 137Oracle is a registered trademark of Oracle Corporation and/or its 138affiliates. Other names may be trademarks of their respective 139owners. 140 141Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 142 143mysql> alter user root@'localhost' identified by 'magedu'; 144Query OK, 0 rows affected (0.00 sec) 145 146mysql> grant reload,lock tables,process,replication client on *.* to sstuser@'localhost' identified by 's3cretPass'; 147Query OK, 0 rows affected, 1 warning (0.01 sec) 148 149mysql> show variables like 'wsrep%'\G 150*************************** 1. row *************************** 151Variable_name: wsrep_OSU_method 152 Value: TOI 153*************************** 2. row *************************** 154Variable_name: wsrep_RSU_commit_timeout 155 Value: 5000 156*************************** 3. row *************************** 157Variable_name: wsrep_auto_increment_control 158 Value: ON 159*************************** 4. row *************************** 160Variable_name: wsrep_causal_reads 161 Value: OFF 162*************************** 5. row *************************** 163Variable_name: wsrep_certification_rules 164 Value: strict 165*************************** 6. row *************************** 166Variable_name: wsrep_certify_nonPK 167 Value: ON 168*************************** 7. row *************************** 169Variable_name: wsrep_cluster_address 170 Value: gcomm://10.0.0.7,10.0.0.17,10.0.0.27 171*************************** 8. row *************************** 172Variable_name: wsrep_cluster_name 173 Value: pxc-cluster 174*************************** 9. row *************************** 175Variable_name: wsrep_convert_LOCK_to_trx 176 Value: OFF 177*************************** 10. row *************************** 178Variable_name: wsrep_data_home_dir 179 Value: /var/lib/mysql/ 180*************************** 11. row *************************** 181Variable_name: wsrep_dbug_option 182 Value: 183*************************** 12. row *************************** 184Variable_name: wsrep_debug 185 Value: OFF 186*************************** 13. row *************************** 187Variable_name: wsrep_desync 188 Value: OFF 189*************************** 14. row *************************** 190Variable_name: wsrep_dirty_reads 191 Value: OFF 192*************************** 15. row *************************** 193Variable_name: wsrep_drupal_282555_workaround 194 Value: OFF 195*************************** 16. row *************************** 196Variable_name: wsrep_forced_binlog_format 197 Value: NONE 198*************************** 17. row *************************** 199Variable_name: wsrep_load_data_splitting 200 Value: ON 201*************************** 18. row *************************** 202Variable_name: wsrep_log_conflicts 203 Value: ON 204*************************** 19. row *************************** 205Variable_name: wsrep_max_ws_rows 206 Value: 0 207*************************** 20. row *************************** 208Variable_name: wsrep_max_ws_size 209 Value: 2147483647 210*************************** 21. row *************************** 211Variable_name: wsrep_node_address 212 Value: 10.0.0.7 213*************************** 22. row *************************** 214Variable_name: wsrep_node_incoming_address 215 Value: AUTO 216*************************** 23. row *************************** 217Variable_name: wsrep_node_name 218 Value: pxc-cluster-node-1 219*************************** 24. row *************************** 220Variable_name: wsrep_notify_cmd 221 Value: 222*************************** 25. row *************************** 223Variable_name: wsrep_on 224 Value: ON 225*************************** 26. row *************************** 226Variable_name: wsrep_preordered 227 Value: OFF 228*************************** 27. row *************************** 229Variable_name: wsrep_provider 230 Value: /usr/lib64/galera3/libgalera_smm.so 231*************************** 28. row *************************** 232Variable_name: wsrep_provider_options 233 Value: base_dir = /var/lib/mysql/; base_host = 10.0.0.7; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 4; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs 234*************************** 29. row *************************** 235Variable_name: wsrep_recover 236 Value: OFF 237*************************** 30. row *************************** 238Variable_name: wsrep_reject_queries 239 Value: NONE 240*************************** 31. row *************************** 241Variable_name: wsrep_replicate_myisam 242 Value: OFF 243*************************** 32. row *************************** 244Variable_name: wsrep_restart_slave 245 Value: OFF 246*************************** 33. row *************************** 247Variable_name: wsrep_retry_autocommit 248 Value: 1 249*************************** 34. row *************************** 250Variable_name: wsrep_slave_FK_checks 251 Value: ON 252*************************** 35. row *************************** 253Variable_name: wsrep_slave_UK_checks 254 Value: OFF 255*************************** 36. row *************************** 256Variable_name: wsrep_slave_threads 257 Value: 8 258*************************** 37. row *************************** 259Variable_name: wsrep_sst_auth 260 Value: ******** 261*************************** 38. row *************************** 262Variable_name: wsrep_sst_donor 263 Value: 264*************************** 39. row *************************** 265Variable_name: wsrep_sst_donor_rejects_queries 266 Value: OFF 267*************************** 40. row *************************** 268Variable_name: wsrep_sst_method 269 Value: xtrabackup-v2 270*************************** 41. row *************************** 271Variable_name: wsrep_sst_receive_address 272 Value: AUTO 273*************************** 42. row *************************** 274Variable_name: wsrep_start_position 275 Value: 00000000-0000-0000-0000-000000000000:-1 276*************************** 43. row *************************** 277Variable_name: wsrep_sync_wait 278 Value: 0 27943 rows in set (0.00 sec) 280 281mysql> show status like 'wsrep%'; 282+----------------------------------+--------------------------------------+ 283| Variable_name | Value | 284+----------------------------------+--------------------------------------+ 285| wsrep_local_state_uuid | 6085b686-1046-11eb-ac84-631f2cc73305 | 286| wsrep_protocol_version | 9 | 287| wsrep_last_applied | 3 | 288| wsrep_last_committed | 3 | 289| wsrep_replicated | 3 | 290| wsrep_replicated_bytes | 816 | 291| wsrep_repl_keys | 3 | 292| wsrep_repl_keys_bytes | 96 | 293| wsrep_repl_data_bytes | 521 | 294| wsrep_repl_other_bytes | 0 | 295| wsrep_received | 2 | 296| wsrep_received_bytes | 150 | 297| wsrep_local_commits | 0 | 298| wsrep_local_cert_failures | 0 | 299| wsrep_local_replays | 0 | 300| wsrep_local_send_queue | 0 | 301| wsrep_local_send_queue_max | 1 | 302| wsrep_local_send_queue_min | 0 | 303| wsrep_local_send_queue_avg | 0.000000 | 304| wsrep_local_recv_queue | 0 | 305| wsrep_local_recv_queue_max | 2 | 306| wsrep_local_recv_queue_min | 0 | 307| wsrep_local_recv_queue_avg | 0.500000 | 308| wsrep_local_cached_downto | 1 | 309| wsrep_flow_control_paused_ns | 0 | 310| wsrep_flow_control_paused | 0.000000 | 311| wsrep_flow_control_sent | 0 | 312| wsrep_flow_control_recv | 0 | 313| wsrep_flow_control_interval | [ 100, 100 ] | 314| wsrep_flow_control_interval_low | 100 | 315| wsrep_flow_control_interval_high | 100 | 316| wsrep_flow_control_status | OFF | 317| wsrep_cert_deps_distance | 1.000000 | 318| wsrep_apply_oooe | 0.000000 | 319| wsrep_apply_oool | 0.000000 | 320| wsrep_apply_window | 1.000000 | 321| wsrep_commit_oooe | 0.000000 | 322| wsrep_commit_oool | 0.000000 | 323| wsrep_commit_window | 1.000000 | 324| wsrep_local_state | 4 | 325| wsrep_local_state_comment | Synced | 326| wsrep_cert_index_size | 1 | 327| wsrep_cert_bucket_count | 22 | 328| wsrep_gcache_pool_size | 2256 | 329| wsrep_causal_reads | 0 | 330| wsrep_cert_interval | 0.000000 | 331| wsrep_open_transactions | 0 | 332| wsrep_open_connections | 0 | 333| wsrep_ist_receive_status | | 334| wsrep_ist_receive_seqno_start | 0 | 335| wsrep_ist_receive_seqno_current | 0 | 336| wsrep_ist_receive_seqno_end | 0 | 337| wsrep_incoming_addresses | 10.0.0.7:3306 | 338| wsrep_cluster_weight | 1 | 339| wsrep_desync_count | 0 | 340| wsrep_evs_delayed | | 341| wsrep_evs_evict_list | | 342| wsrep_evs_repl_latency | 0/0/0/0/0 | 343| wsrep_evs_state | OPERATIONAL | 344| wsrep_gcomm_uuid | 60853201-1046-11eb-b428-d757c0543d63 | 345| wsrep_cluster_conf_id | 1 | 346| wsrep_cluster_size | 1 | 347| wsrep_cluster_state_uuid | 6085b686-1046-11eb-ac84-631f2cc73305 | 348| wsrep_cluster_status | Primary | 349| wsrep_connected | ON | 350| wsrep_local_bf_aborts | 0 | 351| wsrep_local_index | 0 | 352| wsrep_provider_name | Galera | 353| wsrep_provider_vendor | Codership Oy <info@codership.com> | 354| wsrep_provider_version | 3.45(ra60e019) | 355| wsrep_ready | ON | 356+----------------------------------+--------------------------------------+ 35771 rows in set (0.00 sec) 358 359#启动PXC集群中其它所有节点 360[root@pxc2 ~]#systemctl start mysql 361[root@pxc2 ~]#ss -ntl 362State Recv-Q Send-Q Local Address:Port Peer Address:Port 363LISTEN 0 128 *:22 *:* 364LISTEN 0 128 *:4567 *:* 365LISTEN 0 100 127.0.0.1:25 *:* 366LISTEN 0 80 [::]:3306 [::]:* 367LISTEN 0 128 [::]:22 [::]:* 368LISTEN 0 100 [::1]:25 [::]:* 369 370[root@pxc3 ~]#systemctl start mysql 371[root@pxc3 ~]#ss -ntl 372State Recv-Q Send-Q Local Address:Port Peer Address:Port 373LISTEN 0 128 *:22 *:* 374LISTEN 0 128 *:4567 *:* 375LISTEN 0 100 127.0.0.1:25 *:* 376LISTEN 0 80 [::]:3306 [::]:* 377LISTEN 0 128 [::]:22 [::]:* 378LISTEN 0 100 [::1]:25 [::]:* 379 380#查看集群状态，验证集群是否成功 381[root@pxc1 ~]#mysql -uroot -pmagedu 382mysql> show variables like 'wsrep_node_name'; 383+-----------------+--------------------+ 384| Variable_name | Value | 385+-----------------+--------------------+ 386| wsrep_node_name | pxc-cluster-node-1 | 387+-----------------+--------------------+ 3881 row in set (0.00 sec) 389 390mysql> show variables like 'wsrep_node_address'; 391+--------------------+----------+ 392| Variable_name | Value | 393+--------------------+----------+ 394| wsrep_node_address | 10.0.0.7 | 395+--------------------+----------+ 3961 row in set (0.00 sec) 397 398mysql> show variables like 'wsrep_on'; 399+---------------+-------+ 400| Variable_name | Value | 401+---------------+-------+ 402| wsrep_on | ON | 403+---------------+-------+ 4041 row in set (0.01 sec) 405 406mysql> show status like 'wsrep_cluster_size'; 407+--------------------+-------+ 408| Variable_name | Value | 409+--------------------+-------+ 410| wsrep_cluster_size | 3 | 411+--------------------+-------+ 4121 row in set (0.00 sec) 413 414[root@pxc2 ~]#mysql -uroot -pmagedu 415mysql: [Warning] Using a password on the command line interface can be insecure. 416Welcome to the MySQL monitor. Commands end with ; or \g. 417Your MySQL connection id is 14 418Server version: 5.7.31-34-57-log Percona XtraDB Cluster (GPL), Release rel34, Revision 7359e4f, WSREP version 31.45, wsrep_31.45 419 420Copyright (c) 2009-2020 Percona LLC and/or its affiliates 421Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. 422 423Oracle is a registered trademark of Oracle Corporation and/or its 424affiliates. Other names may be trademarks of their respective 425owners. 426 427Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 428 429mysql> show databases; 430+--------------------+ 431| Database | 432+--------------------+ 433| information_schema | 434| mysql | 435| performance_schema | 436| sys | 437+--------------------+ 4384 rows in set (0.00 sec) 439 440[root@pxc3 ~]#mysql -uroot -pmagedu 441mysql: [Warning] Using a password on the command line interface can be insecure. 442Welcome to the MySQL monitor. Commands end with ; or \g. 443Your MySQL connection id is 11 444Server version: 5.7.31-34-57-log Percona XtraDB Cluster (GPL), Release rel34, Revision 7359e4f, WSREP version 31.45, wsrep_31.45 445 446Copyright (c) 2009-2020 Percona LLC and/or its affiliates 447Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. 448 449Oracle is a registered trademark of Oracle Corporation and/or its 450affiliates. Other names may be trademarks of their respective 451owners. 452 453Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 454 455mysql> create database db1; 456Query OK, 1 row affected (0.00 sec) 457 458[root@pxc1 ~]#mysql -uroot -pmagedu 459mysql: [Warning] Using a password on the command line interface can be insecure. 460Welcome to the MySQL monitor. Commands end with ; or \g. 461Your MySQL connection id is 16 462Server version: 5.7.31-34-57-log Percona XtraDB Cluster (GPL), Release rel34, Revision 7359e4f, WSREP version 31.45, wsrep_31.45 463 464Copyright (c) 2009-2020 Percona LLC and/or its affiliates 465Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. 466 467Oracle is a registered trademark of Oracle Corporation and/or its 468affiliates. Other names may be trademarks of their respective 469owners. 470 471Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 472 473mysql> show databases; 474+--------------------+ 475| Database | 476+--------------------+ 477| information_schema | 478| db1 | 479| mysql | 480| performance_schema | 481| sys | 482+--------------------+ 4835 rows in set (0.00 sec) 484 485##在PXC集群中再加一台新的主机PXC4：10.0.0.37 486[root@pxc4 ~]#vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 487[root@pxc4 ~]#grep -Ev "^#|^$" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 488[mysqld] 489wsrep_provider=/usr/lib64/galera3/libgalera_smm.so 490wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27,10.0.0.37 491binlog_format=ROW 492default_storage_engine=InnoDB 493wsrep_slave_threads= 8 494wsrep_log_conflicts 495innodb_autoinc_lock_mode=2 496wsrep_node_address=10.0.0.37 497wsrep_cluster_name=pxc-cluster 498wsrep_node_name=pxc-cluster-node-4 499pxc_strict_mode=ENFORCING 500wsrep_sst_method=xtrabackup-v2 501wsrep_sst_auth="sstuser:s3cretPass" 502 503[root@pxc4 ~]#systemctl start mysql 504[root@pxc4 ~]#mysql -uroot -pmagedu 505mysql: [Warning] Using a password on the command line interface can be insecure. 506Welcome to the MySQL monitor. Commands end with ; or \g. 507Your MySQL connection id is 11 508Server version: 5.7.31-34-57-log Percona XtraDB Cluster (GPL), Release rel34, Revision 7359e4f, WSREP version 31.45, wsrep_31.45 509 510Copyright (c) 2009-2020 Percona LLC and/or its affiliates 511Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. 512 513Oracle is a registered trademark of Oracle Corporation and/or its 514affiliates. Other names may be trademarks of their respective 515owners. 516 517Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 518 519mysql> show status like 'wsrep_cluster_size'; 520+--------------------+-------+ 521| Variable_name | Value | 522+--------------------+-------+ 523| wsrep_cluster_size | 4 | 524+--------------------+-------+ 5251 row in set (0.00 sec) 526 527mysql> show databases; 528+--------------------+ 529| Database | 530+--------------------+ 531| information_schema | 532| db1 | 533| mysql | 534| performance_schema | 535| sys | 536+--------------------+ 5375 rows in set (0.00 sec) 538 539#修改其他节点的配置文件 540[root@pxc1 ~]#vim /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 541[root@pxc1 ~]#grep -E "^wsrep_cluster_address=gcomm:" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 542wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27,10.0.0.37 543[root@pxc2 ~]#grep -E "^wsrep_cluster_address=gcomm:" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 544wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27,10.0.0.37 545[root@pxc3 ~]#grep -E "^wsrep_cluster_address=gcomm:" /etc/percona-xtradb-cluster.conf.d/wsrep.cnf 546wsrep_cluster_address=gcomm://10.0.0.7,10.0.0.17,10.0.0.27,10.0.0.37