Changes on mysql-interfaces shouldn't requires a restart

[renecannao]

WHY

Currently, changing mysql-interfaces requires a restarts. This is against the principle that proxysql can be reconfigured at runtime, although it is rare that someone would need to change mysql-interfaces at runtime.

WHAT

Allow to change binding address/port without the need to restart the proxy
This is already done for the admin interface, so shouldn't be difficult to port it also for MySQL threads

[renecannao]

Maybe there is a bug associated with this:
LOAD MYSQL VARIABLES TO RUNTIME resets mysql-interfaces . To be verified

[ManjotS]

setting in runtime doesnt work and restart doesnt change port either.

[renecannao]

I confirm that setting at runtime doesn't work, but this should work (just tested):

SET mysql-interfaces='0.0.0.0:6034;/tmp/proxysql.sock';
SAVE MYSQL VARIABLES TO DISK;
PROXYSQL RESTART;

[ManjotS]

This is not intuitive. But I can confirm it works.

Thanks!

On 7/15/16 5:08 PM, René Cannaò wrote:

|SET mysql-interfaces='0.0.0.0:6034;/tmp/proxysql.sock'; SAVE MYSQL
VARIABLES TO DISK; PROXYSQL RESTART;|

[renecannao]

Manjot, a bit more context:
all changes applied to memory and/or runtime are lost during a restart, therefore the changes need to be saved to disk to make them persistent across restart. That is why, in order, the variable need to changed (in memory, using SET), saved to disk (SAVE MYSQL VARIABLES TO DISK) and then restart (PROXYSQL RESTART)

[mcrauwel]

@renecannao @pondix in combination with #1363 this has an extra side effect.

I need to add an additional VIP to my proxy instances and to support query_rules based on proxy_addr I need to add this VIP's to mysql-interfaces which will trigger me to restart the entire fleet of proxysql instances which will break any active connections to my other VIP's

[h4rr21]

hello @renecannao, is there any way to change the default values of mysql-interfaces?

if I do a service proxysql restart it takes my new default value?