Research on MySQL Database slicing technology

This period of time to understand the MySQL Shard technology and master-slave copy just tidy up the mind map to draw a record, hoping to give the people who need some help

P.S.: Personal finishing, there may be errors, but also hope that the ~

The problem to be solved

1. The operation of massive data exceeds the maximum limit of single table and library.

2, access pressure exceeds the database system limits, performance degradation

3, database replication, disaster tolerance and other issues

Solution Solutions

I. Using data sub-table to improve the performance limit of database

1. Optional sharding strategy

2, sharding realization of the level

Can be:
(1) Data access Layer (DAO)

(2) ORM Framework Layer

(3) JDBC API layer

(4) Agent layer between application server and database

(5) Database layer Partitioning

(6) Other optional public cloud RDS Services

Second, the HA mechanism guarantee of master-slave node switching

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Research on MySQL Database slicing technology