I have a question about data partitioning. I'm currently runnning a database server having too many writes, so trying to partition data in application level.
What I'm trying to do is partitioning data by user, for example, doing like the following. user_id 1-100000 => to server1 user_id 100001-200000 => to server2 When I have two tables listed below, user - user profile and so on. (few writes) user_write - user write history (many writes) and trying to partition user_write table because of too many writes. -------- user -------- -------- -------- user_write1 user_write2 -------- -------- What would you do to execute consistent insertion to both user and user_write1 in this situation ? (both insertion have to be successful and one insertion fail is not granted.) Does two phase commit in MySQL5 work in this kind of situation ? (transaction beyond multiple servers.) What would you do when using MySQL4 ? Thanks, Hiroyuki Yamada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]