Main differences and implementation of mongodb and mysql fragmentation and Partition

This article mainly introduces the main differences and implementation of mongodb and mysql fragmentation and partition, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the main differences and implementation of mongodb and mysql fragmentation and partition.

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 from the above about mongodb and mysql fragmentation and partition of the main differences and implementation, many readers must have some understanding, if you need to get more industry knowledge and information, you can continue to follow our industry information column.