Using Sphider with MariaDB in place of MySQL

Come here for help or to post comments on Sphider
Post Reply
User avatar
captquirk
Site Admin
Posts: 119
Joined: Sun Apr 09, 2017 8:49 pm
Location: Arizona, USA
Contact:

Using Sphider with MariaDB in place of MySQL

Post by captquirk » Sat Jul 08, 2017 8:54 pm

MariaDB is a fork of MySQL and is gaining popularity. Both the vanilla and PDO versions of Sphider should work seamlessly with MariaDB except as noted.

Until MariaDB 10.2, XtraDB was the default engine in place of InnoDB. In 10.2, InnoDB became the default. Sphider installation specifies InnoDB. If you have MariaDB 10.2, no change is required.

If you are using MariaDB 5.5 or later up to MariaDB 10.1, you have two choices. The first is to enable InnoDB by adding this block to your my.cnf file:
[mysqld]
ignore_builtin_innodb
plugin_load=ha_innodb.so
# The following should not be needed if you are using a mariadb package:
plugin_dir=/usr/local/mysql/lib/mysql/plugin


The second is to edit the install.php and update_rollup.php files and replace all instances of InnoDB with XtraDB.

The second scenario is appropriate for MariaDB 5.3 and earlier.
--------------------------------------------------
The above information was gleaned from the knowledge base at https://mariadb.com.

Post Reply