Jump to content

MySQL vs MariaDB


Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...