How to use Federated Engine(Mysql) to Postgresql Table Migration

929 Views Asked by At

I tried using migrate mysql to postgresql. It Exist error for Below Message.

Erro Message: 11:05:39 SELECT * FROM fed_orders LIMIT 0, 1000 Error Code: 1159. Got timeout reading communication packets 30.051 sec.

Steps Used:

a) Activate Federated Engine in Mysql.

Configure /etc/my.cnf , add 'federated' keyword in [mysqld] section, then restart mysql Service.

b) Create Federated Server

CREATE SERVER fedlink FOREIGN DATA WRAPPER mysql OPTIONS (USER 'postgres', HOST '103.93.107.148', PORT 5432, DATABASE 'MOA_DB');

b) Link mysql table with fedlink server

CREATE TABLE fed_orders (
id     INT(20),
name   VARCHAR(32) NOT NULL DEFAULT '') ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 CONNECTION='fedlink/fed_orders';
0

There are 0 best solutions below