Percona Xtradb cluster db not starting

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,
I am trying to start Percona XtraDB Cluster server after following the documentation. The Server is installed on RHEL 5.5

I get this error when I run mysqld :

120810 15:26:46 [Note] WSREP: wsrep_load(): loading provider library ‘/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/libgalera_smm. so’
120810 15:26:46 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory
120810 15:26:46 [ERROR] WSREP: wsrep_load(/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/libg alera_smm.so) failed: Invalid argument (22). Reverting to no provider.
120810 15:26:46 [Note] WSREP: wsrep_load(): loading provider library ‘none’
120810 15:26:46 [ERROR] Aborting

the my.4000.cnf file I use to start is as given below:

============================
[mysqld]
gdb

datadir=/backup/perconacluster_data
basedir=/usr/local/percona-xtradb-cluster-5.5.20

port = 4000
socket=/tmp/mysql.4000.sock

user=root

binlog_format=ROW

wsrep_provider=/usr/local/Percona-XtraDB-Cluster-5.5.24/lib/ libgalera_smm.so

wsrep_cluster_address=gcomm://

wsrep_provider_options = "gmcast.listen_addr=tcp://0.0.0.0:4010; "
wsrep_sst_receive_address=192.168.0.12:4020

wsrep_slave_threads=2
wsrep_cluster_name=trimethylxanthine
wsrep_sst_method=rsync
wsrep_node_name=node4000

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2

============================

Have anyone come across this error? Any idea how this can be resolved?

2

Hi,

I guess, the issue is with this line.
“120810 15:26:46 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory”

Can you check with the command “dpkg -L libssl1.0.0” that libssl.so file is there or not? If not than can you install “libssl1.0.0” with apt-get install libssl1.0.0 command and check?

3

Hi,

That file is provided by openssl-1.0.0, on RHEL 5.5 last version is 0.9.8e

You need to install Percona Cluster for the 5 series ([URL]http://repo.percona.com/testing/centos/5/os/x86_64/[/URL]) and not for CentOS 6 (RHEL 6).

The version for centos5 is linked to libss.so.6

Regards,

4

Hi ,
I have tried but its not working.

Still i got the same error

“ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.10: cannot open shared object file: No such file or directory”
My OS Version :RHEL 5.5.

And let me know is there any library dependency packages required to install percona xtradb cluster.

I have used binary version and downloaded path is: /downloads/Percona-XtraDB-Cluster/5.5.20-23.4/binary/linux/x 86_64/percona-xtradb-cluster-5.5.20-23.4.3748.Linux.x86_64.r hel5.tar.gz

And let me know the full structured procedure to install percona xtradb cluster