community.proxysql.proxysql_replication_hostgroups – Manages replication hostgroups using the proxysql admin interface
This plugin is part of the community.proxysql collection (version 1.2.0).
To install it use:
ansible-galaxy collection install community.proxysql.
To use it in a playbook, specify:
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.
The below requirements are needed on the host that executes this module.
--- # 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 # community.general.proxysql_manage_config module). It uses supplied credentials # to connect to the proxysql admin interface. - name: Add a replication hostgroup community.proxysql.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. - name: Remove a replication hostgroup community.proxysql.proxysql_replication_hostgroups: config_file: '~/proxysql.cnf' writer_hostgroup: 3 reader_hostgroup: 4 state: absent
Common return values are documented here, the following are the fields unique to this module: