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

This article introduces the relevant knowledge of "what is mysql vertical segmentation". In the operation of actual cases, many people will encounter such a dilemma. Next, 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. Vertical segmentation is common in vertical database and vertical table.

2. Vertical sub-database is to store different tables with low correlation in different databases according to business coupling.

The practice is similar to splitting a large system into multiple small systems, which are divided independently according to the business classification.

3. The vertical table is based on the "columns" in the database.

If a table has more fields, you can create a new extension table and split the fields that are less commonly used or with larger field lengths into the extension table.

The following tables are available:

User Information Table (User)

Transactions (Pay)

Commodity (Commodity)

For the above cases, vertical sharding is to split each table into different databases according to its different business, such as User table, Pay table and Commodity table.

This is the end of the content of "what is the vertical segmentation of mysql". 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!

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.