php pulling mysql from different domains

[jackdack]

Very general questions, i'm just thinking about site structures and strategies.

Is it easy to pull data from different mysql databases residing on different websites/domain on to a single domain?
Or are you limited to only work with whatever is on the current domain/website where the mysql database is installed?
Are there any disadvantages of pulling data from different mysql databases on different domains to a single domain? Obviously theres a network link dependancy. I don't know how significant a security concern this would present.
Do people do this often?

thank you

[Habtom]

I am not sure if there is any security risk, but I am sure it is possible to do so. You can access Mysql databases residing in different servers. Only you have got to do is to swich your connections when you need on or the other. I think performance issue will also come into picture, so you go to be sure whatever you are doing is worth of playing with data here and there.

Habtom

[jackdack]

great thank habtom. I thought it must be possible. If anyone has any experiences using mysql across servers it would be great to hear from you. thanks