CODEWITHSUNDEEP
mysqlperconarocksdb
Lamp Consultants
Lamp Consultants

Reputation: 1

Percona MyRocks storage engine and replication

Can anyone advise me if we choose Percona MyRocks storage engine on the slave and replicating off Galera Cluster running Innodb engine. Would such replication work and if so what are the chances of it breaking on schema changes done on Galera cluster via Pt-schema-change.

Upvotes: 0

Views: 387

Answers (1)

George Lorch
George Lorch

Reputation: 201

InnoDB is the only supported storage engine for Galera/PXC replication.

Re-reading your question, it seems you want to use MyRocks on a slave in a 'traditional' async replication scenario, not as part of a cluster. This should work fine as long as that slave does not participate in the Galera cluster. MyRocks only really works well with ROW format, so no STMT/MIX. Any replicated DDL that might alter the engine will cause the slave table alteration to the target engine.

Upvotes: 1

Related Questions