Install MariaDB Archive Engine

3
votes

I have installed MariaDB on my Debian but Archive Engine is missing. Is there any way how to install Archive Engine?

I haven't file ha_archive in my /usr/lib/mysql/plugin directory

2
mysqllinuxdebianmariadb
What is the error message when you create an table with archive engine this way: CREATE TABLE IF NOT EXISTS archive (id int(11) NOT NULL, content text COLLATE utf8_bin NOT NULL) ENGINE=ARCHIVE; – Julian Ladisch
Warning (Code 1286): Unknown storage engine 'ARCHIVE' – Pavel
I've created a ticket for this issue: mariadb.atlassian.net/browse/MDEV-7151 – Julian Ladisch

2 Answers

6
votes

Try to install plugin using SQL shell.

MariaDB> INSTALL PLUGIN archive SONAME 'ha_archive.so';

Show Plugins

MariaDB> show engines \G

EDIT:

I have installed mariadb-10.x on ubuntu and ARCHIVE is by default enabled.

MariaDB> show engines \G

*************************** 7. row ***************************
      Engine: ARCHIVE
     Support: YES
     Comment: Archive storage engine
Transactions: NO
          XA: NO
  Savepoints: NO
1
votes

I fixed this by entering the following command in MariaDB by logging as a root user -

MariaDB [(none)]> INSTALL SONAME 'ha_archive';
Query OK, 0 rows affected (0.33 sec)

Check if it is installed -

MariaDB [(none)]> SHOW ENGINES;
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                                                            | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |
| ARCHIVE            | YES     | Archive storage engine                                                                           | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)