История изменений
Исправление paa66, (текущая версия) :
Очевидно, ты register не в ту область видимости/скоуп пихаешь.
Сейчас у меня таск выглядит так:
- name: Get primary binlog File name and binlog Position
community.mysql.mysql_replication:
mode: getprimary
login_unix_socket: /run/mysqld/mysqld.sock
register: master_status
Ответ ансибла такой:
ok: [ubu1] => {
"Binlog_Do_DB": "",
"Binlog_Ignore_DB": "",
"Executed_Gtid_Set": "",
"File": "binlog.000005",
"Is_Primary": true,
"Position": 737,
"changed": false,
"invocation": {
"module_args": {
"ca_cert": null,
"channel": null,
"check_hostname": null,
"client_cert": null,
"client_key": null,
"config_file": "/root/.my.cnf",
"connect_timeout": 30,
"connection_name": null,
"fail_on_error": false,
"login_host": "localhost",
"login_password": null,
"login_port": 3306,
"login_unix_socket": "/run/mysqld/mysqld.sock",
"login_user": null,
"mode": "getprimary",
"primary_auto_position": false,
"primary_connect_retry": null,
"primary_delay": null,
"primary_host": null,
"primary_log_file": null,
"primary_log_pos": null,
"primary_password": null,
"primary_port": null,
"primary_ssl": null,
"primary_ssl_ca": null,
"primary_ssl_capath": null,
"primary_ssl_cert": null,
"primary_ssl_cipher": null,
"primary_ssl_key": null,
"primary_ssl_verify_server_cert": false,
"primary_use_gtid": null,
"primary_user": null,
"relay_log_file": null,
"relay_log_pos": null
}
},
"queries": []
}
Сделал иначе:
- name: Get the current master servers replication status
community.mysql.mysql_info:
filter: "master_status"
login_unix_socket: /run/mysqld/mysqld.sock
register: master_status
Ответ ансибля:
ok: [ubu1] => {
"changed": false,
"invocation": {
"module_args": {
"ca_cert": null,
"check_hostname": null,
"client_cert": null,
"client_key": null,
"config_file": "/root/.my.cnf",
"connect_timeout": 30,
"exclude_fields": null,
"filter": [
"master_status"
],
"login_db": null,
"login_host": "localhost",
"login_password": null,
"login_port": 3306,
"login_unix_socket": "/run/mysqld/mysqld.sock",
"login_user": null,
"return_empty_dbs": false
}
},
"master_status": {
"Binlog_Do_DB": "",
"Binlog_Ignore_DB": "",
"Executed_Gtid_Set": "",
"File": "binlog.000005",
"Position": 737
Тоже не нашёл переменную status_master.
Исходная версия paa66, :
Очевидно, ты register не в ту область видимости/скоуп пихаешь.
Сейчас у меня таск выглядит так:
- name: Get primary binlog File name and binlog Position
community.mysql.mysql_replication:
mode: getprimary
login_unix_socket: /run/mysqld/mysqld.sock
register: master_status
Ответ ансибла такой:
ok: [ubu1] => {
"Binlog_Do_DB": "",
"Binlog_Ignore_DB": "",
"Executed_Gtid_Set": "",
"File": "binlog.000005",
"Is_Primary": true,
"Position": 737,
"changed": false,
"invocation": {
"module_args": {
"ca_cert": null,
"channel": null,
"check_hostname": null,
"client_cert": null,
"client_key": null,
"config_file": "/root/.my.cnf",
"connect_timeout": 30,
"connection_name": null,
"fail_on_error": false,
"login_host": "localhost",
"login_password": null,
"login_port": 3306,
"login_unix_socket": "/run/mysqld/mysqld.sock",
"login_user": null,
"mode": "getprimary",
"primary_auto_position": false,
"primary_connect_retry": null,
"primary_delay": null,
"primary_host": null,
"primary_log_file": null,
"primary_log_pos": null,
"primary_password": null,
"primary_port": null,
"primary_ssl": null,
"primary_ssl_ca": null,
"primary_ssl_capath": null,
"primary_ssl_cert": null,
"primary_ssl_cipher": null,
"primary_ssl_key": null,
"primary_ssl_verify_server_cert": false,
"primary_use_gtid": null,
"primary_user": null,
"relay_log_file": null,
"relay_log_pos": null
}
},
"queries": []
}
Сделал иначе:
- name: Get the current master servers replication status
community.mysql.mysql_info:
filter: "master_status"
login_unix_socket: /run/mysqld/mysqld.sock
register: master_status
Ответ ансибля:
ok: [ubu2] => {
"changed": false,
"invocation": {
"module_args": {
"ca_cert": null,
"check_hostname": null,
"client_cert": null,
"client_key": null,
"config_file": "/root/.my.cnf",
"connect_timeout": 30,
"exclude_fields": null,
"filter": [
"master_status"
],
"login_db": null,
"login_host": "localhost",
"login_password": null,
"login_port": 3306,
"login_unix_socket": "/run/mysqld/mysqld.sock",
"login_user": null,
"return_empty_dbs": false
}
},
"master_status": {
"Binlog_Do_DB": "",
"Binlog_Ignore_DB": "",
"Executed_Gtid_Set": "",
"File": "binlog.000006",
"Position": 4230
Тоже не нашёл переменную status_master.