By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

How to fetch data from multiple DB on multiple servers in MySQL

P: 1
I have three servers and each server has separate MySQL and DB.

For instance I have common DB i.e. store on all the three servers i.e web1, web2 and web3.

I m running a query in DB store on web1 and I need to verify some data from a table in DB - store on web2.

Can anyone reply how to perform this task in MySQL on cross servers.

How can we establish connection with different server and DB to use in query.

I have used data manipulation on multiple DBs but on single server, here the challenge is due to multiple DBs on multiple servers.

Looking for some early solution.

Thanks
Nov 22 '07 #1
Share this Question
Share on Google+
1 Reply


mwasif
Expert 100+
P: 801
AFAIK this is not possible with MySQL.
Nov 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.