A brief introduction to mysql Vertical Segmentation

This article mainly explains the "brief introduction of mysql vertical segmentation", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql vertical segmentation of the simple introduction" bar!

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.

Thank you for your reading, the above is the content of the "brief introduction of mysql vertical segmentation", after the study of this article, I believe you have a deeper understanding of the simple introduction of mysql vertical segmentation, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!