How to setup MariaDB w/ OQGraph Plugin

oqgraph_notes.md

• Download all from: MariaDB deb package repository

• install packages:

  dpkg --install libmariadbclient16_5.2.3-mariadb87_amd64.deb \
  libmysqlclient16_5.2.3-mariadb87_amd64.deb \
  mariadb-client_5.2.3-mariadb87_all.deb  \
  mariadb-client-5.2_5.2.3-mariadb87_amd64.deb  \
  mariadb-server_5.2.3-mariadb87_all.deb  \
  mariadb-server-5.2_5.2.3-mariadb87_amd64.deb  \
  mariadb-client-core-5.2_5.2.3-mariadb87_amd64.deb  \
  mariadb-server-core-5.2_5.2.3-mariadb87_amd64.deb
  
  apt-get install libdbi-perl libdbd-mysql-perl psmisc 
  

• enable OQGraph engine (once per installation / setup):

  echo "install plugin oqgraph soname 'ha_oqgraph.so';" | mysql -u root -p
  

• Test via mysql:

  CREATE DATABASE graph;
  USE graph
  CREATE TABLE graph.tblname (
  latch   SMALLINT  UNSIGNED NULL,
  origid  BIGINT    UNSIGNED NULL,
  destid  BIGINT    UNSIGNED NULL,
  weight  DOUBLE    NULL,
  seq     BIGINT    UNSIGNED NULL,
  linkid  BIGINT    UNSIGNED NULL,
  KEY (latch, origid, destid) USING HASH,
  KEY (latch, destid, origid) USING HASH
  ) ENGINE=OQGRAPH;
  

• see: OpenQuery Graph Documentation