Founder and Lead Developer of Macrotone Consulting Ltd.
2 minutes reading time (334 words)

MariaDB and Joomla ?

MariaDBWe were looking at the possibilities of upgrading the version of MySQL we are using on out NAS system and were reminded of the existence of the MariaDB database as a possible alternative. Alternative because our NAS does not easily permit the upgrade of the MYSQL part of the system mainly because it is so tightly tied into the other features.

What is MariaDB one might ask. Well there is probably no better explanation that that upon the MariaDB web site.

 

“For all practical purposes, MariaDB is a binary drop in replacement of the same MySQL version (for example MySQL 5.1 -> MariaDB 5.1, MariaDB 5.2 & MariaDB 5.3 are compatible. MySQL 5.5 will be compatible with MariaDB 5.5). What this means is that:

  • Data and table definition files (.frm) files are binary compatible.
  • All client APIs, protocols and structs are identical.
  • All filenames, binaries, paths, ports, sockets, and etc... should be the same.
  • All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
  • The mysql-client package also works with MariaDB server.
  • The shared client library is binary compatible with MySQL's client library. “

This means  that as far as Joomla is concerned we should be OK to go as far as compatibility is concerned.  The next question is of course can we install it upon our NAS? This is not quite so clear cut, currently. Some NAS system such as Synology certainly support it.  Unfortunately our QNAP system does not currently, although we are unsure whether this is something that might coming in the future or not.

One to watch and perhaps it might be worth running up a test system to check out MariaDB, which it is claimed, is faster than MySQL. Another thing to consider is whether our Web Host might support it, which is a further step.

Mail ISO-8859-2 character sets
Handling Googlebot URL detected errors.
 

By accepting you will be accessing a service provided by a third-party external to https://macrotoneconsulting.co.uk/

Go To Top

The Macrotone Consulting Web site would like to use cookies to store information on your computer, to improve our website. Cookies used for the essential operation of the site have already been set. To find out more about the cookies we use and how to delete them, see our Privacy Policy.

I accept cookies from this site.