LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Password
Red Hat This forum is for the discussion of Red Hat Linux.

Notices


Reply
  Search this Thread
Old 03-03-2015, 04:57 PM   #1
blakk
LQ Newbie
 
Registered: Mar 2015
Posts: 1

Rep: Reputation: Disabled
MariaDB Galera Cluster Starting Issue


Hey All, I'm semi new to linux and this group and I'm hoping you might be able to help me out a little.

I have a vanilla installation of RHEL 7 and I'm trying to setup a two node MariaDB Galera Cluster but I getting the following error message when I try to start the service:

[root@db2 ~]# /usr/libexec/mysqld --wsrep-new-cluster --user=root &
[1] 10043
[root@db2 ~]# 150303 16:41:55 InnoDB: The InnoDB memory heap is disabled
150303 16:41:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150303 16:41:55 InnoDB: Compressed tables use zlib 1.2.7
150303 16:41:55 InnoDB: Using Linux native AIO
150303 16:41:55 InnoDB: Initializing buffer pool, size = 128.0M
150303 16:41:55 InnoDB: Completed initialization of buffer pool
150303 16:41:55 InnoDB: highest supported file format is Barracuda.
150303 16:41:55 InnoDB: Waiting for the background threads to start
150303 16:41:56 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150303 16:41:56 [Note] Plugin 'FEEDBACK' is disabled.
150303 16:41:56 [ERROR] /usr/libexec/mysqld: unknown variable 'wsrep_provider=/usr/lib64/galera/libgalera_smm.so'
150303 16:41:56 [ERROR] Aborting

150303 16:41:56 InnoDB: Starting shutdown...
150303 16:41:57 InnoDB: Shutdown completed; log sequence number 1597945
150303 16:41:57 [Note] /usr/libexec/mysqld: Shutdown complete


The below are the commands and file edits I've done:

wget http://dl.fedoraproject.org/pub/epel...7-5.noarch.rpm

rpm --import http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL-7
rpm -ivh epel-release-7-5.noarch.rpm

yum install mariadb mariadb-server galera -y

nano /etc/my.cnf
bind-address=2xx.4x.2xx.116
port=3306
log-bin=1
log-basename=blakk
general-log
slow-query-log=1
slow-query-log-file=/var/log/mariadb-slow-queries.log

nano /etc/my.cnf.d/server.cnf
[mariadb]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_doublewrite=1
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_name=“db_cluster"
wsrep_cluster_address=gcomm://2xx.4x.2xx.116,2xx.4x.2xx.117
wsrep_node_name=‘db1'
wsrep_node_address='2xx.4x.2xx.116'
wsrep_sst_method=rsync


Can anymore help or maybe point me into into the right direction
 
Old 03-05-2015, 02:55 PM   #2
dijetlo
Senior Member
 
Registered: Jan 2009
Location: RHELtopia....
Distribution: Solaris 11.2/Slackware/RHEL/
Posts: 1,491
Blog Entries: 2

Rep: Reputation: Disabled
Quote:
I'm semi new to linux
Then please don't be offended if I ask you a semi-dumb suggestion.
Why don't you wrap this path
"/usr/lib64/galera/libgalera_smm.so"
In quotes and see if that forces the mysqld to parse it.
Or it could be something as simple as you need to put a spaces between "provider" and "=" and "/usr".

Of course if all that fails, you might try RTFM

I've never put a MariaDB on a cluster, but when I had to load up an Oracle 11.x DB on one, I spent a week reading the one from Oracle before I started.

Last edited by dijetlo; 03-06-2015 at 12:39 AM.
 
Old 03-05-2015, 03:17 PM   #3
pingu
Senior Member
 
Registered: Jul 2004
Location: Skuttunge SWEDEN
Distribution: Debian preferably
Posts: 1,350

Rep: Reputation: 127Reputation: 127
Maybe libgalera_smm.so is under directory "/usr/lib/" not "/usr/lib64/"
You should be able to find it with a "locate libgalera_smm.so"
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
phpMyadmin config.inc.php issue v 4.3.3 on mariadb 10.0.14 lost_time Linux - Software 1 12-28-2014 10:55 PM
[SOLVED] Issue with Ubuntu Server 14.04 and mariadb circus78 Ubuntu 1 11-17-2014 06:55 AM
LXer: Installing The Galera-Iworx Cluster LXer Syndicated Linux News 0 06-27-2013 12:00 PM
[SOLVED] RHEL5-cluster-cman service not starting-at fencing priyakishan Linux - Server 3 04-12-2012 11:48 AM
Starting to build a cluster martins48 Linux - Software 4 10-21-2011 06:33 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat

All times are GMT -5. The time now is 05:13 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration