Adding and using table partitions in XtraDB Cluster (5.6 and 8)

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I have just some basic questions regarding table partitioning and XtraDB Cluster:

We want to do a table partitioning on some tables in our 3 node XtraDB Clusters (some are still on 5.6 most are already 8.0)

We are useing partition statements like this one:

alter table `s`.`loading` 
PARTITION BY LIST(archived) (
    PARTITION archive VALUES IN (1),
    PARTITION actual VALUES IN (0)
);
    • Can/should this be run on an active 3 node XtraDB Cluster?
    • Are there any drawbacks in using partitioned tables with XtraDB Cluster?

Thanks in advance

1 Like