Federated tables are tables that point to the tables located on other databases on some other server.

Federated tables in MySQL allow you to access data from a remote MySQL database as if it were a local table. This feature enables you to integrate data from multiple databases across different servers seamlessly. By using federated tables, you can perform queries that involve data from both local and remote databases without having to manually synchronize the data. It’s like having a virtual table that fetches data from a remote source on-demand. This can be particularly useful in scenarios where you need to combine data from different sources or databases without physically consolidating them into a single location.