Advanced MySQL 8

The FEDERATED storage engine

The FEDERATED storage engine is designed to create a single reference from multiple MySQL database systems without using replication or cluster technology. Querying a federated table automatically pulls data from remote tables. No data is stored on local tables:

CREATE TABLE federated_table ( no INT(3) NOT NULL AUTO_INCREMENT, name VARCHAR(42) NOT NULL DEFAULT '', Age INT(3) NOT NULL DEFAULT '0', PRIMARY KEY (no), INDEX name (name) ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://connctinguser@remotehost:3306/mydb/test_table';