How to alter tables safely to set row_format as Compressed or Dynamic in Mariadb Galera Cluster?
1
vote
1
answer
1205
views
We have some tables with row_format=Compact. The biggest table is around 30Gb, so how safely i can alter tables and set the row format as Compressed for the big table and Dynamic for other three tables which are under 10GB each? It is a cluster with three nodes with mariadb v10.4.12 and Galera 4. Running DDL / alter tables and change the row format can leads to cluster blocking and maybe it took long time!
Can anyone help and guide me how i can do it? Do you think using RSU mode helps here and is it safe since we talking about changing the row format?
Asked by Milad Hamid Elhaei Sahar
(113 rep)
Apr 24, 2020, 11:53 AM
Last activity: Apr 30, 2020, 01:01 AM
Last activity: Apr 30, 2020, 01:01 AM