Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

MariaDB - Will limesurvey work on MariaDB?

  • spessex
  • spessex's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 11 months ago #95044 by spessex
Hi

Does anyone know if Lime Survey will work with MariaDB as opposed to MySQL?

Additionally, if it does work can existing LS MySQL databases be moved across to MariaDB without issue?

Any advice would be greatly appreciated.

Thank you

Stephen
The topic has been locked.
More
9 years 4 months ago #113818 by pure
Hi Stephen,

have you tried to use Limesurvey with MariaDB, was there any trouble?
As nobody answered before, it would be helpfull, if you could drop a short line...

Thank you!
The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
9 years 4 months ago #113823 by c_schmitz
Replied by c_schmitz on topic MariaDB - Will limesurvey work on MariaDB?
As MariaDB is fully MySQL compatible it should not be a problem - if you happen to stumble on anything just let us know.

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.
More
7 years 10 months ago #136272 by dspaan
Replied by dspaan on topic MariaDB - Will limesurvey work on MariaDB?
Just reporting back that i just succesfully uninstalled MySQL and installed MariaDB 5.5 on an OpenSUSE server and Limesurvey is running fine on version 2.50+ (160512).
The following user(s) said Thank You: holch, Ben_V
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
7 years 10 months ago #136357 by Mazi

dspaan wrote: Just reporting back that i just succesfully uninstalled MySQL and installed MariaDB 5.5 on an OpenSUSE server and Limesurvey is running fine on version 2.50+ (160512).

What's the benefit of running Maria DB instead of MySQL?

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
More
7 years 10 months ago #136362 by dspaan
Replied by dspaan on topic MariaDB - Will limesurvey work on MariaDB?
Well i'm running Limesurvey on a ViCidial server and it had MySQL 5.2 but the requirement for updating Limesurvey is 5.5 so i upgraded to that MySQL version but then i verified with the main developer of Vicidial and he said this:

We do NOT recommend running MySQL 5.5 or higher. We instead recommend switching to a comparable MariaDB version, like most Linux distros have done in the last 2 years. Unfortunately, MySQL 5.5 removed a lot of legacy code that helped it to run better, That code is still in MariaDB, which is a drop-in replacement for MySQL.

The topic has been locked.
More
5 years 5 months ago #174976 by bruce78
Replied by bruce78 on topic MariaDB - Will limesurvey work on MariaDB?
Does anyone else have any more experience or news of running MariaDB instead of MySQL? I'm thinking of switching to Debian 9 which runs version 10.1.26-0 so I thought I'd ask if anyone has any stories they can share?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 5 months ago #174995 by DenisChenu
Replied by DenisChenu on topic MariaDB - Will limesurvey work on MariaDB?
No issue with mariaDB, because mariaDB is done to be fully compatible with mysql …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: bruce78
The topic has been locked.
More
5 years 5 months ago #174999 by bruce78
Replied by bruce78 on topic MariaDB - Will limesurvey work on MariaDB?
Cool, there's even a page where Maria talk about this...

mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose