question about data partitioning in application level.

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

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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/mysql?unsub=lists@pantek.com