MySQL vs MariaDB

[Gauravk]

I'm running a dedicated server of CentOS with cPanel and have MySQL 5.6 working perfectly for 1 year or so.

I got a message from cpanel to upgrade 5.6 to 5.7 while upgrading I got an option to upgrade to MariaDB 10.0, 10.1, 10.2, 10.3 (recommended)

Can I upgrade MySQL 5.6 to MariaDB 10.3?

If I upgrade MySQL 5.6 to MariaDB 10.3 is there any issue with IPB database, as on this server I only have 1 IPB site?

If no issue, then any performance gains are there to switch to MariaDB or shall I just stick to 5.7 and move on?

P.S. My IPB database has a majority of the table of MyISAM and 10% InnoDB is there any format conversion required if I switch to MariaDB?

[RevengeFNF]

You can upgrade to MariaDB 10.3, im currently using that version with no issues.

MariaDB supports MyISAM because its a MySQL drop in replacement, but i highly suggest you to convert all your tables to InnoDB.

[Gauravk]

Thanks for your advice, can you please explain why to convert all tables to InnoDB as I rem roughly that in past we had some slow issue with InnoDB and someone advice to switch to MyISAM. 

[RevengeFNF]

7 minutes ago, Gauravk said:

Thanks for your advice, can you please explain why to convert all tables to InnoDB as I rem roughly that in past we had some slow issue with InnoDB and someone advice to switch to MyISAM. 

Currently, InnoDB is faster and more secure against crash's.

[bfarber]

I would definitely recommend InnoDB over MyISAM with recent MySQL releases. Note that you may have to adjust your my.cnf configuration file if you do make the switch to get the most out of your database, but overall InnoDB will perform better and more reliably than MyISAM.

[ASTRAPI]

InnoDB has row-level locking, MyISAM can only do full table-level locking.

InnoDB has better crash recovery.

[Gauravk]

Thanks, @bfarber and @ASTRAPI do you both recommend to stick to MySQL than MariaDB.....?

Either way when I upgrade, Ill switch to InnoDB as advised by all of you.

[ASTRAPI]

I prefer MariaDB 🙂

[bfarber]

3 hours ago, Gauravk said:

Thanks, @bfarber and @ASTRAPI do you both recommend to stick to MySQL than MariaDB.....?

Either way when I upgrade, Ill switch to InnoDB as advised by all of you.

I don't have any specific recommendation no.

[AlexWebsites]

Is there anything that needs to be done on IPS side if switching to InnoDB? Any settings changed or is this as easy as just converting and upgrading server side?

[AtariAge]

I've been using Percona Server on my site for about a year and converted everything to InnoDB.  I'm still running 3.4.x, but will be migrating soon to 4.x (hopefully 4.4!) 

[ASTRAPI]

@AlexWebsites

Nothing needed on IPB as it is server side change....

[bfarber]

On 2/8/2019 at 4:12 PM, AlexWebsites said:

Is there anything that needs to be done on IPS side if switching to InnoDB? Any settings changed or is this as easy as just converting and upgrading server side?

You will want to review your MySQL configuration while switching the tables. The settings that make MyISAM run most optimally will be irrelevant for InnoDB database tables (and vice-versa).

[ASTRAPI]

Yes a new optimization of your database is a must after converting your tables to Innodb....

[AlexJ]

On 2/11/2019 at 10:41 AM, ASTRAPI said:

Yes a new optimization of your database is a must after converting your tables to Innodb....

Doesn't it take super long time when you do optimization on InnoDB? Does InnoDB really need optimization?

[ASTRAPI]

Optimization of the settings related to Innodb at my.cnf file 🙂