How can we use federated engine in MySql

Federated engine is sync between database table of two servers. It's very useful for small load or some tables, not used for like cluster.

We can use federated engine in MySql, but it is default disable.

Step 1:
Execute "SHOW ENGINES" in MySql

Step 2:
Changes in my.ini mysql file

write federated below mysqld in my.ini file.

[mysqld]
federated

Step3:

Restart MySql service

Step 4:

Table should be like a below mentioned.

CREATE TABLE table_name(id int(10),name varchar(10))

ENGINE=FEDERATED

DEFAULT CHARSET=utf8

CONNECTION='mysql://server_db_user_name:server_db_password@server_ip:server_port/db_name/table_name';

server_db_user_name is mysql db user name

server_db_password is mysql db password

server_ip is DB Host server

server_port is default 3306

db_name is database name

table_name is where you are sync.

Cheers!!!