php - Connection between two servers using Federated -
i have 1 database in server application running in server b
so, in order separate information, used federated in server b access tables server a. tried 2 things:
create server s foreign data wrapper mysql options (database 'xpto', user 'aaa', password 'aaa', host 'servera'); create table if not exists `test` ( `col1` int(11) not null auto_increment, `col2` int(11) not null, primary key (`col1`) ) engine=federated default charset=utf8 connection='s';
and tried this:
create table if not exists `test` ( `col1` int(11) not null auto_increment, `col2` int(11) not null, primary key (`col1`) ) engine=federated default charset=utf8 connection='mysql://aaa:aaa@ip_address:3306/xpto/test'
the problem have lot of connections. 1 connection foreach table , every time execute query again, creates new connection. if have 11 tables, creates 11 connections, after executing again, 11+11 connections = 22 connections, , on...
after creating this, problem still there. tried create view in server b tables created last code , did querys @ views only. problem still there again!
how can execute query , close connections "sleep"?
Comments
Post a Comment