I recently just installed mariaDB 10.1.18 (via apt-get) and all went well, no issues.. Here is my galera.cnf file:
cat galera.cnf
[mysqld]
binlog_format = ROW
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2
innodb_locks_unsafe_for_binlog = 1
wsrep_on = ON
wsrep_causal_reads = ON
wsrep_cluster_name = soho_cluster
wsrep_node_address = 10.10.10.104
wsrep_provider = /usr/lib/galera/libgalera_smm.so
wsrep_provider_options = "gcache.size=512M"
wsrep_slave_threads = 4 # Should be equal to the number of cpu-cores.
wsrep_sst_auth = "sstuser:r3pl1c@t3"
#wsrep_sst_method = xtrabackup-v2
wsrep_sst_method = rsync
I started the server as: galera_new_cluster and see no errors. Syslog reports mariaDB has started. However, I never see any messages with WSREP.
the database stat shows:
mysql -u root -p -e "show status like 'wsrep%'"
Enter password:
+--------------------------+----------------------+
| 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_bf_aborts | 0 |
| wsrep_local_index | 4294967295 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | OFF |
| wsrep_thread_count | 0 |
+--------------------------+----------------------+
The wsrep always shows OFF. I have removed and purged any and all mysql, mysql-server etc three times and get the same result. Is there something I am missing?
Thank you!