ansible / ansible.builtin / v2.3.3.0-1 / module / proxysql_global_variables Gets or sets the proxysql global variables. | "added in version" 2.3 of ansible.builtin" Authors: Ben Mildren (@bmildren) stableinterface | supported by communityansible.builtin.proxysql_global_variables (v2.3.3.0-1) — module
pip
Install with pip install ansible==2.3.3.0.post1
The M(proxysql_global_variables) module gets or sets the proxysql global variables.
--- # This example sets the value of a variable, saves the mysql admin variables # config to disk, and dynamically loads the mysql admin variables config to # runtime. It uses supplied credentials to connect to the proxysql admin # interface. - proxysql_global_variables: login_user: 'admin' login_password: 'admin' variable: 'mysql-max_connections' value: 4096
# This example gets the value of a variable. It uses credentials in a # supplied config file to connect to the proxysql admin interface. - proxysql_global_variables: config_file: '~/proxysql.cnf' variable: 'mysql-default_query_delay'
value: description: - Defines a value the variable specified using I(variable) should be set to. variable: description: - Defines which variable should be returned, or if I(value) is specified which variable should be updated. required: true login_host: default: 127.0.0.1 description: - The host used to connect to ProxySQL admin interface. login_port: default: 6032 description: - The port used to connect to ProxySQL admin interface. login_user: default: None description: - The username used to authenticate to ProxySQL admin interface. config_file: default: '' description: - Specify a config file from which login_user and login_password are to be read. save_to_disk: default: true description: - Save mysql host config to sqlite db on disk to persist the configuration. login_password: default: None description: - The password used to authenticate to ProxySQL admin interface. load_to_runtime: default: true description: - Dynamically load mysql host config to runtime memory.
stdout: description: Returns the mysql variable supplied with it's associted value. returned: Returns the current variable and value, or the newly set value for the variable supplied.. sample: changed: false msg: The variable is already been set to the supplied value var: variable_name: mysql-poll_timeout variable_value: '3000' type: dict