That looks like a good solution... Do you know if i can replicate multiple databases from diferent servers to one server? many masters and one slave, the slave might have replicas of each master database (cause i need to query on many diferent mysql servers)
thanks... FBR Chris Nolan <[EMAIL PROTECTED]> 17/02/2004 12:52 a.m. To Terence <[EMAIL PROTECTED]> cc [EMAIL PROTECTED] Subject Re: Query to another server You might be able to cheat and replicate the required database to the local machine. Regards, Chris Terence wrote: >you'll need to create temporary tables in one of the servers based on the >results of the other and then join. > >----- Original Message ----- >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, February 17, 2004 2:54 PM >Subject: Query to another server > > >Is it possible to query one server from another even if those servers are >in diferent machines at diferent locations? > >for example: > >select * from localtable left join remoteserver.remotedatabase.remotetable > >where localtable.key = remoteserver.remotedatabase.remotetable.key > > >FBR > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
