sqlmongodbtidb

Scalable RDBMS alternative, NoSQL, NewSQL


I am looking for scalable alternative to traditional DBMS like PostgreSQL or MySQL. In traditional databases I don't have the following features:

MongoDB looks like good candidate if I can sacrifice transactions.

Also I've looked at several newSQL databases. NewSQL seems suitable for my purposes: VoltDB, TiDB, cockroachDB. But I'm worried about whethever they are production-ready.

May be there are extensions allowing to run postgreSQL or MySQL in clustered mode out of box.


Solution

  • TiDB

    It supports the MySQL Protocol so that you can transfer your MySQL scripts running on TiDB without change.

    It was used by many big name company such as Mobike, uber,pinterest etc. In Mobike, the big data team uses TiDB as a slave for synchronizing data with online DB. After that, OLTP query, consisting of analysis and gathering request, was executed in such circumstance. Last but not the least, the cloud computing platform belongs to Tencent, the technology giant, recommend customers use HTAP based on TiDB for OLTP and OLAP.