Master-Slave read-write separation, sub-database sub-table
1. Vertical Slicing
2. Horizontal segmentation
Solutions are: Mysql-agent, TDDL, Amoeba, Cobar, Cobar client, Mycat, SHARDING-JDBC
Database partition partition
Resources:
1. Analysis of the realization principle of horizontal segmentation of database----sub-library, sub-table, master-slave, cluster, load balancer
2 . Basic idea and segmentation strategy of database sharding
3. Database sub-list (sharding) series (iii) Considerations regarding the use of frameworks or autonomous development and sharding implementation levels
4, when SHARDING-JDBC
5, Mycat distributed MySQL middleware (MySQL middleware research)
6, Tddl, Amoeba, Cobar, mycat architecture comparison http://www.360doc.com/content/15/0825/16/1542811_494660281.shtml
7, Http://www.infoq.com/cn/news/2016/01/sharding-jdbc-dangdang
8, http://mycat.org.cn/
Database Sub-Library sub-table