These are step-by-step commands for MariaDB 10 + OQGraph engine installation:
- Add MariaDB repo
vi /etc/yum.repos.d/MariaDB.repo |
- Install MariaDB
sudo yum install MariaDB-server MariaDB-client |
Then I got issue with libJudy.so.1()(64bit)
Loaded plugins: fastestmirror, priorities, refresh-packagekit, security |
Loading mirror speeds from cached hostfile |
* base: centos.komster.pl |
Setting up Install Process |
--> 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 |
- 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 | |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ |
11 rows in set (0.00 sec) |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
