What are the effects of horizontal splits?

The effects of horizontal splitting are: 1. The splitting rules are well abstracted, and the join operation can basically be done in the database; 2. There is no single database big data, high concurrency performance bottleneck; 3. The splitting rules are difficult to abstract ; 4. The consistency of sharded transactions is difficult to solve.

The advantages are:

• The splitting rules are well abstracted, and the join operation can basically be done in the database.

• There is no single database big data or high concurrency performance bottleneck.

• There are less modifications on the application side.

• Improves the stability and load capacity of the system.

Disadvantages are:

• Splitting rules are difficult to abstract.

• The consistency of sharded transactions is difficult to solve.

• Multiple data expansions are difficult and require great maintenance.

• Cross-database join performance is poor.

Recommended tutorial: "mysql tutorial"

The above is the detailed content of What are the effects of horizontal splits?. For more information, please follow other related articles on the PHP Chinese website!