proxysql_manage_config – Writes the proxysql configuration settings between layers¶
The 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.
PyMySQL (Python 2.7 and Python 3.X), or
MySQLdb (Python 2.x)
--- # This example saves the mysql users config from memory to disk. It uses # supplied credentials to connect to the proxysql admin interface. - 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 to runtime. It # uses supplied credentials to connect to the proxysql admin interface. - proxysql_manage_config: config_file: '~/proxysql.cnf' action: "LOAD" config_settings: "MYSQL QUERY RULES" direction: "TO" config_layer: "RUNTIME"
Common return values are documented here, the following are the fields unique to this module:
|Currently the returned value with always be changed=True.||
Simply reports whether the action reported a change.