Re: Query to another server

[Chris Nolan]

Sure! Just remember that your slave will have to be able to keep up with 
all the UPDATE, INSERT and DELETE statements issued on the master servers.

Regards,

Chris

[EMAIL PROTECTED] wrote:

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]