Database horizontal split and vertical split differences (__ Database

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 (data volume 200w, and growth trend) 3. User table (data volume 100w, and growth trend) take MySQL as an example Narrated under horizontal split and vertical split, MySQL can tolerate the order of magnitude in millions of static data can be up to tens of thousands of vertical split: Solve the problem: the IO competition between table and table does not solve the problem: the pressure scheme of increasing the amount of data in a single table: Put the product table and the user table on one server The order form is split horizontally on one server: Solve the problem: the pressure of data volume growth in a single table does not solve the problem: the IO contention between table and table: The user table is split into the male user table and the female user form by gender the order form is split into completed and unfinished orders through completion and completion of the product table is not finished Place an order 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)