NODE 1:

#
# The Percona XtraDB Cluster 5.7 configuration file.
#
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#   Please make any edits and changes to the appropriate sectional files
#   included below.
#
!includedir /etc/my.cnf.d/
!includedir /etc/percona-xtradb-cluster.conf.d/


[mysqld]

datadir=/var/lib/mysql
user=mysql

# Path to Galera library
 wsrep_provider=/usr/lib64/libgalera_smm.so

# Cluster connection URL contains the IPs of node#1, node#2 and node#3
 wsrep_cluster_address=gcomm://XX.XXX.X.A,XX.XXX.X.B,XX.XXX.X.C

# In order for Galera to work correctly binlog format should be ROW
 binlog_format=ROW

# MyISAM storage engine has only experimental support
 default_storage_engine=InnoDB

# This InnoDB autoincrement locking mode is a requirement for Galera
 innodb_autoinc_lock_mode=2

# Node 1 address
 wsrep_node_address=XX.XXX.X.A

#If wsrep_node_name is not specified,  then system hostname will be used
wsrep_node_name=percona1

#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING

# Slave thread to use
 wsrep_slave_threads= 8

# SST method
 wsrep_sst_method=xtrabackup-v2

# Cluster name
 wsrep_cluster_name=YYYYYY

# Authentication for SST method
 wsrep_sst_auth="XXXXX:XXXXXX"

 


NODE 2:

#
# The Percona XtraDB Cluster 5.7 configuration file.
#
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#   Please make any edits and changes to the appropriate sectional files
#   included below.
#
!includedir /etc/my.cnf.d/
!includedir /etc/percona-xtradb-cluster.conf.d/

[mysqld]

datadir=/var/lib/mysql
user=mysql

# Path to Galera library
 wsrep_provider=/usr/lib64/libgalera_smm.so

# Cluster connection URL contains IPs of node#1, node#2 and node#3
 wsrep_cluster_address=gcomm://XX.XXX.X.A,XX.XXX.X.B,XX.XXX.X.C

# In order for Galera to work correctly binlog format should be ROW
 binlog_format=ROW

# MyISAM storage engine has only experimental support
 default_storage_engine=InnoDB

# This InnoDB autoincrement locking mode is a requirement for Galera
 innodb_autoinc_lock_mode=2

# Node 2 address
 wsrep_node_address=XX.XXX.X.B

#If wsrep_node_name is not specified,  then system hostname will be used
wsrep_node_name=percona2

#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING

# Slave thread to use
  wsrep_slave_threads= 8

# Cluster name
 wsrep_cluster_name=YYYYYY

# SST method
 wsrep_sst_method=xtrabackup-v2

#Authentication for SST method
 wsrep_sst_auth="XXXXXX:XXXXXXX"
 
 
 NODE 3:
 
 #
# The Percona XtraDB Cluster 5.7 configuration file.
#
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#   Please make any edits and changes to the appropriate sectional files
#   included below.
#
!includedir /etc/my.cnf.d/
!includedir /etc/percona-xtradb-cluster.conf.d/

[mysqld]

datadir=/var/lib/mysql
user=mysql

# Path to Galera library
 wsrep_provider=/usr/lib64/libgalera_smm.so

# Cluster connection URL contains the IPs of node#1, node#2 and node#3
 wsrep_cluster_address=gcomm://XX.XXX.X.A,XX.XXX.X.B,XX.XXX.X.C

# In order for Galera to work correctly binlog format should be ROW
 binlog_format=ROW

# MyISAM storage engine has only experimental support
 default_storage_engine=InnoDB

# This InnoDB autoincrement locking mode is a requirement for Galera
 innodb_autoinc_lock_mode=2

# Node 3 address
 wsrep_node_address=XX.XXX.X.C

#If wsrep_node_name is not specified,  then system hostname will be used
 wsrep_node_name=percona3

#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
 pxc_strict_mode=ENFORCING

# Slave thread to use
 wsrep_slave_threads= 8

# SST method
 wsrep_sst_method=xtrabackup-v2

# Cluster name
 wsrep_cluster_name=YYYYYY

# Authentication for SST method
 wsrep_sst_auth="XXXXXX:XXXXX"