{"id":33,"date":"2014-02-18T00:36:43","date_gmt":"2014-02-17T23:36:43","guid":{"rendered":"http:\/\/188.166.119.205\/?p=33"},"modified":"2026-11-10T05:52:04","modified_gmt":"2026-11-10T05:52:04","slug":"mysql-replication-module-upgrade","status":"publish","type":"post","link":"https:\/\/banyek.net\/?p=33&lang=en","title":{"rendered":"MySQL replication module upgrade"},"content":{"rendered":"<p>Yesterday I\u2019ve put some new features into the ansible\u2019s mysql_replication module because we are planning to move to GTID based replication from the good old binlog position based one, and the module wasn\u2019t aware of.<\/p>\n<h3>gtid_replication<\/h3>\n<p>This parameter can be either <em>0<\/em> or <em>1<\/em>, defaults to <em>0<\/em>. If set to <em>1<\/em> the replication will be threaded as GTID based replication.<\/p>\n<h3>warnings_filtered<\/h3>\n<p>This parameter threats the warnings because of MySQL 5.6 complaints a lot more than the previous versions. (For example, if the replication is not encrypted with SSL\/TLS.) This could break our playbooks so you can set it to <em>all, warnings, none<\/em> (defaults <em>none<\/em>). Speaks for itself, <em>all<\/em> means all warnings\/errors will be shown, if <em>warnings<\/em> set, then only the errors will be shown, and the warnings suppressed, and if <em>none<\/em> then that means, every message will be show up as-is.<\/p>\n<p>If you need it, and you don\u2019t want to wait until it is merged and released, you can download it from <a href=\"https:\/\/github.com\/banyek\/ansible\/blob\/mysql_replication\/library\/database\/mysql_replication\">my GitHub repository<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday I\u2019ve put some new features into the ansible\u2019s mysql_replication module because we are planning to move to GTID based replication from the good old binlog position based one, and the module wasn\u2019t aware of. gtid_replication This parameter can be either 0 or 1, defaults to 0. If set to 1 the replication will be [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[134],"tags":[228,218,144,126],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-tech-en","tag-ansible-en","tag-gtid-en","tag-mysql-en","tag-oldblog-en"],"_links":{"self":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/33","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=33"}],"version-history":[{"count":1,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":440,"href":"https:\/\/banyek.net\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions\/440"}],"wp:attachment":[{"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/banyek.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}