What are "federated tables" in Mysql?

    1 answer 1

    Very roughly speaking - the link to the table in mysq_BD1 to the remote mysql_BD2. Creation example:

    CREATE TABLE `your_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `column1` enum('insert','update','delete') NOT NULL, `column2` int(10) unsigned NOT NULL, `column3` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://your_user:your_password@your_host:3306/your_db/your_table';

    Detailed info: http://dev.mysql.com/doc/refman/5.7/en/federated-storage-engine.html