Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1568

LP #1266750: wsrep_incoming_addresses status variable empty

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Przemek last update 15-07-2014 20:52:42

      Seems like AUTO method for wsrep_node_incoming_address is not working in cluster based on MySQL 5.6.

      mysql> show variables like 'wsrep_%address%';
      ---------------------------------------------------------------+

      Variable_name Value

      ---------------------------------------------------------------+

      wsrep_cluster_address gcomm://10.0.1.4,10.0.1.5,10.0.1.6
      wsrep_node_address 10.0.1.5
      wsrep_node_incoming_address AUTO
      wsrep_sst_receive_address AUTO

      ---------------------------------------------------------------+
      4 rows in set (0.00 sec)

      mysql> show status like 'wsrep%address%';
      -------------------------------+

      Variable_name Value

      -------------------------------+

      wsrep_incoming_addresses ,,

      -------------------------------+
      1 row in set (0.00 sec)

      mysql> show variables like '%version%';
      ---------------------------------------------------------------------------------------------------+

      Variable_name Value

      ---------------------------------------------------------------------------------------------------+

      innodb_version 5.6.15-rel62.0
      protocol_version 10
      slave_type_conversions  
      version 5.6.15-56-log
      version_comment Percona XtraDB Cluster (GPL), Release 25.2, Revision 645, wsrep_25.2.r4027
      version_compile_machine x86_64
      version_compile_os Linux

      ---------------------------------------------------------------------------------------------------+
      7 rows in set (0.00 sec)

      mysql> show status like 'wsrep_provider_version';
      ---------------------------------+

      Variable_name Value

      ---------------------------------+

      wsrep_provider_version 3.2(r170)

      ---------------------------------+
      1 row in set (0.00 sec)

      All three nodes have explicitly set wsrep_node_address.

      The only way to get wsrep_incoming_addresses status variable working is to set explicitly in my.cnf:

      wsrep_node_incoming_address=10.0.1.4

      mysql> show status like 'wsrep%add%';
      -----------------------------------------+

      Variable_name Value

      -----------------------------------------+

      wsrep_incoming_addresses 10.0.1.4:3306,,

      -----------------------------------------+
      1 row in set (0.00 sec)

      The same status variable works automatically in 5.5 cluster even if both wsrep_node_address and wsrep_node_incoming_address are not set explicitly.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: