Introduction

This document describes how to deploy MySQL Pluggable Kunpeng Online Vectorized Analysis Engine (KOVAE) on a Kunpeng server running the openEuler OS and use the KOVAE features. This document also provides solutions to faults that may occur during the use of KOVAE.

To improve the performance of the online analytical processing (OLAP) scenario, MySQL provides a reserved API for the secondary engine. KOVAE is a lightweight implementation of the secondary engine, and it presents itself as a MySQL plugin.

Providing features of the secondary engine, KOVAE as a plugin has the following advantages:

• Free of intrusive modification on the MySQL source code;
• Hot-installable or hot-uninstallable as a plugin without restarting or interrupting services;
• Offloading suitable SQL statement to the secondary engine for execution, significantly shortening the execution time of the SQL statement through parallel execution;
• KAEzip in Kunpeng Acceleration Engine (KAE) is utilized by the drive flushing operator to compress flushing files, saving drive space;

The parallel acceleration technology provided by KOVAE improves the query performance of OLAP by over three times.