[TUTORIAL] Upgrading mysql 5.1 to 5.4 + phpmyadmin CENTOS 6.4

[Isleno]

Hi, after 10 times rebuilding my VPS with CentOS 6/7 I finally get my upgrade.

System: CentOs 6.4
Sentora: Beta 1.0.0
Mysql: 5.1 (from sentora)
Phpmyadmin (from sentora)

Now follow the steps:

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo
yum --enablerepo=remi update mysql-server
mysql_update -u root -p

Congratulations, your mysql has been upgraded.

cd /etc/zpanel/panel/etc/apps
mv phpmyadmin phpmyadmin_old
mkdir phpmyadmin

Now download the phpmyadmin 4.1.7 (or your choice) to your desktop
Login into WinSCP and access /etc/zpanel/panel/etc/apps/phpmyadmin then upload all files
Copy the config.inc file from phpmyadmin_old to phpmyadmin folder and delete the old folder.

Congratulations, your phpmyadmin has been upgraded.

[ugcoder]

I have a better solution. I am using MariaDB latest version with TokuDB and getting better performance than mysql. I will sugggest you to use MariaDB.

[Me.B]

TokuDB does not support foreign keys and is not compatible 100% with innoDB. So it's quitly different here as a choice.

Would be an issue for a lot of CMS. Also tokuDB require at least 50% of ram for cache ( in GB if available).

Require mySQL 5.5 ( not available in centos 6.x branch!)

http://www.slideshare.net/tmcallaghan/ge...ith-tokudb

http://unix.stackexchange.com/questions/...-to-tokudb

http://www.percona.com/blog/2013/05/07/b...vs-innodb/

Also for MySQL updrade beware using REMI repos will cause a lot of dependencies conflict that would be hard to resolve!

M B

[ugcoder]

TokuDB does not support foreign keys and is not compatible 100% with innoDB. So it's quitly different here as a choice.

Would be an issue for a lot of CMS. Also tokuDB require at least 50% of ram for cache ( in GB if available).

Require mySQL 5.5 ( not available in centos 6.x branch!)

http://www.slideshare.net/tmcallaghan/ge...ith-tokudb

http://unix.stackexchange.com/questions/...-to-tokudb

http://www.percona.com/blog/2013/05/07/b...vs-innodb/

Also for MySQL updrade beware using REMI repos will cause a lot of dependencies conflict that would be hard to resolve!

M B

Yah, I know that. But I am using Wordpress on my server and I am really happy with it. But 50% usage really a bad issue I am feeling. Let's see how can I develop it.