Re: Distributed tables or something like that

[Mike Hillyer]

My only concern would be overwhelming whatever service routes the INSERT queries. You would likely want to have each inserting client choose a server directly.

I have seen one tool that is similar to what you are talking about, at http://www.inspireonsoftware.com/Products-MyPQuery.htm

Have you considered MERGE tables?

http://dev.mysql.com/doc/mysql/en/MERGE.html

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine