Explain federated tables?

Question Posted / amith

3 Answers
8292 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain federated tables?..

Answer / amith

Introduced in MySQL 5.0, federated tables allow access to
the tables located on other databases on other servers.

Is This Answer Correct ?

9 Yes

0 No

Explain federated tables?..

Answer / sivaraj

The FEDERATED storage engine is available beginning with
MySQL 5.0.3. It is a storage engine that accesses data in
tables of remote databases rather than in local tables.

Is This Answer Correct ?

6 Yes

0 No

Explain federated tables?..

Answer / aravind

The FEDERATED storage engine is available beginning with
MySQL 5.0.3. This storage engine enables data to be
accessed from a remote MySQL database on a local server
without using replication or cluster technology. When using
a FEDERATED table, queries on the local server are
automatically executed on the remote (federated) tables. No
data is stored on the local tables

Is This Answer Correct ?

5 Yes

0 No

Post New Answer