The Ultimate Guide to High Availability with MariaDB

OQGRAPH not in 5.3?

Downloaded Mariadb specifically for this feature. Can I download a plugin for it? I've already visited the open query site where they indicate plugin "didn't quite make it" yet. I'm running deb/ubuntu version. Any suggestions would be helpful.

Answer Answered by Daniel Bartholomew in this comment.

The OQGraph plugin is included in MariaDB 5.3 (not 5.5 or later), but it is disabled by default. To use it, use INSTALL PLUGIN to activate it, like so:

MariaDB [(none)]> INSTALL PLUGIN oqgraph SONAME 'ha_oqgraph.so';
Query OK, 0 rows affected (0.48 sec)

This only needs to be done once. Once activated, OQGRAPH will appear in the list of installed storage engines:

MariaDB [(none)]> SHOW ENGINES;
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
...
| OQGRAPH    | YES     | Open Query Graph Computation Engine, stored in memory (http://openquery.com/graph)               | NO           | NO   | NO         |
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
11 rows in set (0.00 sec)

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.