community / community.general / 0.1.1 / module / proxysql_replication_hostgroups Manages replication hostgroups using the proxysql admin interface. Authors: Ben Mildren (@bmildren) stableinterface | supported by communitycommunity.general.proxysql_replication_hostgroups (0.1.1) — module
Install with ansible-galaxy collection install community.general:==0.1.1
collections: - name: community.general version: 0.1.1
Each row in mysql_replication_hostgroups represent a pair of writer_hostgroup and reader_hostgroup. ProxySQL will monitor the value of read_only for all the servers in specified hostgroups, and based on the value of read_only will assign the server to the writer or reader hostgroups.
--- # This example adds a replication hostgroup, it saves the mysql server config # to disk, but avoids loading the mysql server config to runtime (this might be # because several replication hostgroup 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_replication_hostgroups: login_user: 'admin' login_password: 'admin' writer_hostgroup: 1 reader_hostgroup: 2 state: present load_to_runtime: False
# This example removes a replication hostgroup, 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_replication_hostgroups: config_file: '~/proxysql.cnf' writer_hostgroup: 3 reader_hostgroup: 4 state: absent
state: choices: - present - absent default: present description: - When C(present) - adds the replication hostgroup, when C(absent) - removes the replication hostgroup. comment: description: - Text field that can be used for any purposes defined by the user. login_host: default: 127.0.0.1 description: - The host used to connect to ProxySQL admin interface. type: str login_port: default: 6032 description: - The port used to connect to ProxySQL admin interface. type: int login_user: description: - The username used to authenticate to ProxySQL admin interface. type: str config_file: default: '' description: - Specify a config file from which I(login_user) and I(login_password) are to be read. type: path save_to_disk: default: 'yes' description: - Save config to sqlite db on disk to persist the configuration. type: bool login_password: description: - The password used to authenticate to ProxySQL admin interface. type: str load_to_runtime: default: 'yes' description: - Dynamically load config to runtime memory. type: bool reader_hostgroup: description: - Id of the reader hostgroup. required: true writer_hostgroup: description: - Id of the writer hostgroup. required: true
stdout: description: The replication hostgroup modified or removed from proxysql returned: On create/update will return the newly modified group, on delete it will return the deleted record. sample: changed: true msg: Added server to mysql_hosts repl_group: comment: '' reader_hostgroup: '1' writer_hostgroup: '2' state: present type: dict