- These instructions are intended for installing the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 7.
- I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
- Your server should already have MariaDB 10.0 installed. If you’re working from MariaDB 5.5 visit our tutorial on How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7
Step #1: Add the MariaDB RepositoryFirst, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new:
yum -y updateNow 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. For a refresher on editing files with vim see: New User Tutorial: Overview of the Vim Text Editor
vim /etc/yum.repos.d/MariaDB10.repo# MariaDB 10.0 CentOS repository list – created 2014-10-10 17:33 UTC # http://mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 Then exit and save the file with the command :wq .
Step #2: Add the EPEL RepositoryThe Open Query Graph engine (OQGRAPH) for MariaDB may have dependencies such as Judy that are a part 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 http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
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 allAt this point, installing the Open Query Graph engine (OQGRAPH) is as simple as running just one command:
yum -y install MariaDB-oqgraph-engineLogin to the MySQL server from the command line with the following command:
mysql -u root -pIn 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:
SHOW ENGINES;You should receive a result similar to: 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 Engine column:
SHOW ENGINES;You should receive a result similar to: