4 ms·
This might be a stupid question, but what is the advantage of this solution over an in-memory sqlite database?
by moolcool 8y ago
This might be a stupid question, but what is the advantage of this solution over an in-memory sqlite database?
- haneefmubarak 8y agoFrom what they claim, MemSQL supposedly scales well across a cluster of servers (and of course the usual, fail over, features, and other fun stuff).
- ericd 8y agoI’m no db expert, but doesn’t SQLite have very non-granular locking that makes it hard to scale?
- manigandham 8y agoDistributed. Scalable. OLTP + OLAP queries. High availability. Very fast performance for reads and writes. They are entirely different systems. Sqlite is meant for self-contained applications that need some relational data persistence with a single file for storage, not for accessing as a central database with many clients storing TBs and scaling across nodes.
- marmaduke 8y agoSQLite is a replacement for fopen (Quote from their docs)
- riku_iki 8y ago> Distributed is MemSQL shared nothing or shared everything, or can be mix of both?
- manigandham 8y agoShared nothing. It has leaf nodes that store data and do local processing, and aggregator nodes that run queries spread to the leaf nodes and return the results.
- cyphar 8y agoThere are actually some patches in the works (currently used by LXD from memory) that allow sqlite to be distributed. I'm quite hazy on the details, but apparently this is part of what enables LXD's clustering.