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 .
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- C language, using the while statement to write the programming of finding the N-power of a number
- How to display student information by calling methods is the last step
- eleven trillion and one hundred and eleven billion one hundred and eleven million one hundred and eleven thousand one hundred and eleven
- Why can't this code completely pass the environment (PTA)
- Server error transmitting data from background
- The company recently reported an error in the localized configuration of dongfangtong tongweb. Com tongweb. jasper. JasperException
- Made an arc circuit, why does it run like this
- How to answer this question
- It's so difficult. I don't know how to write code.
- Baidu user name registration equivalence classification, both in Chinese and English, up to 7 Chinese characters or 14 English characters
guess what you like
Vs2019 cannot use scanf, and the online method has not been solved. How should it be solved?
Usage of stack, heap and method area in memory
How does Android dynamically change the item style of GridView?
eleven trillion and one hundred and eleven billion one hundred and eleven million one hundred and eleven thousand one hundred and eleven
Has the mobile phone number been registered / bound
C how to solve this problem
Publish GeoServer map vector slice through Java
How can I make this up
Unknown column 'age' in 'field list'
Baidu map uses browser positioning, and the positioning of computer terminal and mobile terminal is not accurate?
- What do you think of Peng YuYan's question
- How to use the if statement to output the following results
- one hundred and eleven trillion and one hundred and eleven billion one hundred and eleven million one hundred and eleven thousand one hundred and eleven
- Then I ask for the sum difference quotient product of 3 and 2. What should I do
- There is an unhandled exception at 0x008672b2 (ucrtbased. DLL) (in 20211009. Exe): 0xc0000005: an access conflict occurred while writing to location 0xcccc.
- Mysql database needs to be migrated, and all primary key types UUID should be changed to bigint. How to deal with the foreign keys of the sub table?
- In the quick sort code, remove if (left & gt; right) return 0; After, why does the code not work properly?
- Find the sum of N rational numbers (the result is expressed by shaping / shaping)
- How to change the color of the label text of the sector chart in E-chart
- Why choose C for this question and what knowledge points
- C calls WebKit kernel. How to display Chinese about input?
- one trillion and one hundred and eleven billion one hundred and eleven million one hundred and eleven thousand one hundred and eleven
- How does the VMware Workstation open interface look like Figure 2
- How to write this one, everyone (JS algorithm problem)
- MySQL finds the duplicate data of a single field or multiple fields and clears the duplicate data
- Summary and sharing of Android construction speed optimization, two sides of meituan Android R & D post
- Vue project Internationalization -- El table view is not updated
- Mybatis caching mechanism (first level cache, second level cache, interview experience of Java spring recruitment in 2021
- An exception eolesyserror in module word clock occurred during the installation of world clock exe at 0005248D. No class is registered What should I do?
- Basic usage of mybatis, Linux interrupt handler architecture
- Wrote a parquet file with Bloom filter. Now you can use bloom filter when you want to read files with spark. Does spark have the corresponding implementation?
- There are four round towers with centers of (2,2), (- 2.2), (- 2, - 2), (2, - 2) and circle radius of 1, as shown in Figure 4.17. The height of the four towers is 10m, and there are no buildings outside the towers. Now enter the coordinates of any point t
- The source of DTS is self built MySQL or RDS. What is the migration scheme for MySQL?
- The source of DTS is RDS. What is the migration scheme of MariaDB?
- The source of DTS is RDS. What is the migration scheme of PPAs?
- What are the tasks in MapReduce?
- How to synchronize zoocfg configuration files in zookeeper?
- What is the migration scheme for polardb mysql, the source of DTS?
- What is the migration scheme for polardb o engine as the source of DTS?
- What is the migration scheme with polardb-x 2.0 as the source of DTS?
- What is dataX?
- What is the workflow of MapReduce?
- The source of DTS is polardb. What is the migration scheme of PostgreSQL?
- What system management functions does the metadata mechanism in the data warehouse mainly support?
- Where is the docker configuration file? How to modify the configuration?
- What is the execution process of MapReduce application?
- What is the difference between left semi join and left join in data warehouse?
- What is the design architecture of dataX?
- The source of DTS is self built SQL server or RDS. What is the migration scheme of SQL Server?
- The source of DTS is self built mongodb or cloud database. What is the migration scheme for the new console of mongodb?