[ postfixadmin-Feature Requests-3488194 ] Official support for MariaDB

[SourceForge.net <no...@so...>]

Feature Requests item #3488194, was opened at 2012-02-16 04:31
Message generated for change (Comment added) made by alex-j
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=3488194&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Charles (libertytrek)
Assigned to: Nobody/Anonymous (nobody)
Summary: Official support for MariaDB

Initial Comment:
Hola,

I've been seriously questioning my continued use of MySQL ever since Oracle bought Sun, and even more so recently. I'd really like to switch to MariaDB (seems to be the best one of the forks, and the closest to a drop-in replacement)... however, since postfixadmin is my main use of mysql, I'd rather not do this unless/until postfixadmin offically adds support for it.

Are there any existing plans/efforts to do this? From what I've read about MariaDB, it is virtually a drop in replacement for MySQL, so I was hoping it wouldn't be too difficult to add official support for it, then maybe after a certain period, just drop official support for MySQL - unless of course the devs are ok with maintaining them both until such time as they diverge to the point that maintaining them both becomes too much work.

Regardless, many thanks to all who make postfixadmin the best way to maintain a mail server!

----------------------------------------------------------------------

Comment By: Alexander (alex-j)
Date: 2012-03-03 21:33

Message:
I don't think that need to be done something with postfixadmin to be able
to work with MariaDB. It's practically drop in replacement. Nothing should
be changed in PHP scripts.
PostfixAdmins table is pretty simple and don't use anything
special(triggers, procedure...) as far as I know.
We already replaced a few DB servers to MariaDB without any issues and get
better performance with it.
Here is an information about compatibility:
http://kb.askmonty.org/en/mariadb-versus-mysql

BTW, It would be good to switch to PDO in PHP instead of direct call of
mysql's functions.
In this case it will be possible to use different Database engines without 
touching actual logic.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=3488194&group_id=191583