Federated
The Federated storage engine is an engine that allows you to access remote tables as if they were local.
[edit] Resources
- For a beginner, reading Robin Schumacher's Accessing Distributed Data with the Federated Storage Engine article is rather significant. He lists a common use case, and allows you to get started and on your way to using FEDERATED tables in production.
- A really good resource is the MySQL Federated Tables: The Missing Manual, written by Giuseppe Maxia. It covers basic usage of the FEDERATED storage engine, testing features with a Perl script, making connections, checking availability, performance, and much more.