Running MySQL queries on multiple servers

[mandy]

You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?

You can use MySQL's database replication to help you run queries on data spread over different servers.

With database replication, one server is set up as a master and a second as a slave. Data from the master is then replicated on the slave, and any subsequent changes are automatically passed through. You must remember, however, that this is replication rather than a direct connection, meaning that the slave database is not updated immediately when records in the master database change.

full tutorial: http://www.linux.com/article.pl?sid=06/02/22/2050253

You could also use PostgreSQL instead of MySQL and save youself a lot of trouble  :twistedevil: