InnoDB Redo Log Files – How to Change Size Online in Galera Cluster

galerainnodbmariadbtransaction-log

We have a 3 node Galera cluster. I need to change the mysqld innodb_log_file_size parameter (see Changing the Number or Size of InnoDB Redo Log Files).

I do this by stopping all 3 nodes and disabling Puppet. Can I do this change online with Galera? How?

> select VERSION();
+----------------------+
| VERSION()            |
+----------------------+
| 5.5.41-MariaDB-wsrep |
+----------------------+
1 row in set (0.00 sec)

Best Answer

The InnoDB redo log files are independent of galera. Because of this, you should be able to change the redo log configuration by doing a rolling restart and following the procedure in the link you referenced.

Related Question