High-performance, highly available solution for large 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.
Http://en.wikipedia.org/wiki/Partition_ (Database)
Http://en.wikipedia.org/wiki/Shard_ (Database_architecture)
This article is from the "GONE with the Wind" blog, please be sure to keep this source http://h2appy.blog.51cto.com/609721/1615002
High-performance, highly-available solution for large data volumes, high concurrency databases