Shulou(Shulou.com)06/01 Report--

The difference between sharding and partitioning:

a. Sharding: solve the problem of insufficient physical disk space (if indexed, you can also optimize the query to achieve the function of partitioning)

b. Zoning:

Optimize the query to prevent the query from being slow due to too much data in a table

c. Copy:

Prevent the loss caused by the database crash and ensure the highly available fragmentation of the database:

A. Mongodb:sharding

B. Mysql:

Mysql-cluster partition implementation:

A. mongodb: there is no concept of sub-tables, sharding can be used instead of sub-tables (because sharding has its own indexing function)

B. Mysql:

Partition replication implementation:

A. Mongodb:master master slave slave

B. Mysql:

Master master slave slave

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.