CODEWITHSUNDEEP
mysqlpostgresqlfederated-table
Kalidoss KN
Kalidoss KN

Reputation: 41

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

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';

Upvotes: 0

Views: 974

Answers (0)

Related Questions