VhD%ddlmZmZmZeZdZdZdZddl Z ddl Z ddl m Z ddl mZddlmZmZdd lmZmZmZmZdd lmZgZd Zd Zd ZddZdZdZe dk(reyy))absolute_importdivisionprint_functionaf --- module: mysql_variables short_description: Manage MySQL or MariaDB global variables description: - Query / Set MySQL or MariaDB variables. author: - Balazs Pocze (@banyek) options: variable: description: - Variable name to operate. type: str required: true value: description: - If set, then sets variable value to this. - With boolean values, use C(0)|C(1) or quoted C("ON")|C("OFF"). type: str mode: description: - C(global) assigns C(value) to a global system variable which will be changed at runtime but won't persist across server restarts. - C(persist) assigns C(value) to a global system variable and persists it to the mysqld-auto.cnf option file in the data directory (the variable will survive service restarts). - C(persist_only) persists C(value) to the mysqld-auto.cnf option file in the data directory but without setting the global variable runtime value (the value will be changed after the next service restart). - Supported by MySQL 8.0 or later. - For more information see U(https://dev.mysql.com/doc/refman/8.0/en/set-variable.html). type: str choices: ['global', 'persist', 'persist_only'] default: global version_added: '0.1.0' attributes: check_mode: support: none seealso: - module: community.mysql.mysql_info - name: MySQL SET command reference description: Complete reference of the MySQL SET command documentation. link: https://dev.mysql.com/doc/refman/8.0/en/set-statement.html notes: - Compatible with MariaDB or MySQL. extends_documentation_fragment: - community.mysql.mysql a! # If you encounter the "Please explicitly state intended protocol" error, # use the login_unix_socket argument - name: Check for sync_binlog setting community.mysql.mysql_variables: variable: sync_binlog login_unix_socket: /run/mysqld/mysqld.sock - name: Set read_only variable to 1 persistently community.mysql.mysql_variables: variable: read_only value: 1 mode: persist - name: Set a boolean using ON/OFF notation mysql_variables: variable: log_slow_replica_statements value: "ON" # Make sure it's quoted z queries: description: List of executed queries which modified DB's state. returned: if executed type: list sample: ["SET GLOBAL `read_only` = 1"] version_added: '0.1.0' N)match) AnsibleModule) SQLParseErrormysql_quote_identifier) mysql_connect mysql_drivermysql_driver_fail_msgmysql_common_argument_spec) to_nativecd} |j||f|j}r|dSy#t$r)}dt|vr|j dYd}~5d}~wwxYw)z*Check variable's value in mysqld-auto.cnf.zZSELECT VARIABLE_VALUE FROM performance_schema.persisted_variables WHERE VARIABLE_NAME = %sz>> typedvalue('3') 3 >>> typedvalue('3.0') 3.0 >>> typedvalue('foobar') 'foobar' )int ValueErrorfloat)values r typedvaluer$|sI 5z     U|   L s  ( 55cv|jd|f|j}t|dk(r|ddSy)Nz'SHOW VARIABLES WHERE Variable_name = %sr)rfetchalllen)rr mysqlvar_vals r getvariabler*s> NN !%-$ 5 e$Ll+L}$])J8F )&'=>|#0E(E 9 1B!B   "IRW  YX    !NX]  ^ ~,2C"C5>C  EVX|TB~FU!%/?  A VU3u k 77>>+ &   =H)TU,#X  Z   {\efg\h!i  j kf 1s1-J53L.5 L+>A"L&&L+. M 7 MM __main__)r/)! __future__rrrr? __metaclass__ DOCUMENTATIONEXAMPLESRETURNrXrUreransible.module_utils.basicrAansible_collections.community.mysql.plugins.module_utils.databaserr >ansible_collections.community.mysql.plugins.module_utils.mysqlr r r r ansible.module_utils._textrr1rr$r*r5r=rg__name__r;r+rrtsA@ 4 l (  4sZZ0$44 _4D zFr+