community.proxysql.proxysql_manage_config – Writes the proxysql configuration settings between layers
This plugin is part of the community.proxysql collection (version 1.3.0).
You might already have this collection installed if you are using the
It is not included in
To check whether it is installed, run
ansible-galaxy collection list.
To install it, use:
ansible-galaxy collection install community.proxysql.
To use it in a playbook, specify:
The community.proxysql.proxysql_global_variables module writes the proxysql configuration settings between layers. Currently this module will always report a changed state, so should typically be used with WHEN however this will change in a future version when the CHECKSUM table commands are available for all tables in proxysql.
The below requirements are needed on the host that executes this module.
--- # This example saves the mysql users config from memory to disk. It uses # supplied credentials to connect to the proxysql admin interface. - name: Save the mysql users config from memory to disk community.proxysql.proxysql_manage_config: login_user: 'admin' login_password: 'admin' action: "SAVE" config_settings: "MYSQL USERS" direction: "FROM" config_layer: "MEMORY" # This example loads the mysql query rules config from memory to runtime. It # uses supplied credentials to connect to the proxysql admin interface. - name: Load the mysql query rules config from memory to runtime community.proxysql.proxysql_manage_config: config_file: '~/proxysql.cnf' action: "LOAD" config_settings: "MYSQL QUERY RULES" direction: "TO" config_layer: "RUNTIME"