Are there any reasons to duplicate table in the same database ?

Posted by bob on Server Fault See other posts from Server Fault or by bob
Published on 2010-06-10T07:39:54Z Indexed on 2010/06/10 7:43 UTC
Read the original article Hit count: 289

Filed under:
|
|

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) ?

© Server Fault or respective owner

Related posts about mysql

Related posts about Performance