At 14:12 21/03/2008, you wrote:
Message-ID: <a63e33880803200905g10335059tf12cd1ae40cc0f2f@xxxxxxxxxxxxxx> Date: Thu, 20 Mar 2008 11:05:22 -0500 From: "Dee Ayy" <dee.ayy@xxxxxxxxx> To: php-db@xxxxxxxxxxxxx MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: Re: Query Across DBMS Boundaries (Linked Database Servers?) Wow! I just found the Federated Storage Engine. http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html It's not in our SHOW ENGINES though. I still welcome comments.
You need MySQL MaxDB version (at least on windows), which is precompiled using --with-federated-storage-engine That article doesn't state it, and I think I had to stumble across this in the Federated engine discussion forum @ MySQL
It's a very useful storage type, particularly if you have a lot of records with recent records (eg last 1 month) online, and a bunch compressed or as ARCHIVE tables on a near-line storage server for your older data (eg older than 1 month)
HTH Cheers - Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
