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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -