Neil & Lester Thanks for the assistance - I think in the interim I will go with replication of the rules db to each physical host, but I am definitely going to follow up the product link below (I had a look this morning and it definitely seems ideal, but I need to work on my knowledge of matters .NET before I give it a try). Regards Rory McKinley Nebula Solutions +27 82 857 2391 rorym@nebula.co.za "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "Neil Smth" <php@comatose.freeserve.co.uk> To: <php-db@lists.php.net> Sent: Thursday, October 16, 2003 12:07 AM Subject: Re: Querying tables on multiple hosts in a single query1 > I found this http://www.inspireonsoftware.com/Products-MyPQuery.htm > > Does it look like a workable solution (paritioning by customer was one of > the applications mentioned). The 30 day trial looks worth a shot, they calm > licensing of $450 per host. > > Cheers - Neil Smith. > > >Message-ID: <011901c3932a$78da7c80$6701a8c0@nebcompaq> > >From: "Rory McKinley" <rorym@nebula.co.za> > >To: <php-db@lists.php.net> > >Date: Wed, 15 Oct 2003 16:41:41 +0200 > >MIME-Version: 1.0 > >Content-Type: multipart/alternative; > > boundary="----=_NextPart_000_0116_01C3933B.3635B9B0" > >Subject: Querying tables on multiple hosts in a single query > > At 17:54 15/10/2003 +0000, Rory wrote: > > >Originally, we kept all the DBs on a single database. However, of late, I > >decided to split the customer data as some customers have GB of data and > >take a lot longer than others. Therefore, I decided to split the customer > >databases to multiple boxes each running an installation of MySQL (4.0.15) > >with the rules databases on a seperate machine (also running MySQL > >4.0.15). The idea being that I would only need to maintain a single copy > >of each of the rules db which would make updating and maintenance easier. > >Unfortunately, this means that the above query then must look like this: > > > >INSERT INTO customer_host.customer_db.customer_table_2 > >SELECT a.field_one, b.field_two > >FROM customer_host.customer_db.customer_table_1 a, > >rules_host.rules_db.rules_table_1 b > >WHERE a.field_id = b.field_id > > > >Added to this I would have a seperate connection for each of the customer > >db and the rules db. > > > >Currently, I have no idea how to achieve the above query given the new > >situation - mysql_query only accepts a single connection link. > > > >Does anyone know if there is anyway that I can perform the above query? > > > >If I cannot - I have some alternatives but I hope someone will have a > >solution. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
