News for hackers. Stuff that matters.

A comment on MemSQL is now free to use for databases with up to 128GB of RAM usage. Parent comment

Re:MemSQL is now free to use for databases with up to 128GB ... by starik36 on Tuesday November 06, 2018 @12:47PM (#18393204)
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?
[ Parent | on HN ]
Re:MemSQL is now free to use for databases with up to 128GB ... by rickn on Tuesday November 06, 2018 @01:28PM (#18393585)
I 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-architectu...

[ Parent | on HN ]
Re:MemSQL is now free to use for databases with up to 128GB ... by openbasic on Thursday November 08, 2018 @10:34AM (#18406951)
How does MemSQL reach consensus between nodes?
[ Parent | on HN ]
Re:MemSQL is now free to use for databases with up to 128GB ... by hanson5b on Tuesday November 06, 2018 @01:27PM (#18393569)
A 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.)
[ Parent | on HN ]
Re:MemSQL is now free to use for databases with up to 128GB ... by zedpm on Tuesday November 06, 2018 @02:39PM (#18394242)
Do 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?
[ Parent | on HN ]
Re:MemSQL is now free to use for databases with up to 128GB ... by brd529 on Tuesday November 06, 2018 @06:00PM (#18395655)
In general more memory should go to the leaves. All data is stored there and MemSQL will push processing to the leaves whenever possible.
[ Parent | on HN ]