Can I switch to MariaDB with vb3.8?

[Alfa1]

Is vbulletin 3.8 compatible with MariaDB 10?
Will I run into any problems if I switch from MySQL 5.5 to MariaDB 10?

[Dave]

I'm using MariaDB on my vBulletin 4 installation and it works perfectly fine. MariaDB is basically just a MySQL fork. The functionality is exactly the same as MariaDB, you just keep using the same MySQL extension.

[Alfa1]

I am currently using mysql 5.5. So this means I should use mysql 5.5 + mariaDB 10? Or is there a minimum version for mariadb?

[Dave]

Originally Posted by Alfa1

I am currently using mysql 5.5. So this means I should use mysql 5.5 + mariaDB 10? Or is there a minimum version for mariadb?

The difference between MariaDB 10 and 5.5 is that MariaDB 10 has new unique features and contains features ported over from MySQL 5.6. I don't think it matters if you use MariaDB 10 or 5.5, I would just use 5.5 though.

[Alfa1]

If vbulletin 3.8 is compatible with mysql 5.6 then I will just use mariadb 10.
But I have no clue if vb 3.8 is compatible with mysql 5.6
Does anyone know?

[Dave]

Originally Posted by Alfa1

If vbulletin 3.8 is compatible with mysql 5.6 then I will just use mariadb 10.
But I have no clue if vb 3.8 is compatible with mysql 5.6
Does anyone know?

According to vBulletin.com:

Originally Posted by vBulletin.com

vBulletin 3.8.0 requires at least PHP 4.3.3 and MySQL 4.0.16 (These are the same requirements as vBulletin 3.7), but we strongly recommend that all customers run PHP 5.2.8 with APC and MySQL 5.1.30 or later.

You can always give it a shot, it shouldn't be too hard to downgrade in case it does not work.

[Alfa1]

You have a point there. I asked vb staff some time ago but they did not respond.

[vbresults]

I'm running the latest MariaDB 5.5 on vB 3.8 without any issues.

[Alfa1]

Do you use 3.8.8 or 3.8.7?

[Paul M]

As far as I remember, there are no query differences between 3.8.7 & 3.8.8.

(but its over a year since i did most of the changes, so I may have forgotton something).