What are the advantages and disadvantages of mysql horizontal segmentation

This article introduces the relevant knowledge of "what are the advantages and disadvantages of mysql level segmentation". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The main results are as follows: 1. The advantage of horizontal segmentation is that there is no performance bottleneck of large amount of data in a single database, high concurrency and small application modification.

There is no performance bottleneck of large amount of data and high concurrency in a single database, which improves the stability and load capacity of the system.

The transformation of the application side is small, and there is no need to split the business module.

2. Due to the shortcomings of horizontal segmentation, it is difficult to ensure the consistency of cross-fragment transactions, poor query performance and difficult data maintenance.

It is difficult to guarantee the consistency of cross-fragment transactions.

The performance of cross-library join association query is poor.

Data is difficult to extend and maintain many times.

Case

For databases, most tables can be divided horizontally according to the user ID. The relevant data of different users is segmented and stored in different databases. For example, all user ID is stored in two different databases using a 2 fetch model. Every table associated with the user ID can be shredded in this way. In this way, basically the relevant data of each user is in the same database, even if it needs to be associated, it can be easily associated.

This is the end of the content of "what are the advantages and disadvantages of mysql level segmentation". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!