MySQL: The Important Notes and Tips of FEDERATED Storage Engine (Part 4/4)

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.