This article is half-done without your Comment! *** Please share your thoughts via Comment ***
As this is the last part of the FEDERATED Table Article so in this post, I am giving some important Notes and Tips of FEDERATED Engine.
- The remote server must be a MySQL Server.
- You can replicate the FEDERATED table to other slaves, but ensure that slave server is able to use defined connection string.
- You can create nested FEDERATED tables.
- The FEDERATED table does not support indexes because of its virtual nature.
- The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE.
- The FEDERATED also supports INSERT ON DUPLICATE KEY UPDATE statements.
- The FEDERATED table does not support Transaction.
- The FEDERATED table can also perform bulk-insertion.
- Any DROP TABLE statement issued against a FEDERATED table drops only the local table, not the remote table.
- The FEDERATED tables do not work with the query cache.