What are the advantages and disadvantages of mysql vertical segmentation

This article introduces the relevant knowledge of "what are the advantages and disadvantages of mysql vertical 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!

1. The advantages of vertical segmentation, coupling, hierarchical management, maintenance, monitoring and expansion at the business system level, O, the number of database connections and stand-alone hardware resources have been improved.

Solve the coupling of business system level, the business is clear.

Hierarchical management, maintenance, monitoring and expansion of data from different businesses.

In the high concurrency scenario, the bottlenecks of IO, database connections and stand-alone hardware resources have been improved to some extent.

2. The disadvantage of vertical segmentation increases the complexity of development, complex distributed transaction processing and large amount of data in a single table.

Some forms cannot be join and can only be solved through interface aggregation.

Complex distributed transaction processing.

There is still the problem of excessive amount of data in a single table (horizontal segmentation is required)

For the data segmentation and transaction problems that may be encountered by vertical segmentation, it is difficult to find a better solution at the database level. In practical application cases, the vertical cutting of the database mostly corresponds to the module of the application system, and the data source of the same module is stored in the same database, which can solve the problem of data association within the module. Between modules, the application provides the required data through the service interface. Although this does increase the overall number of operations of the database, it is beneficial in terms of overall system expansion and architectural modularization. The single response time for some operations may increase slightly, but the overall performance of the system is likely to improve. The problem of expanding bottlenecks can only be solved through the data split horizon architecture that will be described in the next section.

This is the end of the content of "what are the advantages and disadvantages of mysql vertical segmentation". Thank you for 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!