brand new mariadb-10.1.18 server install

Alex Evonosky

unread,

Oct 15, 2016, 6:43:06 PM10/15/16

to codership

Hello group--

Maybe this is a simple question, as I am new to Galera...

I have Ubuntu 16.04 and installed (via apt) the mariadb-server.. The server downloaded just fine and no errors, however, after running "galera_new_cluster" I checked the syslog, and I do not even see WSREP being loaded... Looks like a standard mysql startup.

Here is my galera.cnf:

/etc/mysql/conf.d# 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_address = gcomm://10.10.10.104,10.10.13.2

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

and running the following on mariaDB:

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 |

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

Did I miss something on this setup? For right now, I am only trying to get one node up first...

Thank you.

hunter86bg

unread,

Oct 17, 2016, 2:16:35 AM10/17/16

to codership

I have installed mine (I'm on redhat) from the galeracluster.com
You should download the codership's GPG key from: GPG-KEY-galeracluster.com
There is a configuration file for apt here(if I'm not wrong): ubuntu-conf
Then you should remove your current mariadb and install the packages from the galera's repository. It should be something like this:apt-get update && apt-get install galera-3

apt-get update && apt-get install galera-3 mysql-wsrep-5.6 mysql-wsrep-server-5.6  mysql-wsrep-common-5.6 mysql-wsrep-client-5.6

The list of the files has been taken from here: ubuntu_mysql-wsrep-5.6/

Note: I haven't installed the galera on Ubuntu, but as far as I know you need to disable AppArmor

Yu Denis Sun

unread,

Oct 21, 2016, 9:49:54 PM10/21/16

to codership

I am wondering what you got when you do : ps -ef | grep mysqld

mine looks like:

mysql 38859 38599 0 20:25 pts/0 00:00:08 /apps/opt/mysql/db01/mariadb-10.1.18/bin/mysqld --defaults-file=/apps/opt/mysql/db01/mariadb-10.1.18/my.cnf --basedir=/apps/opt/mysql/db01/mariadb-10.1.18 --datadir=/apps/opt/mysql/db01/data --plugin-dir=/apps/opt/mysql/db01/mariadb-10.1.18/lib/plugin --wsrep_provider=/apps/opt/mysql/db01/mariadb-10.1.18/lib/libgalera_smm.so --wsrep_on=ON --log-error=/apps/opt/mysql/db01/admin/mysql_db01.err --pid-file=/apps/opt/mysql/db01/admin/mysql_db01.pid --socket=/apps/opt/mysql/db01/admin/mysql.sock --port=3306 --wsrep_start_position=1c36ebd3-97bd-11e6-a8be-fea1fa61cce6:0

I suppose you should see some --wsrep options like above?

I am on redhat linux, i install from tarball.

Yu Denis Sun

unread,

Oct 21, 2016, 9:59:30 PM10/21/16

to codership

>>> For right now, I am only trying to get one node up first

In my env, if i jus want to t start up one node ( or the first node in the cluster)

i do: $MYSQL_HOME/bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.cnf --wsrep-new-cluster &

You can try that with your specific MYSQL_HOME and my.cnf

Reply all

Reply to author

Forward