{"id":231,"date":"2014-11-02T14:23:22","date_gmt":"2014-11-02T12:23:22","guid":{"rendered":"http:\/\/catyellow.net\/blog\/?p=231"},"modified":"2018-06-02T22:44:21","modified_gmt":"2018-06-02T20:44:21","slug":"install-mariadb-10-and-oqgraph-engine-on-centos-6-5","status":"publish","type":"post","link":"https:\/\/catyellow.net\/blog\/?p=231","title":{"rendered":"Install MariaDB 10 and OQGraph engine on Centos 6.5"},"content":{"rendered":"<p>These are step-by-step commands for MariaDB 10 + OQGraph engine installation:<\/p>\n<ul>\n<li>Add MariaDB repo<\/li>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">vi \/etc\/yum.repos.d\/MariaDB.repo<\/pre>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">[mariadb]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.0\/centos6-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1<\/pre>\n<li>Install MariaDB<\/li>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">sudo yum install MariaDB-server MariaDB-client<\/pre>\n<\/ul>\n<p><!--more--><\/p>\n<p>Then I got issue with <em><strong>libJudy.so.1()(64bit)<\/strong><\/em><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\"># yum install MariaDB-oqgraph-engine\r\nLoaded plugins: fastestmirror, priorities, refresh-packagekit, security\r\nLoading mirror speeds from cached hostfile\r\n * base: centos.komster.pl\r\n * extras: ftp.pbone.net\r\n * updates: ftp.ps.pl\r\nSetting up Install Process\r\nResolving Dependencies\r\n--&amp;gt; Running transaction check\r\n---&amp;gt; Package MariaDB-oqgraph-engine.x86_64 0:10.0.14-1.el6 will be installed\r\n--&amp;gt; Processing Dependency: libJudy.so.1()(64bit) for package: MariaDB-oqgraph-engine-10.0.14-1.el6.x86_64\r\n--&amp;gt; Finished Dependency Resolution\r\nError: Package: MariaDB-oqgraph-engine-10.0.14-1.el6.x86_64 (mariadb)\r\n           Requires: libJudy.so.1()(64bit)\r\n You could try using --skip-broken to work around the problem\r\n You could try running: rpm -Va --nofiles --nodigest\r\n<\/pre>\n<p>And I solved it by installing judy.x86_64 rpm package:<\/p>\n<ul>\n<li>Add naulinux-extras repo<\/li>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">vi \/etc\/yum.repos.d\/naulinux-extras.repo<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">[naulinux-extras]\r\nname=NauLinux Extras\r\nbaseurl=http:\/\/downloads.naulinux.ru\/pub\/NauLinux\/6.2\/$basearch\/Extras\/RPMS\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=http:\/\/downloads.naulinux.ru\/pub\/NauLinux\/RPM-GPG-KEY-linux-ink<\/pre>\n<li>Install judy package<\/li>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">sudo yum --enablerepo=naulinux-extras install judy<\/pre>\n<li>Install OQGraph<\/li>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">sudo yum install MariaDB-oqgraph-engine<\/pre>\n<li>Enable it (in mysql command line)<\/li>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">INSTALL SONAME 'ha_oqgraph';<\/pre>\n<p>That&#8217;s it!<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\nMariaDB [(none)]&gt; show engines;\r\n+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+\r\n| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |\r\n+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+\r\n| CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |\r\n| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |\r\n| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |\r\n| BLACKHOLE          | YES     | \/dev\/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |\r\n| MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |\r\n| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |\r\n| ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         |\r\n| FEDERATED          | YES     | FederatedX pluggable storage engine                                        | YES          | NO   | YES        |\r\n| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |\r\n| Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |\r\n| OQGRAPH            | YES     | Open Query Graph Computation Engine (http:\/\/openquery.com\/graph)           | NO           | NO   | NO         |\r\n+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+\r\n11 rows in set (0.00 sec)\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>These are step-by-step commands for MariaDB 10 + OQGraph engine installation: Add MariaDB repo Install MariaDB<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[54,55],"_links":{"self":[{"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/231"}],"collection":[{"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=231"}],"version-history":[{"count":5,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions"}],"predecessor-version":[{"id":342,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions\/342"}],"wp:attachment":[{"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/catyellow.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}