ansible / ansible.builtin / v2.4.2.0-1 / module / proxysql_backend_servers Adds or removes mysql hosts from proxysql admin interface. | "added in version" 2.3 of ansible.builtin" Authors: Ben Mildren (@bmildren) stableinterface | supported by communityansible.builtin.proxysql_backend_servers (v2.4.2.0-1) — module
pip
Install with pip install ansible==2.4.2.0.post1
The M(proxysql_backend_servers) module adds or removes mysql hosts using the proxysql admin interface.
--- # This example adds a server, it saves the mysql server config to disk, but # avoids loading the mysql server config to runtime (this might be because # several servers are being added and the user wants to push the config to # runtime in a single batch using the M(proxysql_manage_config) module). It # uses supplied credentials to connect to the proxysql admin interface. - proxysql_backend_servers: login_user: 'admin' login_password: 'admin' hostname: 'mysql01' state: present load_to_runtime: False
# This example removes a server, saves the mysql server config to disk, and # dynamically loads the mysql server config to runtime. It uses credentials # in a supplied config file to connect to the proxysql admin interface. - proxysql_backend_servers: config_file: '~/proxysql.cnf' hostname: 'mysql02' state: absent
port: default: 3306 description: - The port at which the mysqld instance can be contacted. state: choices: - present - absent default: present description: - When C(present) - adds the host, when C(absent) - removes the host. status: choices: - ONLINE - OFFLINE_SOFT - OFFLINE_HARD description: - 'ONLINE - Backend server is fully operational. OFFLINE_SOFT - When a server is put into C(OFFLINE_SOFT) mode, connections are kept in use until the current transaction is completed. This allows to gracefully detach a backend. OFFLINE_HARD - When a server is put into C(OFFLINE_HARD) mode, the existing connections are dropped, while new incoming connections aren''t accepted either. If omitted the proxysql database default for I(status) is C(ONLINE).' weight: description: - The bigger the weight of a server relative to other weights, the higher the probability of the server being chosen from the hostgroup. If omitted the proxysql database default for I(weight) is 1. comment: default: '' description: - Text field that can be used for any purposed defined by the user. Could be a description of what the host stores, a reminder of when the host was added or disabled, or a JSON processed by some checker script. use_ssl: description: - If I(use_ssl) is set to C(True), connections to this server will be made using SSL connections. If omitted the proxysql database default for I(use_ssl) is C(False). hostname: description: - The ip address at which the mysqld instance can be contacted. 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. compression: description: - If the value of I(compression) is greater than 0, new connections to that server will use compression. If omitted the proxysql database default for I(compression) is 0. config_file: default: '' description: - Specify a config file from which login_user and login_password are to be read. hostgroup_id: default: 0 description: - The hostgroup in which this mysqld instance is included. An instance can be part of one or more hostgroups. 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. max_latency_ms: description: - Ping time is monitored regularly. If a host has a ping time greater than I(max_latency_ms) it is excluded from the connection pool (although the server stays ONLINE). If omitted the proxysql database default for I(max_latency_ms) is 0. load_to_runtime: default: true description: - Dynamically load mysql host config to runtime memory. max_connections: description: - The maximum number of connections ProxySQL will open to this backend server. If omitted the proxysql database default for I(max_connections) is 1000. max_replication_lag: description: - If greater than 0, ProxySQL will reguarly monitor replication lag. If replication lag goes above I(max_replication_lag), proxysql will temporarily shun the server until replication catches up. If omitted the proxysql database default for I(max_replication_lag) is 0.
stdout: description: The mysql host modified or removed from proxysql returned: On create/update will return the newly modified host, on delete it will return the deleted record. sample: changed: true hostname: 192.168.52.1 msg: Added server to mysql_hosts server: comment: '' compression: '0' hostgroup_id: '1' hostname: 192.168.52.1 max_connections: '1000' max_latency_ms: '0' max_replication_lag: '0' port: '3306' status: ONLINE use_ssl: '0' weight: '1' state: present type: dict