On 6 Jan 2004 at 14:10, Jay Blanchard wrote:
> Does anyone know how, if possible, to connect to two databases on two
> different network servers so that join queries can be performed (without
> using temporary tables)?
>
> I am using MySQL so mysql_pconnect() or mysql_connect() will insert a
> default server ('localhost:3306', per the docs) if I do not specify one.
> Specifying two servers (with the same granted user/pw combo) throws a
> syntax error. I have tested and searched, but turned up nothing so far.
> This is an experiment, but I can see where the value would be far
> ranging for those operating database server farms within their network
> (data modularization).
>
> If you have attempted this sort of (or would like to) thing I'd like to
> hear your thought, caveats, etc.
>
> TIA!
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Hi Jay
We are currently developing an application that will have a set of rules dbs sitting
on a
single server while client data is stored in dbs on different servers (for performance
reasons). We are also faced with the issue of only wanting to keep one copy of the
rules dbs (to ensure consistency and ease of updating) and using these rules in
queries
involving client data - i.e. queries using databases on separate hosts.
I raised this question (either in this list, or PHP-DB, or MySQL..my memory fails me)
and the responses that I got suggested that the only viable option is keeping local
copies of the rules db on each client and keeping these updated via replication.
Currently we are developing on a single server (client and rules) but we are building
the
code so we have yet to sort out the replication but that looms ahead of us.
If there is a way to do what you suggest, I would be glad to hear about it, and if I
could I
would happily assist to the best of my meagre abilities as it would definitely make my
life
simpler.
Regards
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
