Shulou(Shulou.com)06/03 Report--

Xiaobian to share with you what types of mysql sub-library, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

1. Horizontal sub-library is similar to horizontal sub-table, which is closely related. Horizontal sub-warehouse is to divide the tables of a single warehouse into horizontal sub-tables, and then put the sub-tables into different sub-warehouses for independent deployment.

Because the main carrier of the contents in the library is the table, the horizontal sub-library and the horizontal sub-table are basically accompanied.

For example, in the user table, we can use the registration time range to divide the table, deploying the user table usrtb2020 registered in 2020 in usrdata20 and the user table usrtb2021 registered in 2021 in usrdata21.

Similarly, vertical sub-library and vertical sub-table are also very similar, but vertical sub-table splitting fields, vertical sub-library splitting tables.

Vertical library is a strategy that classifies tables under a library in different dimensions and then assigns them to different sub-libraries.

For example, we could put all user-related tables in usrdata, order-related tables in odrdata, and so on.

The classification dimension of vertical sub-warehouse can be determined according to business module (user/order...), Technical modules (log library/photo library..), space, time, etc.

The above is "what are the types of mysql sub-library" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to 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.