Control Web Panel

WebPanel => Installation => Topic started by: synxmax on July 26, 2017, 06:15:18 PM

Title: Using a Remote Mysql Cluster without Socat
Post by: synxmax on July 26, 2017, 06:15:18 PM

Hi there,

Is it necessary to use socat for remote Mysql server ?
Can't I just change configs to connect using Mysql remote port?
We have a Proxysql loadbalancer , I can't install Socat on that!
If it's possible how many config files I have to change, Is there a global variable ( Mysql host, Port, Host )?

Thanks in advance

Title: Re: Using a Remote Mysql Cluster without Socat
Post by: limpingninja on October 30, 2017, 04:13:47 AM

Hello,

Did you ever find this out? I've had issues with socat so far and was hoping to use my AWS Aurora cluster.

LN

Title: Re: Using a Remote Mysql Cluster without Socat
Post by: studio4host on October 31, 2017, 01:31:25 PM

you only need to have socat if you want that all applications checking for local mysql to connect on the remote sql.
This will make them think that they are using local mysql database server and will have no idea that they are using remote server.