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
