diff options
| author | Andrey Klychkov <aaklychkov@mail.ru> | 2019-10-03 15:32:41 +0300 |
|---|---|---|
| committer | Abhijit Menon-Sen <abhijit@menon-sen.com> | 2019-10-03 18:02:41 +0530 |
| commit | ea86b2c2f70eefe123cbfed223fad68d92003c5c (patch) | |
| tree | 089402a2ef485586931076fef9826c8d2fa63a19 /lib/ansible/modules/database/mysql/mysql_replication.py | |
| parent | 6ad6fde424d2b740af993c6d0e3a36436c169c20 (diff) | |
| download | ansible-ea86b2c2f70eefe123cbfed223fad68d92003c5c.tar.gz | |
mysql_replication: add master_use_gtid parameter (#62648)
* mysql_replication: add master_use_gtid parameter
* mysql_replication: add master_use_gtid parameter, improve tests
Diffstat (limited to 'lib/ansible/modules/database/mysql/mysql_replication.py')
| -rw-r--r-- | lib/ansible/modules/database/mysql/mysql_replication.py | 39 |
1 files changed, 31 insertions, 8 deletions
diff --git a/lib/ansible/modules/database/mysql/mysql_replication.py b/lib/ansible/modules/database/mysql/mysql_replication.py index d1d81e62a3..f6209e0f5a 100644 --- a/lib/ansible/modules/database/mysql/mysql_replication.py +++ b/lib/ansible/modules/database/mysql/mysql_replication.py @@ -103,31 +103,47 @@ options: - Whether the host uses GTID based replication or not. type: bool version_added: "2.0" + master_use_gtid: + description: + - Configures the slave to use the MariaDB Global Transaction ID. + - C(disabled) equals MASTER_USE_GTID=no command. + - To find information about available values see + U(https://mariadb.com/kb/en/library/change-master-to/#master_use_gtid). + - Available since MariaDB 10.0.2. + choices: [current_pos, slave_pos, disabled] + type: str + version_added: "2.10" + extends_documentation_fragment: - mysql ''' EXAMPLES = r''' -# Stop mysql slave thread -- mysql_replication: +- name: Stop mysql slave thread + mysql_replication: mode: stopslave -# Get master binlog file name and binlog position -- mysql_replication: +- name: Get master binlog file name and binlog position + mysql_replication: mode: getmaster -# Change master to master server 192.0.2.1 and use binary log 'mysql-bin.000009' with position 4578 -- mysql_replication: +- name: Change master to master server 192.0.2.1 and use binary log 'mysql-bin.000009' with position 4578 + mysql_replication: mode: changemaster master_host: 192.0.2.1 master_log_file: mysql-bin.000009 master_log_pos: 4578 -# Check slave status using port 3308 -- mysql_replication: +- name: Check slave status using port 3308 + mysql_replication: mode: getslave login_host: ansible.example.com login_port: 3308 + +- name: On MariaDB change master to use GTID current_pos + mysql_replication: + mode: changemaster + master_use_gtid: current_pos ''' RETURN = r''' @@ -242,6 +258,7 @@ def main(): client_cert=dict(type='path', aliases=['ssl_cert']), client_key=dict(type='path', aliases=['ssl_key']), ca_cert=dict(type='path', aliases=['ssl_ca']), + master_use_gtid=dict(type='str', choices=['current_pos', 'slave_pos', 'disabled']), ) ) mode = module.params["mode"] @@ -266,6 +283,10 @@ def main(): ssl_ca = module.params["ca_cert"] connect_timeout = module.params['connect_timeout'] config_file = module.params['config_file'] + if module.params.get("master_use_gtid") == 'disabled': + master_use_gtid = 'no' + else: + master_use_gtid = module.params["master_use_gtid"] if mysql_driver is None: module.fail_json(msg=mysql_driver_fail_msg) @@ -337,6 +358,8 @@ def main(): chm.append("MASTER_SSL_CIPHER='%s'" % master_ssl_cipher) if master_auto_position: chm.append("MASTER_AUTO_POSITION=1") + if master_use_gtid is not None: + chm.append("MASTER_USE_GTID=%s" % master_use_gtid) try: changemaster(cursor, chm) except mysql_driver.Warning as e: |