Database horizontal split and vertical split differences (MySQL for example)

Database horizontal split and vertical split differences (MySQL for example)

Database horizontal split and vertical split difference (MySQL for example) case: The simple shopping system is set up in the following table: 1. Product table (data volume 10w, Stable) 2. Order form (200w of data and growth trend) 3. User table (data volume 100w, And there is a growth trend) with MySQL as an example of the next level split and vertical split, MySQL can tolerate the order of magnitude in millions of static data can go to millions Vertical split: Solve the problem: the IO contention between tables and tables does not solve the problem: the pressure scheme of increasing the amount of data in a single table: placing the Product table and the user table on a server The order table is placed on a single server Horizontal split: Solve the problem: the increase in the amount of data in a single table does not solve the problem: the IO contention between table and table: User table through gender split into male user table and female user form order form completed and completed by split into completed orders and unfinished orders product table Unfinished order placed on a server completed order Form box male user table put a server on a female user table put on a server (woman love shopping haha)

Database horizontal split and vertical split differences (MySQL for example)