Hello Nathan,
Nathan Huang wrote:
Hello
I want to fetch and calculate the data from remote database(for example
Japan) and insert them into my local database(for example usa), does
mysql have such function to do it, or do I have to write a script using
perl or other language to help achieving it?
thank you in advance
nathan
While transfer time between the two servers can become an issue, MySQL
does allow you to treat a database in a different MySQL instance (it
could be in the next slot in your rack or anywhere else your network can
reach). The secret is the FEDERATED database engine.
http://dev.mysql.com/doc/refman/5.1/en/federated-storage-engine.html
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
