Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+3 votes
737 views
in Q2A Core by
I'm planning to use Q&A app, but i just want to make sure that this App was tested or tried in MariaDb not just only in MySQL
Q2A version: Latest

2 Answers

+3 votes
by
No, it has not been specifically tested in MariaDb. But MariaDb is a drop-in replacement for MySQL so it should work without any problems out of the box.

Try setting it up on localhost and let me know if you run into any problems.
+2 votes
by
I checked Q2A v1.7.4 with Mariadb(version 10.1.21-MariaDB) and it works fine. Installed fresh q2a using mariadb and also tried with old mysql db upgraded to mariadb, both qa worked fine. No issues seen.

I upgraded mysql 5.1 to 10.1.21-MariaDB.
by
Good work.
Did you compare database performance with QA_DEBUG_PERFORMANCE option in qa-config.php? If possible, please let us know the result. Especially, I want to know the reading time of qa-option table and performance of "SHOW tables" query. This is because these two processes greatly affect the performance of the system.
by
@sama55, performance is not measured, just tested for compatibility. Performance depends on many factor so not decided to check but it should be better or equivalent to  MySql. Mariadb is forked from MySql and started development.

Here are some perfomance figs.
https://www.softizy.com/blog/mariadb-10-1-mysql-5-7-performances-ibm-power-8/
https://mariadb.org/maria-10-1-mysql-5-7-commodity-hardware/

Wikipedia decided to go with MariaDB for all their sites, they must have done enough evaluation before switching.
https://blog.wikimedia.org/2013/04/22/wikipedia-adopts-mariadb/

MySql is now controlled by Oracle, they already started charging for MySql premium features. Also they slowed MySql development for free version.
by
Thanks  ProThoughts. This is my impression.
1. Basic performance is almost same.
2. "Thread pool" performance of MariaDB is very good.
3. Dedicated server users will run faster with MariaDB.
4. Shared server users may not be able to use MariaDB... <= Um...
by
@sama55, agree with you.
by
Appreciable initiative.... Keep up the good work.
by
@QuestionReply, thanks!
...