OPTIMIZE tables in galera cluster
Updated at by ospiComment out wsrep_provider in /etc/my.cnf, add skip-networking to prevent clients from connecting and restart MariaDB.
# wsrep_provider=/usr/lib64/galera/libgalera_smm.so
skip-networking
Default behaviour for mysqlcheck and OPTIMIZE TABLE is to write the statement to binlog. PIT recovery might be more fun with those included, but I rather not have them. So either
# mysqlcheck -o --skip-write-binlog woofwoof muchdata
or
MariaDB [woofwoof]> OPTIMIZE NO_WRITE_TO_BINLOG TABLE muchdata;
Revert changes to /etc/my.cnf and restart MariaDB.