Shulou(Shulou.com)05/31 Report--

This article mainly introduces the advantages and disadvantages of mysql level syncopation is what the relevant knowledge, the content is detailed and easy to understand, the operation is simple and fast, with a certain reference value, I believe that everyone after reading the advantages and disadvantages of this mysql level syncopation article will have a harvest, let's take a look at it.

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 article on "what are the advantages and disadvantages of mysql level segmentation?" Thank you for reading! I believe that everyone has a certain understanding of the knowledge of "what are the advantages and disadvantages of mysql level segmentation". If you want to learn more knowledge, you are welcome to follow the industry information channel.

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.