PXC and changing InnoDB file and row format

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

I’m planning to change our default innodb_file_format from Antelope to Barracuda. Also we have few tables with text/medium/longtext fields so changing row_format from Compact to Dynamic (or Compressed) might increase performance. This “migration” is simple to do with standalone MySQL but is there something to be considered when doing same thing in XtraDB cluster (2 node + 1 garbd setup). ? e.g. Should we shutdown the second node during the migration ?

Thanks for any information,
Kari

2

For this type of altering table, so no data structure change, I think the RSU method is best. See the documentation for details:
[url]Index of wsrep system variables