How to start Percona Xtradb Cluster on CentOS 7

Normally, when we want to start PXC (Percona XtraDB Cluster) on RHEL/CentOS 6 or older then that, we can simply start with init.d script or service command. i.e shell> /etc/init.d/mysql start OR shell> /etc/init.d/mysql bootstrap-pxc shell> service mysql start. But, Continue reading How to start Percona Xtradb Cluster on CentOS 7

libssl.so.6: cannot open shared object file with Debian/CentOS

Actually, I found this error many times, while installing MySQL/Percona servers with MySQL Sandbox. To resolve this issue, first, you have to make sure that, SSL is installed /update properly. sudo apt-get update sudo apt-get install libssl1.0.0 libssl-dev After installing Continue reading libssl.so.6: cannot open shared object file with Debian/CentOS

FATAL: failed to initialize database driver! with Sysnbech 0.4.X

Recently, I came through with this error. It was weird because I have never seen this error earlier. [root@percona-pxc55-1 nilnandan]# sysbench –test=oltp –oltp-table-size=1000000 –mysql-db=dbtest –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5537.sock prepare sysbench 0.4.12: multi-threaded system evaluation benchmark FATAL: no database driver specified FATAL: Continue reading FATAL: failed to initialize database driver! with Sysnbech 0.4.X

How to convert master-slave to master-master replication in MySQL

Recently, I have worked on one of this case where customer wanted to convert master-slave to master-master replication. They wanted to write on one master and keep another master as a hotspare. Many people are using this kind of environment Continue reading How to convert master-slave to master-master replication in MySQL