Skip to content

Instantly share code, notes, and snippets.

@wakwanza

wakwanza/globals.sql

Last active December 13, 2022 05:43
Show Gist options
  • Save wakwanza/bdeb6570e78f37cf658b8a059b0ab1cb to your computer and use it in GitHub Desktop.
Save wakwanza/bdeb6570e78f37cf658b8a059b0ab1cb to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. wakwanza revised this gist Nov 10, 2016. 1 changed file with 6 additions and 3 deletions.
    9 changes: 6 additions & 3 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,11 @@
    update global_variables set
    -- UserDataMonitor variable_value="DBMONUSER"
    -- UserDataMonitor
    variable_value="DBMONUSER"
    where variable_name='mysql-monitor_username';

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

    update global_variables set variable_value='2000'
    @@ -22,7 +24,8 @@ 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"
    -- AdminCredentials
    variable_value="ADMINCREDS"
    where variable_name='admin-admin_credentials';

    SAVE MYSQL VARIABLES TO DISK;
  2. wakwanza revised this gist Nov 10, 2016. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,9 @@
    update global_variables set
    -- DataMonitorUser variable_value="DBMONUSER"
    -- UserDataMonitor variable_value="DBMONUSER"
    where variable_name='mysql-monitor_username';

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

    update global_variables set variable_value='2000'
  3. wakwanza revised this gist Nov 10, 2016. 1 changed file with 3 additions and 6 deletions.
    9 changes: 3 additions & 6 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,11 +1,9 @@
    update global_variables set
    -- DataMonitorUser
    variable_value="DBMONUSER"
    -- DataMonitorUser variable_value="DBMONUSER"
    where variable_name='mysql-monitor_username';

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

    update global_variables set variable_value='2000'
    @@ -24,8 +22,7 @@ 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"
    -- AdminCredentials variable_value="ADMINCREDS"
    where variable_name='admin-admin_credentials';

    SAVE MYSQL VARIABLES TO DISK;
  4. wakwanza revised this gist Nov 6, 2016. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,8 +1,10 @@
    update global_variables set
    -- DataMonitorUser
    variable_value="DBMONUSER"
    where variable_name='mysql-monitor_username';

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

    @@ -22,6 +24,7 @@ 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';

  5. wakwanza revised this gist Nov 6, 2016. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,9 @@
    update global_variables set
    variable_value='DBMONUSER'
    variable_value="DBMONUSER"
    where variable_name='mysql-monitor_username';

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

    update global_variables set variable_value='2000'
    @@ -22,7 +22,7 @@ set variable_value='0.0.0.0:6032;/var/tmp/proxysql_admin.sock'
    where variable_name='admin-mysql_ifaces';

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

    SAVE MYSQL VARIABLES TO DISK;
  6. wakwanza revised this gist Nov 6, 2016. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,9 @@
    update global_variables
    set variable_value='DBMONUSER'
    update global_variables set
    variable_value='DBMONUSER'
    where variable_name='mysql-monitor_username';

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

    update global_variables set variable_value='2000'
    @@ -21,8 +21,8 @@ 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 variable_value='ADMINCREDS'
    update global_variables set
    variable_value='ADMINCREDS'
    where variable_name='admin-admin_credentials';

    SAVE MYSQL VARIABLES TO DISK;
  7. wakwanza created this gist Oct 25, 2016.
    30 changes: 30 additions & 0 deletions globals.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    update global_variables
    set variable_value='DBMONUSER'
    where variable_name='mysql-monitor_username';

    update global_variables
    set 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 variable_value='ADMINCREDS'
    where variable_name='admin-admin_credentials';

    SAVE MYSQL VARIABLES TO DISK;

    SAVE ADMIN VARIABLES TO DISK;