Database/table sharding Solution

Ideas:

1. Read the database sharding and table sharding policies completely. Note the differences between database sharding and table sharding and write Reading Notes.

2. Test the source code of the ibatis + spring2.0-based sub-database. Pay attention to routing rules.

3. Source Code Implementation of the test table shard. Generally, dynamic table names after ibatis2.0 are used.

 

Take the management software of Changchun education public service platform as an example. Set a table in the master database to record the database of each school, such as db0, db1,... DBN.

When a user logs on, he can find the school ID of the person in the loginperson table. Based on the table above, he can find that the database of the school where the person is located is dB ?, Use the ibatis route to this database instance for data read and write. This facilitates the data migration problems caused by database expansion due to the large amount of data in the future.

 

Refer:

 

Memcache Memory Allocation Policy http://www.woxihuan.com/53055876/1329751905085867.shtml

 

Implementation Method of ibatis and hibernate database sharding (Dynamic table name ing) http://www.blogjava.net/weishuangshuang/archive/2011/03/26/347080.html

 

Storage of large data volumes, as well as common table sharding algorithms and problems brought about by these algorithms, as well as weak URL encryption rule Conjecture

Http://blog.csdn.net/hhq163/article/details/6219221

KEEPALIVED+NGINX

Http://wenku.baidu.com/view/698f3f000740be1e650e9a95.html

 

Memcached cluster single point of failure Solution

Http://apps.hi.baidu.com/share/detail/20218657

 

 

Magent + memcached cluster Test

 

Http://www.cnblogs.com/cnsanshao/archive/2011/10/21/2220154.html

Use spring + ibatis technology to configure multiple data sources in spring and implement dynamic switching.

Http://blog.csdn.net/f_d_q/article/details/6927546

 

 

Dynamically updatable multi-data source Persistence Layer Based on spring and ibatis

Http://www.cnblogs.com/shihao/archive/2012/02/14/2350814.html

 

Use spring to solve ibatis multi-data source troubles

Http://developer.51cto.com/art/200908/144000.htm

 

 

Implementation of ibatis and hibernate database sharding (Dynamic table name ing)

Http://blog.csdn.net/yanyuxieyang/article/details/5361140

Apply memcached to save session information

Http://blog.csdn.net/joliny/article/details/2108134

 

A scale-out mode that prevents data migration from database/table sharding

Http://rdc.taobao.com/team/jm/archives/590

 

 

 

Simple Solution for horizontal splitting of multiple databases in spring + ibatis
Http://www.iteye.com/topic/781317

 

 

Principle of database horizontal segmentation --- database sharding, table sharding, Master/Slave, cluster, Load balancer http://zhengdl126.iteye.com/blog/419850

 

 

**************************************** ********************************

Database/table sharding Solution

Http://fengbin2005.iteye.com/blog/1165038

 

Understanding Cache

Http://blog.csdn.net/ghj1976/article/details/1768676

 

What can hibernate memcached cache? Is it all objects?

Http://wenda.tianya.cn/wenda/thread? Tid = 020815ee6758b3dd

 

 

 

Memcached Distribution Test Report (selection of Hash Functions with consistent hashing)

Http://www.cnblogs.com/xpress/archive/2011/07/20/2111296.html

 

In-depth analysis of memcached server LRU

Http://www.iteye.com/topic/225692

 

SQL Server Partition Table Solution

Http://terryli.blog.51cto.com/704315/163315