Jump to content

Community

PedroNL

Move from MySQL to MariaDB

Recommended Posts

14 minutes ago, RevengeFNF said:

Not even 10.0 is needed to run ips ;)

I know, I was just trying yo keep up with the latest releases to be on safe side. I know that MySQL 5.6.35 has an end-of-life for 2018 and that day would come soon.

While upgrading I read that ( see screen shot above ) 10.0 was recommended and 10.1 was stable release. Do you really advice the upgrade ? Do you think it is worth ?

Share this post


Link to post
Share on other sites
7 minutes ago, ABGenc said:

I know, I was just trying yo keep up with the latest releases to be on safe side. I know that MySQL 5.6.35 has an end-of-life for 2018 and that day would come soon.

While upgrading I read that ( see screen shot above ) 10.0 was recommended and 10.1 was stable release. Do you really advice the upgrade ? Do you think it is worth ?

I like to use the last stable version.

You can check here the main diferences: https://mariadb.com/kb/en/mariadb/what-is-mariadb-101/

Share this post


Link to post
Share on other sites
17 minutes ago, RevengeFNF said:

I like to use the last stable version.

You can check here the main diferences: https://mariadb.com/kb/en/mariadb/what-is-mariadb-101/

The next step I am considering it to switch MyISAM tables to InnoDB. I am planning to convert my test site's DB first to see how it goes. Do you think I can test the real performance difference between MyISAM and InnoDB on a test site so that it gives me an idea for production ?

Share this post


Link to post
Share on other sites
11 minutes ago, ABGenc said:

The next step I am considering it to switch MyISAM tables to InnoDB. I am planning to convert my test site's DB first to see how it goes. Do you think I can test the real performance difference between MyISAM and InnoDB on a test site so that it gives me an idea for production ?

You would need to generate the same traffic to have a 100% exact idea how it would work. 

But convert it, it will be better and safer.

Edited by RevengeFNF

Share this post


Link to post
Share on other sites
6 hours ago, RevengeFNF said:

You would need to generate the same traffic to have a 100% exact idea how it would work. 

But convert it, it will be better and safer.

%95 done but still a problem ;

 

Share this post


Link to post
Share on other sites
On 11/17/2016 at 9:36 AM, Rhett said:

MariahDB Has been the default DB for Centos7, it's a drop in replacement for mysql, recommended, and works great. What questions do you have? 

 

Just want to know if it is officially supported?

Share this post


Link to post
Share on other sites
On 2016-11-18 at 2:36 AM, Rhett said:

MariahDB Has been the default DB for Centos7,

Strange...when I upgraded my VPS from CentOS 6 to CentOS 7 I was still running mySQL.

Either way...I completed my upgrade from mySQL 5.6.35 to MariaDB 10.1 just this morning.  Works flawlessly. :)

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...