Are there any reasons to duplicate table in the same database ?
- by bob
Let says we have several MySQL server, one master and some slaves.
A member table which contains more than 5.000.000 peoples.
Are there any reasons (performance, atomicity, etc..) to use duplicate tables like member_1, member_2, member_3 and then switch randomly when doing operation on it ? (especialy SELECT query) ?