By default, MariaDB uses the XtraDB storage engine in place of InnoDB because it contains improvements to InnoDB that are useful for all users. If we want to use the InnoDB storage engine for some reason, it is easy to do so.
Let's get started by following the ensuing steps:
Stop MariaDB by following the directions in the recipe we followed when installing MariaDB.
Open our
my.cnformy.inifile in a text editor such as Vim, Emacs, TextWrangler, or Notepad. On Windows, there is a helpful link under the MariaDB group that will automatically open themy.inifile in Notepad. On Linux, themy.cnffile is located at either/etc/mysql/my.cnfor/etc/my.cnfdepending on the Linux distribution we are using.Add the following lines of code to the
[mysqld]section of the system'smy.cnformy.inifile. If the section does not exist, add it.ignore_builtin_innodb plugin_load=innodb=ha_innodb.so
Save the file and then start MariaDB by following the instructions in the recipe we followed when installing MariaDB.
To check if we are using InnoDB or XtraDB, we use the SHOW ENGINES command. If we are using XtraDB, the InnoDB line of the output will begin as shown in the following command line:
| InnoDB | DEFAULT | Percona-XtraDB,Supports...
And, if we are using the InnoDB plugin, the InnoDB line will begin as shown in the following command line:
| InnoDB | DEFAULT | Supports...
Only one of the storage engines can be loaded at one time. It is not possible to have both the InnoDB and XtraDB plugins loaded at the same time.
Refer to another InnoDB- and XtraDB-specific recipe, Using extended keys with InnoDB and XtraDB, in Chapter 3, Optimizing and Tuning MariaDB
The InnoDB and XtraDB section of the MariaDB Knowledgebase has lots of great information on these storage engines, which is available at https://mariadb.com/kb/en/xtradb-and-innodb/