In this post, we will talk about a brand new MySQL server replacement.
What is TiDB ?
TiDB (The pronunciation is: /'taɪdiːbi:/ tai-D-B, etymology: titanium) is a distributed SQL database. Inspired by the design of Google F1 and Google Spanner, TiDB supports the best features of both traditional RDBMS and NoSQL. -- source
Why you may use it?
- You need a lightweight solution instead of the ancient Mysql.
- You need to use a distributed scalable SQL based database.
- You live schema changes without any downtime.
- You need to scale from one machine to multiple machines easily with no hassle.
How to install it?
The simplest way to run it, through
# run an instance from here # You can change the public port to whatever you want. $ docker run --name tidb-server -d -p 4000:4000 pingcap/tidb:latest # connect to it using any mysql-client $ mysql -h 127.0.0.1 -P 4000 -u root
I've tested it, and I think, you should give it a try, it is a promising project that will solve scalability and performance problems.
You can read more about TiDB from here.