Hello, thanks for your response.
Find below the requested info:
–Percona Server version:
5.7.25-28-57-log
–SO version
CentOS Linux release 7.6.1810 (Core)
–Percona my.cnf file (this is the same on the 3 nodes)
[mysql]
CLIENT
port = 3306
socket = /mydata/mysql.sock
[mysqld]
GENERAL
user = mysql
default-storage-engine = InnoDB
socket = /mydata/mysql.sock
pid-file = /mydata/mysql.pid
#old_passwords = 1
MyISAM
key-buffer-size = 32M
myisam-recover-options = FORCE,BACKUP
#Enable Federated Storage Engine
federated
SAFETY
max-allowed-packet = 128M
max-connect-errors = 1000000
DATA STORAGE
datadir = /mydata
BINARY LOGGING
log-bin = /mydata/mysql-bin
expire-logs-days = 1
sync-binlog = 1
server_id = 1
CACHES AND LIMITS
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
INNODB
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 512M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 1456M
LOGGING
log-error = /var/log/mysqld.log
log-queries-not-using-indexes = 1
#slow-query-log = 1
#slow-query-log-file = /var/lib/mysql/mysql-slow.log
## XTRADB PARAMETERS ##
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_name=pxc-cluster-dev
wsrep_cluster_address=gcomm://10.10.10.2,10.10.10.3,10.10.10.4
wsrep_node_name=pxc1
wsrep_node_address=10.10.10.2
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=“xxxxxxxxxxx”
wsrep_replicate_myisam = 1
wsrep_slave_threads=2
#gcache.size
wsrep_provider_options=“gcache.size=768M;gcache.recover = yes”
binlog_format=ROW
innodb_autoinc_lock_mode=2
[mysqldump]
max-allowed-packet = 128M