Federated My SQL


 CREATE TABLE users (
users_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, name VARCHAR(255) NULL
) ENGINE = FEDERATED
CONNECTION='mysql://root:password@10.10.0.1:3306/db_name/table_name';

select * from users;
insert into users (users_id, `name`) values (10,'Jefri');


show plugins;

select version();

SHOW CREATE TABLE table_name