Hi all,
I thought I’d give an experimental tarball a shot, although I’ve done so on 3 CentOS 8 VMs (so far the only requirements difference was having to install compat-openssl10). So I extracted the tarball, created an /etc/my.cnf with a set of options to allow bootstrapping the first node. The issues I’ve encountered so far and could use some feedback on:
-
On MySQL startup: “[Server] unknown variable 'wsrep_sst_auth=”, so I comment this option in my.cnf
However, I’m unable to find references to this option begin deprecated and some other taking its place. -
Joining a node to expand the cluster.
On starting up the second node I get an error message
2019-11-11T18:47:25.956452Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************
2019-11-11T18:47:25.957360Z 0 [ERROR] [MY-000000] [WSREP-SST] The xtrabackup version is .
2019-11-11T18:47:25.957427Z 0 [ERROR] [MY-000000] [WSREP-SST] xtrabackup-2.4.13 or higher is needed to perform an SST
2019-11-11T18:47:25.957459Z 0 [ERROR] [MY-000000] [WSREP-SST] /usr/local/percona-xtradb-cluster-8/bin/pxc_extra/pxb-2.4/bin/xtrabackup
2019-11-11T18:47:25.957486Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2019-11-11T18:47:25.957893Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘192.168.1.65’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/local/percona-xtradb-cluster-8/’ --plugindir ‘/usr/local/percona-xtradb-cluster-8/lib/mysql/plugin/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘11016’ --mysqld-version ‘8.0.15-5-27dev.4.2’ --binlog ‘/var/lib/mysql/percona_binlog’ : 2 (No such file or directory)
2019-11-11T18:47:25.958427Z 2 [ERROR] [MY-000000] [WSREP] Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.
2019-11-11T18:47:25.958654Z 2 [ERROR] [MY-010119] [Server] Aborting
after which MySQL crashes.
Admittedly, I’m starting MySQL on the command line, thus probably omitting environment variables MySQL may depend on (as well as xtrabackup for that matter), because I’ve only ever set up a cluster from a binary and sure could use directions on how to overcome these few issues.
Milos.