galera cluster how to run an ALTER without using RSU/TOI

0 votes

1 answer

646 views

                          I need to run an alter statement but would like to prevent locking/stall the cluster. The Galera docs  advised using: 

    SET wsrep_OSU_method='RSU';

Then Run the ALTER statement, once finich:

    SET wsrep_OSU_method='TOI';

Problem is that this needs to be run in every node, and I have only access to one node behind a load balancer, any alternatives or workarounds?

Asked by nbari (149 rep)

May 13, 2019, 01:18 PM
Last activity: Jul 21, 2020, 11:01 PM

galera cluster how to run an ALTER without using RSU/TOI

Related Questions