PXC 8.x replication issues

Thanks for the help, I will think that is not so.
I don’t understand why when I comment lines in my.cnf (wsrep_) on PXC1 and start the node without cluster mode, replication works fine with mysql1

And as soon as in cluster mode and it doesn’t matter in bootstrap or already in normal mode, replication starts(Slave_IO_Running: Yes/Slave_SQL_Running: Yes) up but lags behind and the node crashes from the cluster…

The problem, as for me, is hidden in the cluster mode, but there are not so many settings:

pxc_encrypt_cluster_traffic = OFF
wsrep_cluster_address = gcomm://10.0.0.1,10.0.0.2,10.0.0.3
wsrep_cluster_name = mysql-cluster
wsrep_node_address = 10.0.0.1
wsrep_node_name = mysql-cluster-n1
wsrep_provider = /usr/lib64/libgalera_smm.so
wsrep_provider_options = ‘evs.inactive_timeout=PT1M;evs.install_timeout=PT1M;evs.keepalive_period=PT3S;evs.send_window=512;evs.suspect_timeout=PT30S;evs.user_send_window=256;evs.version=1;gcache.size=1G;gcs.fc_factor=0.8’
wsrep_slave_threads = 16
wsrep_sst_method = xtrabackup-v2

1 Like