What is a Federated table in MySQL?

A Federated table in MySQL is same as any other table. The only difference is that a Federated table points to a table in another MySQl Database instance. The other MySQL database instance may live on a different host as well.

Federated table is similar to DB Link in Oracle database.

Leave a Reply

Your email address will not be published. Required fields are marked *