MySQL memory principle and Data Structure

Author: skate
Time: 2012/08/28

MySQL memory principle and Data Structure

 

 

The general content is as follows:

1. How does MySQL complete a session?
2. MySQL Memory Structure
3. Mysql Data Structure
4. MySQL architecture ideas

 

 

........

Notes for designing a system

First consider:

The positioning of different service objects of the system, such as ensuring high stability, high energy, and user-friendly; there is always a trade-off.

 

When re-designing the system, you must consider the following:

1. Control the table data volume. The threshold value (such as 1000 W or W) is specified based on the hardware configuration. If the table data volume is expected

When the threshold value is exceeded, database/table sharding (at least table sharding) must be designed to ensure system performance and scalability.

The increase in data volume affects the system. In a single sentence, the online transaction system only processes the current fresh transaction data.

2. Control the resource consumption of a single transaction. When a large transaction is encountered, it can be disassembled and the mode of converting to zero is adopted to avoid the impact of special cases on the public.

3. System peak shifting design,

3.1 control the system by designing a funnel-like mode through the queue, so as to receive the maximum number of requests and process requests smoothly;

3.2 pass Database
Session controls the maximum concurrency of Data Processing

3.3 peak load shifting from small transactions to the global architecture Layer

4. Service downgrade protection. When the traffic volume surges, the secondary service is suspended to ensure the main business.

5. How to deal with data avalanche and data push, such as redis and MongoDB. Applications mainly read nosql databases and nosql databases go down.

Read the back-end RDBMS database. Consistency between nosql and RDBMS can be pushed through nosql flush and RDBMS.

6. Select master and slave data sources based on real-time data requirements

7. It is best not to specify a connection string for an application, but to connect to the database connection pool (all available connections in the pool)

8. Available database connection pool: You can store available database IP addresses in a specified file, and update this file regularly to ensure that the IP address is valid,

The program connects to the database first, obtains the available IP address of the database, and then connects to the database.

 

 

: Http://download.csdn.net/download/wyzxg/4531291

 

 

------ End ------