Hi, I’m very new to MemSQL and primarily have a RDBMS background. I’m running MemSQL with high_availability set to false, and would like to see performance based on different partitioning and replication schemes.
However, in trying to dynamically replicate and partition, I cannot find any documentation - as most replication documentations are about replicating to entire clusters (and not nodes), and most partitioning documents indicate to setting partitions during schema definition.
Could someone please advise on how it would be possible to do something like this, which can be done in PostgreSQL:
Replication of a table
ALTER TABLE table DISTRIBUTE BY REPLICATION
Partitioning of a table
ALTER TABLE table DISTRIBUTE BY HASH(attribute)