Hi.
Is there a way to add listener port without restarting proxysql service?
I’m trying this scenario without success :
1.
update global_variables set variable_value=‘0.0.0.0.:6033;0.0.0.0:6034;0.0.0.0:6035’ where variable_name=‘mysql-interfaces’;
save mysql variables to disk;
load mysql variables to runtime;
-
update global_variables set variable_value=‘0.0.0.0.:6033;0.0.0.0:6034;0.0.0.0:6035’ where variable_name=‘mysql-interfaces’;
save mysql variables to disk;
load mysql variables to runtime;
proxysql restart; -
update global_variables set variable_value=‘0.0.0.0.:6033;0.0.0.0:6034;0.0.0.0:6035’ where variable_name=‘mysql-interfaces’;
save mysql variables to disk;
proxysql stop;
load mysql variables to runtime;
proxysql start; -
Changing in proxysql config file “interfaces=” variable and after save
proxysql --reload
After login to proxysql admin module:
proxysql restart;
Thanks in advanced for help.