Support

Admin Tools

#25914 Do you support mariaDB

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Saturday, 17 September 2016 17:20 CDT

mshihan
 Hello

I am planning to move my Joomla website to a new web host which supports mariaDB officially. Does Admin Tools officially support mariaDB.?

nicholas
Akeeba Staff
Manager
While we do support MariaDB (it's almost the same as MySQL) please note that you will have a few issues with Joomla! and all of its extensions:
  • You must NOT use the Aria or XtraDB database engines. They have subtle differences to MyISAM and and InnoDB which will cause issues with Joomla! and its extensions. Based on our experience, we recommend setting the MyISAM engine as the default (talk to your host about it). Never convert MyISAM tables to Aria or XtraDB, you'll break Joomla!.
  • Joomla! 3.5 and later support the multibyte Unicode encoding UTF8MB4. While it's being presented as a gimmick which enables you to use Emojis it is, in fact, a MAJOR security enhancement. Had it been implemented a year ago when I first discussed this with the Joomla! maintainers the last zero day attack on Joomla! in December 2015 would have been averted. To the best of my knowledge MariaDB does NOT support this encoding or at least Joomla! on MariaDB doesn't. Therefore using MariaDB may expose you to a class of Unicode attacks which cannot be mitigated in any other way (including through Admin Tools). Also note that even though Admin Tools does offer a feature to convert your site to UTF8MB4 it will not work on MariaDB (it only works on MySQL).


Further to that some of the MySQL-only features in Admin Tools (Repair & Optimize, optimize session table, change collation) may not work on MariaDB. It depends on the database engine used by each table. We've tested MyISAM and InnoDB on MariaDB because these are the only database storage engines supported by Joomla!. These two engines DO work just fine with Admin Tools, Akeeba Backup and all of our other extensions.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

mshihan
Hi Nicholas

Thank you so much for your clear and helpful explanation.

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!