Hi,
On Tuesday, December 21, 2004, at 07:59 AM, Luciano Barcaro wrote:
Sergei, thanks for the reply, but I coudnīt see any 'useful' info about it .
I would like to know the differences (characteristics) between federated and other engines
The federated engine allows you to have remote tables (ie. on a separate physical server) and then query them. When you create a federated table you declare a URL that tells it where the remote table is. Then the server will login to the remote server and retrieve data from the remote server as needed. So you could do a join between a table on your local system and one on a complete different server. Many other DBMS' call this process "Linked Tables".
The federated engine can technically be a mapping over any type of remote table, but there are some limitations at this point (with transactions, etc...). Hope that gives you a basic overview.
Thanks
Sergei Golubchik wrote:
Hi!
It was added ony a few days ago - documentation is catching up still. For now - take a look at the mysql-test/t/federated.test file. Regards, Sergei
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.2 - Release Date: 20/12/2004
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Regards,
Harrison
-- Harrison C. Fisk, Trainer and Consultant MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
