Re: Re: Querying tables on multiple hosts in a single query1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux