Secondary nodes in new cluster stuck in 'Disconnected' status

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Created a new cluster. Debian 10. Node 1 seems good. Node 2 and node 3 are started but remain disconnected. It does not seem like they are reading from /etc/mysql/mysql.conf.d/my.cnf as I put a bogus entry in the .cnf file and it did not affect startup or throw an error. Possibly that is the concern. I am also not getting any log info beyond the initial startup for either node2 or node3. Would upload .cnf files but I am not allowed as a new user?

1 Like
2

That’s quite an unusual path. I do not believe that is read by default. Try throwing your bogus entry into /etc/mysql/my.cnf and see what happens.

1 Like
3

Matthew, Agreed, but I use the same path for the Master(Node 1) and it seemed ok, but I did bootstrap it, so maybe that is the difference? it looks like /etc/mysql/mysql.cnf has includes for /etc/mysql/mysql.conf.d, which is where I put my mysqld.cnf.

root@iaddb02:~# cat /etc/mysql/mysql.cnf
#
# The Percona Server 8.0 configuration file.
#
# For explanations see
# MySQL :: MySQL 8.0 Reference Manual :: 5.1.8 Server System Variables
#
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with ‘.cnf’, otherwise they’ll be ignored.
#

!includedir /etc/mysql/mysql.conf.d/
!includedir /etc/mysql/conf.d/

Listing of both directories:
root@iaddb02:~# ls -ltr /etc/mysql/mysql.conf.d/
total 8
-rw-r–r-- 1 root root 1287 Jun 16 18:24 mysqld.cnf.BAK
-rw-r–r-- 1 root root 1459 Jun 16 21:03 mysqld.cnf
root@iaddb02:~# ls -ltr /etc/mysql/conf.d
total 8
-rw-r–r-- 1 root root 55 Aug 3 2016 mysqldump.cnf
-rw-r–r-- 1 root root 9 Jun 7 15:03 mysql.cnf
root@iaddb02:~# cat /etc/mysql/conf.d/mysql.cnf

1 Like
4

Maybe try and rename /etc/mysql/mysql.conf.d/mysqld.cnf to mysql.cnf?

1 Like
5

I updated /etc/mysql/my.cnf to link to /etc/mysql/mysql.conf.d/mysqld.cnf, which is where the Cluster install referred to and I had updated the wsrep params and it is working now. Makes sense it was something simple. Thanks!

| wsrep_local_state_comment | Synced

1 Like
6

Excellent. I thought it was quite a strange path.

1 Like