Re: Query Across DBMS Boundaries (Linked Database Servers?)

From: Date: Fri, 21 Mar 2008 21:30:51 +0000
Subject: Re: Query Across DBMS Boundaries (Linked Database Servers?)
Groups: php.db 
Request: Send a blank email to php-db+get-44757@lists.php.net to get a copy of this message
At 14:12 21/03/2008, you wrote:
Message-ID: <a63e33880803200905g10335059tf12cd1ae40cc0f2f@mail.gmail.com> Date: Thu, 20 Mar 2008 11:05:22 -0500 From: "Dee Ayy" <dee.ayy@gmail.com> To: php-db@lists.php.net 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

« previous php.db (#44757) next »