Announcement

Announcement Module
Collapse
No announcement yet.

problem with sync

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • problem with sync

    Trying to set up a cluster of three nodes and there is no synchronization.
    Conf node1:

    [mysqld]
    server_id=1
    binlog_format=ROW
    log_bin=mysql-bin
    wsrep_cluster_address=gcomm://
    wsrep_provider=/usr/lib/libgalera_smm.so
    datadir=/var/lib/mysql

    wsrep_slave_threads=2
    wsrep_cluster_name=pxctest
    wsrep_sst_method=xtrabackup
    wsrep_node_name=Galera_cluster

    log_slave_updates

    innodb_locks_unsafe_for_binlog=1
    innodb_autoinc_lock_mode=2
    innodb_buffer_pool_size=400M
    innodb_log_file_size=64M


    Conf node2:

    [mysqld]
    server_id=2
    binlog_format=ROW
    log_bin=mysql-bin
    wsrep_cluster_address=gcomm://192.168.0.102 // <- this ip node1
    wsrep_provider=/usr/lib/libgalera_smm.so
    datadir=/var/lib/mysql

    wsrep_slave_threads=2
    wsrep_cluster_name=pxctest
    wsrep_sst_method=xtrabackup
    wsrep_node_name=Galera_cluster2

    log_slave_updates

    innodb_locks_unsafe_for_binlog=1
    innodb_autoinc_lock_mode=2
    innodb_buffer_pool_size=400M
    innodb_log_file_size=64M


    root@ubuntu:/etc/mysql# ls -oa /usr/lib/libgalera_smm.so
    -rw-r--r-- 1 root 2252744 Jan 30 09:31 /usr/lib/libgalera_smm.so


    First start mysql on node1, then node2.


    mysql> show global status like 'wsrep%';
    +--------------------------+----------------------+
    | Variable_name | Value |
    +--------------------------+----------------------+
    | wsrep_cluster_conf_id | 18446744073709551615 |
    | wsrep_cluster_size | 0 |
    | wsrep_cluster_state_uuid | |
    | wsrep_cluster_status | Disconnected |
    | wsrep_connected | OFF |
    | wsrep_local_index | 18446744073709551615 |
    | wsrep_provider_name | |
    | wsrep_provider_vendor | |
    | wsrep_provider_version | |
    | wsrep_ready | ON |
    +--------------------------+----------------------+
    10 rows in set (0.00 sec)


    Other things I've checked:

    Firewall: none running
    Conflicting ports: none
    SELinux: disabled

    What am I doing wrong? Grateful for the help in advance

  • #2
    PS Found in the logs of mysql row:
    WSREP: wsrep_load(): loading provider library 'none'

    although libgalera_smm.so is in place and is registered in the config

    Comment


    • #3
      Are you still having this issue? could you please send un the full error log?

      The "mysql> show global status like 'wsrep%';" was from the node1? if not, could you please send us the output of that command from the node1?

      Regards,

      Martin

      Comment

      Working...
      X