5 ms·
It says that he 128GB version comes with High Availability features. Does that mean if I have 2 nodes, each one is limited to 64GB? Or each one can have 128?
by starik36 8y ago
It says that he 128GB version comes with High Availability features. Does that mean if I have 2 nodes, each one is limited to 64GB? Or each one can have 128?
- hanson5b 8y agoA typical setup for HA would be 2 aggregator nodes and 2 leaf nodes. You can allocate the memory however you want. For example, you could give 32GB to all 4. Or give 16GB to each aggregator and 48GB to each leaf. (I'm a MemSQL Product Manager by the way.)
- zedpm 8y agoDo you have recommendations on provisioning memory in aggregators vs leaves? That is, would one of those configurations make for sense than the other for typical workloads?
- brd529 8y agoIn general more memory should go to the leaves. All data is stored there and MemSQL will push processing to the leaves whenever possible.
- rickn 8y agoI am the Director of Product Management for MemSQL. The 128 GB limit applies to the whole cluster. So if you have two nodes in the cluster they would each have to be 64GB or less. If you have four nodes they would all have to be 32 GB or less. To have a highly available system we recommend 4 nodes (a master aggregator, a child aggregator and two leaf nodes). You can read more about the cluster architecture here: https://docs.memsql.com/concepts/v6.7/distributed-architecture/ https://docs.memsql.com/concepts/v6.7/distributed-architectu...
- openbasic 8y agoHow does MemSQL reach consensus between nodes?