Hi @paul-griffith,
I’ve taken a closer look at the compatibility issue.
sqlt_data_xxxx table has a Primary Key, but there are 2 tables in the history system with no Primary Key :
sqlth_sce and sqlth_partitions.
So, the trick is not to cumbursome as the partition data table is compatible with mysql group replication requirement.
ALTER TABLE `histo`.`sqlth_partitions`
ADD COLUMN `pk_ai` BIGINT(20) NOT NULL AUTO_INCREMENT AFTER `flags`,
ADD PRIMARY KEY (`pk_ai`);
ALTER TABLE `histo`.`sqlth_sce`
ADD COLUMN `pk_ai` BIGINT(20) NOT NULL AUTO_INCREMENT AFTER `rate`,
ADD PRIMARY KEY (`pk_ai`);seem to solve the issue.
Audit tables are OK
For alarme tables
ALTER TABLE `histo`.`alarm_event_data`
ADD COLUMN `pk_ai` BIGINT(20) NOT NULL AUTO_INCREMENT AFTER `strvalue`,
ADD PRIMARY KEY (`pk_ai`);