MemSQL is now free to use for databases with up to 128GB of RAM usage

Re:MemSQL is now free to use for databases with up to 128GB ... by no1youknowz on Tuesday November 06, 2018 @11:43AM (#18392589)

I've been using MemSQL in development since March 2017. I've seen it evolve into one of the fastest databases for columnar storage and analytical workloads. Having in-memory rowstore as well removed the need to have Aerospike in my infrastructure and simplified the whole stack.

This announcement, that it's now free to 128GB pretty much saved me from having to do a kickstarter to raise funds for my little SaaS project.

If anyone from MemSQL is reading, really thanks for doing this. I think it's a very shrewd move. Should definitely see an upswing of potential customers adding it to their stack and when they grow, become enterprise customers.

[ Parent | on HN ]

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 ]