[SOLVED] How to use XtraDB and TokuDB in Percona?

How to use XtraDB and TokuDB in Percona?

After trying several times, I finally installed Percona on my Macbook using Homebrew and successfully connected to it via MySQL Workbench, but when I want to create XtraDB tables:

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `TestSchema`.`TestTable` (
  `ID` BIGINT(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`))
ENGINE = XtraDB;

ERROR 1286: Unknown storage engine 'XtraDB'
SQL Statement:
CREATE TABLE `TestSchema`.`TestTable` (
  `ID` BIGINT(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID`))
ENGINE = XtraDB

Same error with TokuDB too.

I have read that Percona supports both XtraDB and TokuDB as well as InnoDB. Should I activate theme somewhere?!

Solution

Within Percona Server, XtraDB is InnoDB. In other words, 'CREATE TABLE ... ENGINE=INNODB' will create you an XtraDB table.

TokuDB is not at all supported on homebrew/Mac/OS/X in any way and likely will not even compile.

In a regular distro of Percona Server 5.6/5.7, you need to follow these directions for the proper pre-requisites and the procedure for enabling the storage engine : https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_installation.html

-- George O. Lorch III Software Engineer, Percona