I would use replication with multiple masters. You could setup 2, 3
or however many servers, that all replicate to 1 server (which you
may be doing). I would just set the auto_increment increment larger
than you need to allow for growth, like 10. If you are using
auto_increment.
You then
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-10 = to server1
user_id
