How to Install the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 6

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Step #1: Add the MariaDB Repository

First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new:

yum -y update

Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 6 (64 bit) MariaDB 10.0 repository.

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list – created 2014-10-10 17:33 UTC
name = MariaDB
baseurl =

Then exit and save the file with the command :wq .

Step #2: Add the EPEL Repository

The Open Query Graph engine (OQGRAPH) for MariaDB may have dependencies such as Judy that are apart of Extra Packages for Enterprise Linux (EPEL), which is a community repository of non-standard packages for the RHEL distribution. To install the EPEL repository:

rpm -iUvh

Step #3: Install the Cassandra Storage Engine for MariaDB 10.0

Be sure to backup MySQL before proceeding with the following instructions!

Clean-up the repository cache information with the following command:

yum clean all

At this point, installing the Open Query Graph engine (OQGRAPH) is as simple as running just one command:

yum -y install MariaDB-oqgraph-engine

Login to the MySQL server from the command line with the following command:

mysql -u root -p

In this case, I’ve specified the user root with the -u flag, and then used the -p flag so MySQL prompts for a password. Enter your current password to complete the login.

From the MySQL command line issue the following command:


You should receive a result similar to:

How to Install the Cassandra Storage Engine for MariaDB 10.0 on CentOS 6

Now, finish installing the storage engine:

INSTALL SONAME 'ha_oqgraph';

Which should return:

Query OK, 0 rows affected (0.00 sec)

Now let’s verify that the storage engine is installed. Run the following command and look for OQGRAPH in the Enginecolumn:


You should receive a result similar to:

How to Install the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 6

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to: Using killall to Stop Processes with Command Line

Sometimes you may find your server in a state of high load caused by out control of processes....

Use httpd fullstatus to Monitor Apache Status

Sometimes checking server performance can be difficult. Apache has built in utilities that help...

Error: /usr/sbin/ifconfig: No such file or directory [SOLVED]

There are several commonly used, but deprecated, Linux networking commands, including: arp,...

How to Commit Changes and Create Docker Images

Commit Changes to Docker To create a new image from changes to a container, it’s a simple...

How to Check Your Ubuntu Version

The following command works with all Ubuntu versions. lsb_release -a You should receive a...

Powered by WHMCompleteSolution