News for hackers. Stuff that matters.
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.)
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?
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.