mysql数据库分库分表哪个工具好，我整理出来了五个，求点评

Question

Hi，各位好

目前公司用户数据库的数据量已经达到2亿条了，想优化一下，缓存不用说了已经实现了。现在想实现

分库分表，网上找了一些开源的分库分表的中间件吧。看了看各有各的好，希望有用过的给小弟推荐一个。

1、金山的Kingshard
https://github.com/flike/kingshard/blob/master/README_ZH.md

2、百度的heisenberg
https://github.com/brucexx/heisenberg

3、58同城的Oceanus
https://github.com/58code/Oceanus

4、淘宝toddle（不维护）
https://github.com/alibaba/tb_tddl

5、当当网的sharding-jdbc
https://github.com/dangdangdotcom/sharding-jdbc

    
   

Answer 1

1. MyCat

2. amoeba

3. Altas Note: It seems that it has not been updated for a long time.

Answer 2

Future, NewSQL: TiDB

Answer 3

Sharding-jdbc is the client's table and database component; MyCat and Altas are middleware agents; they are basically divided into these two categories.
I can’t recommend it, I haven’t used it in a production environment.