MySQL Data Analysis Extension

An data analysis extension for MySQL server using MySQL loadable function

Prerequisite

• MySQL community server >= 8.0.0
• GSL >= 2.5

Make sure you have the mysql_config command. You can install it via yum install mysql-devel(on CentOS)

Otherwise, you have to modify the INC and PLUGIN_DIR variable in Makefile with your path to mysql (/usr/local/mysql)

INC = -I/usr/local/mysql/include
PLUGIN_DIR = /usr/local/mysql/lib/plugin

Usage

Compile

1. Compile the source files via make

   make
   

2. Install the library to MySQL

   sudo make install
   

MySQL

1. Install/Uninstall functions from MySQL

   mysql -u root -p < install.sql
   mysql -u root -p < uninstall.sql
   

2. Launch MySQL server with --binary-as-hex=0 flag. (reference)

   mysql -u root -p --binary-as-hex=0