Announcement

Announcement Module
Collapse
No announcement yet.

PXC and changing InnoDB file and row format

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • PXC and changing InnoDB file and row format

    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:
    http://www.percona.com/doc/percona-x...rep_OSU_method

    Comment

    Working...
    X