High-performance, highly-available solutions for data volumes, high concurrency databases

1. Split Table: Large table (vertical split, horizontal split, sub-table, partition partition, Shard sharding), can be implemented at the application layer, can also be implemented at the database level, improve system performance.

2. Sub-Library: Put the table to a different database, which is the basis of the distributed database, improve system performance.

3. Distributed: Different databases are placed on different servers, improving system performance.

4. Cluster: The use of database replication technology to build a cluster, read-write separation, backup, etc., improve system performance, availability.

5. Caching: Caching of commonly used data. Improve system performance.

6. Backup: Master-slave library, snapshot, hot standby, offsite backup, etc., improve system availability.

High-performance, highly-available solutions for data volumes, high concurrency databases