current position:Home>What are the types of MySQL sub database and sub table?

What are the types of MySQL sub database and sub table?

2022-02-04 16:25:45 Alibaba cloud Q & A

MySQL What are the types of sub database and sub table ?




Take the answer 1:

Horizontal sub database : Based on fields , According to a certain strategy (hash、range etc. ), Split data from one library into multiple libraries .

Horizontal sub table : Based on fields , According to a certain strategy (hash、range etc. ), Split the data in one table into multiple tables .

Vertical sub database : Based on the table , According to the business ownership , Split different tables into different libraries .

Vertical sub table : Based on fields , According to the activity of the field , Split the fields in the table into different tables ( Main table and extended table ) in .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041625441766.html

Random recommended