Since there's no port or package, I'm trying to install MariaDB 5.5 with Galera from source, which I downloaded from https://downloads.mariadb.org/mariadb-galera/5.5.41/. After changing my present working directory to the directory containing the tree extracted from the source tarball, I compiled and built from source as follows:
The above code installs the software under /usr/local/mysql, which is a mount point for a ZFS file system with the non-default options of setuid=off, atime=off, and compression=lz4.
I installed the wsrep provider software via databases/galera:
Here I install the initial MariaDB tables:
My configuration settings are stored in /usr/local/mysql/my.cnf:
I copied /usr/local/mysql/support-files/mysql.server to /usr/local/etc/rc.d/mysql.server and modified as follows:
I made sure to set ownership of everything under /usr/local/mysql/data to the mysql user and group. So far so good.
The problem occurs when I try to bootstrap the cluster. When I run
The aforementioned command is actually running
When I run that command in the shell, I get a segmentation fault:
Has anyone setup MariaDB 5.5 with Galera on FreeBSD 10?
cmake . -DBUILD_CONFIG=mysql_release -DWITH_WSREP=ON -DWITH_INNODB_DISALLOW_WRITES=1
make
make install
The above code installs the software under /usr/local/mysql, which is a mount point for a ZFS file system with the non-default options of setuid=off, atime=off, and compression=lz4.
I installed the wsrep provider software via databases/galera:
cd /usr/ports/databases/galera ; make -DBATCH install clean
Here I install the initial MariaDB tables:
cd /usr/local/mysql
scripts/mysql_install_db
My configuration settings are stored in /usr/local/mysql/my.cnf:
Code:
[mysqld]
user=mysql
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_provider=/usr/local/lib/libgalera_smm.so
#wsrep_provider_options="gcache.size=32G"
# Galera Cluster Configuration
wsrep_cluster_name="staging_cluster"
# Initialize the cluster; switch after --wsrep-new-cluster has been run and other nodes have joined.
wsrep_cluster_address="gcomm://"
# Set cluster node addresses (hostnames work too)
#wsrep_cluster_address="gcomm://192.168.0.1,192.168.0.2,192.168.0.3"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
#wsrep_sst_auth=user:pass
# Galera Node Configuration
wsrep_node_address="192.168.13.246"
wsrep_node_name="aus-mis-db-01.domain.com"
Code:
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
The problem occurs when I try to bootstrap the cluster. When I run
service mysql.server bootstrap
, MariaDB fails to start:
Code:
root@aus-mis-db-01:/usr/local/mysql # service mysql.server bootstrap
Bootstrapping the cluster.. Starting MySQL.. ERROR!
/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com.pid --wsrep-new-cluster &
When I run that command in the shell, I get a segmentation fault:
Code:
root@aus-mis-db-01:/usr/local/mysql # bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com.pid --wsrep-new-cluster &
[1] 68659
root@aus-mis-db-01:/usr/local/mysql # 150303 13:03:54 mysqld_safe Logging to '/usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com.err'.
150303 13:03:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
150303 13:03:54 mysqld_safe WSREP: Running position recovery with --log_error='/usr/local/mysql/data/wsrep_recovery.HKUGwW' --pid-file='/usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com-recover.pid'
150303 13:03:56 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
Segmentation fault
150303 13:03:56 mysqld_safe mysqld from pid file /usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com.pid ended
[1] Done bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/aus-mis-db-01.flatironssolutions.com.pid --wsrep-new-cluster