LINUX.ORG.RU

История изменений

Исправление 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": []
}
В ответе я не нашёл значение переменной status_master.

Сделал иначе:

  - 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": []
}
В ответе я не нашёл значение переменной status_master.

Сделал иначе:

  - 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.