How to setup three nodes MariaDB Galera Cluster on Single server with MySQL sandbox

For the production environment, it’s recommended that we should use separate server for each Galera Cluster node but sometimes, for the testing purpose we have to setup it on one server with different ports. Here are the steps for how to do that with CentOS 6.8, MariaDB Galera Cluster 10.1.21 and MySQL Sandbox Download MariaDB 10.1.21 from this location…

How to install sysbench 0.5 on Debian 7

Normally, sysbench 0.4.12 version can be installed from repositories like “apt-get install sysbench” but the newer version 0.5 is not added in any repo yet (AFAIK) so, it’s bit difficult to install it. 1. Install bzr package if it’s not installed. (i.e apt-get install bzr) 2. Download the code from branch. (i.e bzr branch lp:sysbench) …

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: failed to initialize database driver! [root@percona-pxc55-1 nilnandan]# After some research, found that with Sysbench 0.4.x,…