Mysql merge TABLE sharding: www.2cto.com create table 'test _ 1' (id INT (11) not null default '0', email varchar (50) not null, primary key ('id') ENGINE = MyISAM default charset = UTF8; create table 'test _ 2' (id INT (11) not null default '0 ', email varchar (50) not null, primary key ('id') ENGINE = MyISAM default charset = UTF8; create table 'test _ 3' (id INT (11) not null default '0', email varchar (50) NOT NUL L, primary key ('id') ENGINE = MyISAM default charset = UTF8; a summary TABLE: www.2cto.com create table 'test' ('id' INT (11) not null default '0' email varchar (50) not null key 'I _ id' ('id'),) ENGINE = MRG_MyISAM UNION = (test_1, test_2, test_3) default charset = UTF8; if you select * on the test table, the data in the three sub-tables will be taken out. When inserting data, perform the modulo operation based on the hash code of the object. If the remainder is 3, insert the table test_3.