MariaDB and IPB 4 Pro and Cons over MySQL

[Gill]

 

Hi Guys I am trying to install IPB 4 using runcloud.io  

it comes with MariaDB 1:10.2.16+maria~bionic and no support for mysql .

I am just wondering what will be cons of using MariaDB over Mysql ? Becuase i guess IPB team is alos using mysql instead of MariaDB ? will IPB 4.3.4 works fine with MariaDB 10.2.16 ?

or i will facing  issues with IPB 4.3.4 and its plugins with mariaDB 

Anybody switch database from mysql to MariaDB what kind of pro and cons he/she faced please share your experience.

Any performance  and optimization tips or tricks  for using MariaDB with IPB 4

I would be highly thankful to you for help :)

Thanks

 

 

[LiquidFractal]

I can't say anything about your specific setup (don't know what "bionic" is), but I am currently using IPB 4.,3.4 with MariaDB 10.2.16 and have had no problems whatsoever.  On the advice from some people here in the know, I converted to MariaDB from mySQL as MariaDB is a better developed fork (and if I remember correctly Oracle bought mySQL, so some are wondering about its future).

Again, there are others here who know much more than I do, but the only thing I had to do was convert all my tables to InnoDB, which is a more secure and reliable format.  Your DB will grow in size, but for many here it's worth the tradeoff.

So no, no problems with MariaDB so far as I've ever seen (and I have lots of third-party apps and plugins).

[Gill]

@ASTRAPI Hi :) Could you please Give some Expert advice or TIPS ?

You are BEST server management service Guy, who is respected by whole community members, Please :) 

I would be highly thankful to you for This help :)

[RevengeFNF]

MariaDB is a drop in replacement for MySQL. You won't find any issue whatsoever. 

[Xenboy]

I use MariaDB 10.2 myself and can confirm it works without any issues.

[ASTRAPI]

https://mariadb.com/kb/en/library/mariadb-vs-mysql-features/

https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql

 

[rhyker2u]

On 6/28/2018 at 4:31 AM, liquidfractal said:

I can't say anything about your specific setup (don't know what "bionic" is),

Bionic is short for " bionic beaver" = Ubuntu 18.04LTS release. https://downloads.mariadb.org/mariadb/repositories/

[Mark]

We have, very occasionally, seen issues with MariaDB, but it only seems to effect a very small percentage of communities. I would recommend MySQL if it's available, but if not, you should be fine.