[root@ip-172-31-92-30 centos]# cat /etc/my.cnf.d/server.cnf # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] datadir = /var/lib/mysql port = 3333 server_id = 3 gtid_domain_id = 202 bind-address = 0.0.0.0 default-storage-engine = innodb performance_schema = ON log_slave_updates = ON wait_timeout = 3000 interactive_timeout = 3000 binlog_format = ROW log-bin = mysql-bin-node-2 expire_logs_days = 3 log_error = /var/lib/mysql/error.log # # * Galera-related settings # [galera] # Mandatory settings wsrep_on = ON wsrep_gtid_mode = ON wsrep_gtid_domain_id = 2 wsrep_node_name = 'rnsmdc202' wsrep_node_address = '172.31.92.30' wsrep_cluster_name = 'rn_stage_cluster' wsrep_cluster_address = "gcomm://172.31.86.176,172.31.92.30" wsrep_provider = /usr/lib64/galera-4/libgalera_smm.so wsrep_sst_auth = sst_user:R00t@123 wsrep_sst_method = mariabackup #wsrep_on=ON #wsrep_provider= #wsrep_cluster_address= #binlog_format=row #default_storage_engine=InnoDB #innodb_autoinc_lock_mode=2 # # Allow server to accept connections on all interfaces. # #bind-address=0.0.0.0 # # Optional setting #wsrep_slave_threads=1 #innodb_flush_log_at_trx_commit=0 # this is only for embedded server [embedded] # This group is only read by MariaDB servers, not by MySQL. # If you use the same .cnf file for MySQL and MariaDB, # you can put MariaDB-only options here [mariadb]