The FEDERATED storage engine, new in MySQL 5.0, allows the server to access tables in other (remote) servers. See http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
MySQL 4.1 already added other new storage engines, such as ARCHIVE, CSV and NDB (Cluster).