mysql - MariaDB Galera Cluster set up problems -


i trying mariadb cluster , running not working out me. right using mariadb galera 5.5.36 on 64 bit red hat es6 machine. installed mariadb through repo here:

[mariadb] name = mariadb baseurl = http://yum.mariadb.org/5.5-galera/rhel6-amd64/ gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadb gpgcheck=1 

in server.conf have following in server 1:

[mariadb] log_error=/var/log/mariadb.log query_cache_size=0 query_cache_type=0 binlog_format=row default_storage_engine=innodb innodb_autoinc_lock_mode=2 wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_address=gcomm://192.168.211.133 wsrep_cluster_name='cluster' wsrep_node_address='192.168.211.132' wsrep_node_name='cluster1' wsrep_sst_method=rsync 

and on server 2 have

[mariadb] log_error=/var/log/mariadb.log query_cache_size=0 query_cache_type=0 binlog_format=row default_storage_engine=innodb innodb_autoinc_lock_mode=2 wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_address=gcomm://192.168.211.132 wsrep_cluster_name='cluster' wsrep_node_address='192.168.211.133' wsrep_node_name='cluster2' wsrep_sst_method=rsync 

when start server 1 following command: sudo service mysql start --wsrep-new-cluster starts fine, if open mysql , check status of wsrep says , running when try sudo service mysql start on second server following in error logs:

140609 14:47:55 mysqld_safe starting mysqld daemon databases /var/lib/mysql 140609 14:47:56 mysqld_safe wsrep: running position recovery --log_error='/var/lib/mysql/wsrep_recovery.i5qfm2' --pid-file='/var/lib/mysql/localhost.localdomain-recover.pid' 140609 14:47:57 mysqld_safe wsrep: recovered position 85448d73-ebe8-11e3-9c20-fbc1995fee11:0 140609 14:47:57 [note] wsrep: wsrep_start_position var submitted: '85448d73-ebe8-11e3-9c20-fbc1995fee11:0' 140609 14:47:57 [note] wsrep: read nil xid storage engines, skipping position init 140609 14:47:57 [note] wsrep: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 140609 14:47:57 [note] wsrep: wsrep_load(): galera 25.3.2(r170) codership oy <info@codership.com> loaded successfully. 140609 14:47:57 [note] wsrep: crc-32c: using hardware acceleration. 140609 14:47:57 [note] wsrep: found saved state: 85448d73-ebe8-11e3-9c20-fbc1995fee11:-1 140609 14:47:57 [note] wsrep: passing config gcs: base_host = 192.168.211.133; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128m; gcache.size = 128m; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; repl.causal_read_timeout = pt30s; repl.commit_order = 3; repl.key_format = flat8; repl.proto_max = 5 140609 14:47:57 [note] wsrep: assign initial position certification: 0, protocol version: -1 140609 14:47:57 [note] wsrep: wsrep_sst_grab() 140609 14:47:57 [note] wsrep: start replication 140609 14:47:57 [note] wsrep: setting initial position 85448d73-ebe8-11e3-9c20-fbc1995fee11:0 140609 14:47:57 [note] wsrep: protonet asio version 0 140609 14:47:57 [note] wsrep: using crc-32c (optimized) message checksums. 140609 14:47:57 [note] wsrep: backend: asio 140609 14:47:57 [note] wsrep: gmcast version 0 140609 14:47:57 [note] wsrep: (0c085f34-efe5-11e3-9f6b-8bfd1706e2a4, 'tcp://0.0.0.0:4567') listening @ tcp://0.0.0.0:4567 140609 14:47:57 [note] wsrep: (0c085f34-efe5-11e3-9f6b-8bfd1706e2a4, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 140609 14:47:57 [note] wsrep: evs version 0 140609 14:47:57 [note] wsrep: pc version 0 140609 14:47:57 [note] wsrep: gcomm: connecting group 'cluster', peer '192.168.211.132:,192.168.211.134:' 140609 14:48:00 [warning] wsrep: no nodes coming prim view, prim not possible 140609 14:48:00 [note] wsrep: view(view_id(non_prim,0c085f34-efe5-11e3-9f6b-8bfd1706e2a4,1) memb {         0c085f34-efe5-11e3-9f6b-8bfd1706e2a4,0 } joined { } left { } partitioned { }) 140609 14:48:01 [warning] wsrep: last inactive check more pt1.5s ago (pt3.50775s), skipping check 140609 14:48:31 [note] wsrep: view((empty)) 140609 14:48:31 [error] wsrep: failed open gcomm backend connection: 110: failed reach primary view: 110 (connection timed out)          @ gcomm/src/pc.cpp:connect():141 140609 14:48:31 [error] wsrep: gcs/src/gcs_core.c:gcs_core_open():196: failed open backend connection: -110 (connection timed out) 140609 14:48:31 [error] wsrep: gcs/src/gcs.c:gcs_open():1291: failed open channel 'cluster' @ 'gcomm://192.168.211.132,192.168.211.134': -110 (connection timed out) 140609 14:48:31 [error] wsrep: gcs connect failed: connection timed out 140609 14:48:31 [error] wsrep: wsrep::connect() failed: 7 140609 14:48:31 [error] aborting  140609 14:48:31 [note] wsrep: service disconnected. 140609 14:48:32 [note] wsrep: threads may fail exit. 140609 14:48:32 [note] /usr/sbin/mysqld: shutdown complete  140609 14:48:32 mysqld_safe mysqld pid file /var/lib/mysql/localhost.localdomain.pid ended 

i @ loss why second server cannot detect cluster , running. these machines can communicate each other fine, can ssh 1 other , can ping each other. tried deleted galera cache, tried downgrading version of mariadb galera, tried disabling selinux, tried running mysql service different user, verified correct ports open, tried running them on 2 vms on separate computers different ip addresses, etc. have idea going on here because have been searching 3 days trying fix no solution seems work me.

i believe need list ips in wsrep_cluster_address parameter.

wsrep_cluster_address=gcomm://192.168.211.132,192.168.211.133

this should done on both hosts. btw want 3 nodes not 2 avoid split brain scenarios.


Comments

Popular posts from this blog

database - VFP Grid + SQL server 2008 - grid not showing correctly -

jquery - Set jPicker field to empty value -

.htaccess - htaccess convert request to clean url and add slash at the end of the url -