gistfile1.txt

$ sudo pico /etc/mysql/mysql.cnf
    [mysqld]
    federated
    
$ service mysql restart

mysql federated

DROP TABLE IF EXISTS `master`.t1;
CREATE TABLE `master`.t1 (
    id     INT(20) NOT NULL AUTO_INCREMENT,
    name   VARCHAR(32) NOT NULL,
	PRIMARY KEY(id)
);

DROP TABLE IF EXISTS `slave`.t1;
CREATE TABLE `slave`.t1 (
    id     INT(20) NOT NULL AUTO_INCREMENT,
    name   VARCHAR(32) NOT NULL,
	PRIMARY KEY(id)
) ENGINE=FEDERATED CONNECTION='mysql://homestead:[email protected]:3306/master/t1';

INSERT INTO `master`.t1 (name) VALUE ('alex');
INSERT INTO `master`.t1 (name) VALUE ('de');
INSERT INTO `master`.t1 (name) VALUE ('oliveira');

SELECT * FROM `master`.t1;
SELECT * FROM `slave`.t1;