I’m always switching back-and-forth between the 2 different
InnoDB flavors in MariaDB – XtraDB+ and the standard InnoDB
plugin, so I thought I’d simply post all of the various
combinations in a single place. (And then I cover enabling the
InnoDB Plugin in MySQL, since it’s an option in 5.1.)
[Addition: Thanks to Andrew and Sergei for the tips on
shortening plugin-load=. The changes are reflected below.]

Note: Below is for Windows. For Linux, simply change
“.dll” to “.so” where appropriate.

MariaDB 10.0:

Do not add anything, as the standard InnoDB plugin is the current
default (as of 10.0.3, although I do anticipate this changing in
the near future, and I’ll update the post accordingly when that
happens).

As I mentioned here, there is a slight change for enabling
the [original] InnoDB Plugin in MariaDB 5.5 (as compared to how
you would enable it in 5.1).

Remember, in MariaDB 5.5, if you do not “enable” (i.e., add
anything to the config file to do so) the InnoDB Plugin in
MariaDB 5.5, you’ll end up with XtraDB+ for your InnoDb plugin.
However, if you do “enable” the InnoDB plugin, then you end up
with the original InnoDB plugin provided by Oracle/InnoDB.

The change is that the plugin file (.dll for Windows, .so file
for Linux) which was previously named “ha_innodb_plugin.dll” is
now just “ha_innodb.dll”.

Thus, if you previously enabled the plugin with (would have been
in a 5.1 instance):

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.