[RFC] Support for MariaDB

These requests for comments/change have lead to an implemented feature that has been successfully merged into the 3.1/Ascraeus branch. Everything listed in this forum will be available in phpBB 3.1.
User avatar
Ger
Registered User
Posts: 270
Joined: Mon Jul 26, 2010 1:55 pm
Location: 192.168.1.100
Contact:

[RFC] Support for MariaDB

Post by Ger » Thu May 02, 2013 9:50 am

As per https://area51.phpbb.com/phpBB/viewtopi ... 63#p253363 support for MariaDB would be nice.

Proposal
MariaDB is forked in 2010 from MySQL when Sun sold that to Oracle. At this point it's pretty much the same as MySQL, therefore phpBB will probably work on MariaDB (I can't test this on my though since I have no MariaDB).
However: I guess that MariaDB will probably gradually move away from MySQL. Therefore real support for MariaDB would be nice for those who want to switch from Mysql to MariaDB.
Adaption should be easy now:
EXreaction wrote:From the sounds of that article, MariaDB should work fine and you can probably even use the phpBB MySQL driver as it is to connect to a MariaDB database without issues.
I guess that when MariaDB does move away from MySQL, there should be an extension to the mysql class or perhaps an own class.

Pros
  • Support for wider range of DB drivers
  • It's easier to adapt now than over a few years I guess
Cons
  • More work for devs since they have to consider yet another DB driver when making changes

PS: this is not really in my intereset since I can't even use MariaDB, but since it was mentioned in above topic I thought I'd take the effort to make it an RFC. :)
Above message may contain errors in grammar, spelling or wrongly chosen words. This is because I'm not a native speaker. My apologies in advance.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC] Support for MariaDB

Post by bantu » Thu May 02, 2013 10:32 am

I don't think discussing this makes much sense as long as
- MariaDB is still pretty much compatible with MySQL
- there is no explicit MariaDB support in PHP
- our MySQL DB driver works just fine with MariaDB

Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

Re: [RFC] Support for MariaDB

Post by Oleg » Thu May 02, 2013 4:00 pm

Mariadb support simply needs testing.

User avatar
MichaelC
Development Team
Development Team
Posts: 889
Joined: Thu Jan 28, 2010 6:29 pm

Re: [RFC] Support for MariaDB

Post by MichaelC » Fri May 03, 2013 3:30 pm

Oleg wrote:Mariadb support simply needs testing.
+1
Formerly known as Unknown Bliss
psoTFX wrote: I went with Olympus because as I said to the teams ... "It's been one hell of a hill to climb"
No unsolicited PMs please except for quotes.

User avatar
Dragosvr92
Registered User
Posts: 624
Joined: Tue May 31, 2011 12:08 pm
Location: Romania
Contact:

Re: [RFC] Support for MariaDB

Post by Dragosvr92 » Sun May 05, 2013 11:51 am

It sounds like mariadb was created by a very passionate religious person.

This text is their website headline; "MariaDB: An enhanced, drop-in replacement for MySQL."
They based their software on mysql and they want to kill/replace it ? Im not sure if its better than mysql as i dont know much about databases, but it doesnt seem to be used/known by many persons, so it can wait, till they move to whatever they move and then look better into it.
If you make it work for phpbb and in a few months they upgrade it, you lost the time to support it for nothing..
Previous user: TheKiller
Avatar on Memberlist 1.0.3

User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

Re: [RFC] Support for MariaDB

Post by EXreaction » Sun May 05, 2013 3:13 pm

Its lead developer is Michael "Monty" Widenius, the founder of MySQL and Monty Program AB. He had previously sold his company, MySQL AB, to Sun Microsystems for 1 billion USD.
http://en.wikipedia.org/wiki/MariaDB


From the looks of things, I do not think we will be required to do anything for MariaDB support. MariaDB is maintaining complete compatibility with MySQL, which is likely to be known by anyone who wants to use MariaDB, so they should know they can select MySQL as the backend and just enter the correct server address to access the database instead of MySQL.

If we wanted to, we could add it to the list of supported databases during the installation process and just make it use the mysql backend, but I don't know what the benefit is for us.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: [RFC] Support for MariaDB

Post by bantu » Mon May 06, 2013 12:47 pm

It would be nice to run tests using our MySQL driver on a MariaDB database. For Travis-CI see https://github.com/travis-ci/travis-ci/issues/1081


User avatar
keith10456
Registered User
Posts: 523
Joined: Sat Apr 22, 2006 10:29 pm
Contact:

Re: [RFC] Support for MariaDB

Post by keith10456 » Fri Sep 13, 2013 3:38 pm

Dragosvr92 wrote:It sounds like mariadb was created by a very passionate religious person.

This text is their website headline; "MariaDB: An enhanced, drop-in replacement for MySQL."
They based their software on mysql and they want to kill/replace it ? Im not sure if its better than mysql as i dont know much about databases, but it doesnt seem to be used/known by many persons, so it can wait, till they move to whatever they move and then look better into it.
If you make it work for phpbb and in a few months they upgrade it, you lost the time to support it for nothing..
Mariadb was created because Oracle now owns MySQL. So if Oracle decides to make an about face on how it supports MySQL and/or its rights of usage, the open-source community will have an alternative. Currently, it's not as good as MySQL but more and more people are supporting and contributing to the project. It will get there soon enough... That being said, I really hope that phpBB adds support for mariadb considering the goal of mariadb and that phpBB is open-source :)

+1 for the RFC.

User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

Re: [RFC] Support for MariaDB

Post by EXreaction » Fri Sep 13, 2013 5:31 pm

Since MariaDB is maintaining compatibility with MySQL, we should already support it/work perfectly on MariaDB without any changes required (just select MySQLi and connect to the MariaDB server).

Post Reply