MariaDB 10.x and Kea
  • Updated on 31 Jan 2019
  • 1 minute to read
  • Contributors
  • Print
  • Share
  • Dark
    Light

MariaDB 10.x and Kea

  • Print
  • Share
  • Dark
    Light

A Kea user reported a problem with using the MariaDB with Kea.

After preparing mysql and running:
$ mysql -N -B --user=keatest --password=keatest keatest < /home/vagrant/kea-src/kea-1.5.0/src/share/database/scripts/mysql/dhcpdb_create.mysql

I get the following error:
ERROR 1071 (42000) at line 805: Specified key was too long; max key length is 767 bytes
(This problem was reported with Database: Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6
System: Debian 9)

We were able to reproduce this problem at ISC, and it appears to be an issue specific to the MariaDB and 10.x versions.

The following MariaDB configuration appears to fix the problem:

sudo mysql -u root
use keatest;

set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
set global innodb_file_per_table=true;
set global innodb_default_row_format=dynamic;
Was this article helpful?