This article is half-done without your Comment! *** Please share your thoughts via Comment ***
This is the last part of the series on the FEDERATED Table of MySQL, so in this post, I am sharing 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.
For more info, You can visit this MySQL official document.