Galera doesn't initialize (RHEL 7.2)

36 views
Skip to first unread message

Veselin Vasilev

unread,
Aug 1, 2016, 12:53:20 AM8/1/16
to codership
Hi,
can someone please help- getting a very weird problem. My Galera doesn't seem to initialize even after trying all hints found on the net. So - my server is RHEL 7.2, MariaDB 10.1.x . On my first node my /etc/my.cnf.d/server.cnf looks like that (please note that I tried moving the settings under mysqld, mariadb10.1 etc, but the result is always one and same):
<code>
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://"
wsrep_cluster_name='galera_cluster'
wsrep_node_address='172.20.1.41'
wsrep_node_name='Mariadb-n1'
wsrep_sst_method=rsync
wsrep_sst_auth=root:[Password]
</code>

[mariadb]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
bind-address=0.0.0.0
innodb_log_file_size=100M
innodb_flush_log_at_trx_commit=2

After starting the service I receive:
<code>
[root@mariadb-n1 my.cnf.d]# service mysql start --wsrep-new-cluster
Starting mysql (via systemctl):                            [  OK  ]
[root@mariadb-n1 my.cnf.d]# mysql -u root -p --execute="SHOW GLOBAL STATUS WHERE Variable_name IN ('wsrep_ready', 'wsrep_cluster_size', 'wsrep_cluster_status', 'wsrep_connected');"
Enter password:
+----------------------+--------------+
| Variable_name        | Value        |
+----------------------+--------------+
| wsrep_cluster_size   | 0            |
| wsrep_cluster_status | Disconnected |
| wsrep_connected      | OFF          |
| wsrep_ready          | OFF          |
+----------------------+--------------+
</code>

Philip Stoev

unread,
Aug 1, 2016, 2:23:22 AM8/1/16
to Veselin Vasilev, codership
Hello,

The reason for the failure to initialize would be shown in the MySQL error
log.

Philip Stoev
--
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Christopher Marshall

unread,
Aug 1, 2016, 1:06:19 PM8/1/16
to codership

Are you running mariadb 10.1.16 and trying to start it with "systemctl start mariadb"?

Chris M
Reply all
Reply to author
Forward
0 new messages