Global variables update for proxysql

globals.sql

update global_variables set
-- UserDataMonitor 
variable_value="DBMONUSER" 
where variable_name='mysql-monitor_username';

update global_variables set
-- PasswordDataMonitor 
variable_value="DBMONPASS" 
where variable_name='mysql-monitor_password';

update global_variables set variable_value='2000' 
where variable_name in 
('mysql-monitor_connect_interval','mysql-monitor_ping_interval','mysql-monitor_read_only_interval');

update global_variables
set variable_value='127.0.0.1:6033;/var/tmp/proxysql.sock'
where variable_name='mysql-interfaces';

update global_variables set variable_value='250'
where variable_name='mysql-max_connections';

update global_variables
set variable_value='0.0.0.0:6032;/var/tmp/proxysql_admin.sock'
where variable_name='admin-mysql_ifaces';

update global_variables set
-- AdminCredentials 
variable_value="ADMINCREDS"
where variable_name='admin-admin_credentials';

SAVE MYSQL VARIABLES TO DISK;

SAVE ADMIN VARIABLES TO DISK;