Not the answer you need?
Register and ask your own question!

Percona XtraDB dont sync

aminamin EntrantCurrent User Role Beginner
I want to resync 2 MySQL DB but its not work

Node1

[[email protected] log]# cat /etc/my.cnf
[mysqld]

datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
bind-address=0.0.0.0

[galera]

wsrep_on=ON
binlog_format=ROW
wsrep_cluster_name='PXC'
wsrep_cluster_address="gcomm://****,****"
wsrep_node_address='****'
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_sst_method=rsync
wsrep_node_name='node1'
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
default_storage_engine=InnoDB

[mysql_safe]

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[[email protected] log]#


Node 2

[[email protected] ~]# cat /etc/my.cnf
[mysqld]

datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
#user=mysql
#Disabling symbolic-links is recommended to prevent assorted security risks
#symbolic-links=0
bind-address=0.0.0.0

[galera]

wsrep_on=ON
binlog_format=ROW
wsrep_cluster_name='PXC'
wsrep_cluster_address="gcomm://****,****"
wsrep_node_address='****'
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_sst_method=rsync
wsrep_node_name='node2'
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
default_storage_engine=InnoDB

[mysql_safe]

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[[email protected] ~]#

in start and stop state I don't have any error


BUT


[[email protected] ~]# clustercheck

HTTP/1.1 503 Service Unavailable
Content-Type: text/plain
Connection: close
Content-Length: 57

Percona XtraDB Cluster Node is


where is problem?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.