Install MariaDB 10 and OQGraph engine on Centos 6.5

by

These are step-by-step commands for MariaDB 10 + OQGraph engine installation:

  • Add MariaDB repo
    • vi /etc/yum.repos.d/MariaDB.repo
    [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
  • Install MariaDB
    • sudo yum install MariaDB-server MariaDB-client

Then I got issue with libJudy.so.1()(64bit)

# yum install MariaDB-oqgraph-engine
Loaded plugins: fastestmirror, priorities, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: centos.komster.pl
 * extras: ftp.pbone.net
 * updates: ftp.ps.pl
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-oqgraph-engine.x86_64 0:10.0.14-1.el6 will be installed
--> Processing Dependency: libJudy.so.1()(64bit) for package: MariaDB-oqgraph-engine-10.0.14-1.el6.x86_64
--> Finished Dependency Resolution
Error: Package: MariaDB-oqgraph-engine-10.0.14-1.el6.x86_64 (mariadb)
           Requires: libJudy.so.1()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

And I solved it by installing judy.x86_64 rpm package:

  • Add naulinux-extras repo
    • vi /etc/yum.repos.d/naulinux-extras.repo
    [naulinux-extras]
name=NauLinux Extras
baseurl=http://downloads.naulinux.ru/pub/NauLinux/6.2/$basearch/Extras/RPMS/
enabled=0
gpgcheck=1
gpgkey=http://downloads.naulinux.ru/pub/NauLinux/RPM-GPG-KEY-linux-ink
  • Install judy package
    • sudo yum --enablerepo=naulinux-extras install judy
  • Install OQGraph
    • sudo yum install MariaDB-oqgraph-engine
  • Enable it (in mysql command line)
    • INSTALL SONAME 'ha_oqgraph';

    That’s it!

    MariaDB [(none)]> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         |
| FEDERATED          | YES     | FederatedX pluggable storage engine                                        | YES          | NO   | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |
| OQGRAPH            | YES     | Open Query Graph Computation Engine (http://openquery.com/graph)           | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
11 rows in set (0.00 sec)