Switching between InnoDB and XtraDB

Switching between InnoDB and XtraDB

MariaDB 5.5 comes with both XtraDB (compiled in) and InnoDB (as a plugin). By default MariaDB 5.5 uses XtraDB. If you want to switch to use InnoDB you can do:

mysqld --ignore-builtin-innodb --plugin-load=innodb=ha_innodb.so \
--plugin_dir=/usr/local/mysql/lib/mysql/plugin

(plugin_dir should point to where ha_innodb.so is installed)

The above options can of course also be added to your my.cnf file:

[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb.so
plugin_dir=/usr/local/mysql/lib/mysql/plugin

If you want you can also compile MariaDB with InnoDB as default.

Tags
mariadb