# Community to Percona exact same version still mysql\_upgrade? or not.

**URL:** <https://forums.percona.com/t/community-to-percona-exact-same-version-still-mysql-upgrade-or-not/1978>\
**Category:** Other MySQL® Questions\
**Created:** [January 25, 2013, 3:35am UTC](https://forums.percona.com/t/community-to-percona-exact-same-version-still-mysql-upgrade-or-not/1978 "2013-01-25T03:35:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcubedpe](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@mcubedpe](https://forums.percona.com/u/mcubedpe)\
**Post date:** [January 25, 2013, 3:35am UTC](https://forums.percona.com/t/community-to-percona-exact-same-version-still-mysql-upgrade-or-not/1978/1 "2013-01-25T03:35:34Z")

</div>

Hello everyone,

Simple question yet I’ve been unable to find anything really solid as an answer.

Short background - I have several Production boxes running RHEL 5.8; the VAR I was using provided me a custom compiled version of MySQL 5.1.49 ( but still packaged as RPMs )… which kept crashing under heavy load ( ~3k QPS ) ( and bit of time on google implied I hit a known bug that needed a newer MySQL 5.1.x ) - yet my VAR for months now has not been able to deliver…

SO…

I gave up on the VAR; downloaded the RPMs for MySQL Community 5.1.66. Shutdown MySQL 5.1.49 - did the old - rpm -Uvh - thing… ( as I verified all file/directories between Custom 5.1.49 and Community 5.1.66 matched ) - i.e. I used Community 5.1.66 to overwrite all existing binaries.

Restarted MySQL now 5.1.66 - ran mysql\_upgrade… and voila - all was good…

SORTA…

No more crashes… But now it seems like I have a “bursty” system ( fast… slow… fast… slow… etc, VERY ANNOYING )… so I want off this Community thing - and onto Percona.

So here’s the question.

I downloaded the RPMs for Percona 5.1.66.

I’m currently on MySQL Community 5.1.66.

Can I just shutdown Community 5.1.66 - do the rpm -Uvh - onto Percona 5.1.66 - and restart MySQL - and I’m good?

Or… do I need to run - mysql\_upgrade? As I am staying on the exact same version of MySQL. In this case 5.1.66.

And now that I’m thinking about it…

I have a mix of MyISAM, Memory, and InnoDB tables.

DO I need to do anything interesting to make these work with Percona Server 5.1.66? I keep seeing that Percona uses XtraDB that is an advanced version of Innodb? SO… do I need to alter the existing Innodb tables to use - XtraDB engine instead?

Or does Percona Server - just know that when someone wants the InnoDB Engine - it just internally uses the XtraDB engine instead?

Thoughts?

Thanks in advance for any help you can provide.

-Michael

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [January 25, 2013, 10:39am UTC](https://forums.percona.com/t/community-to-percona-exact-same-version-still-mysql-upgrade-or-not/1978/2 "2013-01-25T10:39:33Z")

</div>

Mysqld\_upgrade or alter table is not necessary; it will use XtraDB right away on your InnoDB tables. You can always go back to vanilla MySQL as long as you don’t use any of the features mentioned in [http://www.percona.com/doc/percona-server/5.5/compatibility](http://www.percona.com/doc/percona-server/5.5/compatibility). html

---

<div class="post-metadata">

**Author:** ![mcubedpe](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@mcubedpe](https://forums.percona.com/u/mcubedpe)\
**Post date:** [January 25, 2013, 3:02pm UTC](https://forums.percona.com/t/community-to-percona-exact-same-version-still-mysql-upgrade-or-not/1978/3 "2013-01-25T15:02:47Z")

</div>

Thanks for the quick response, and great info.

I’ve moved my other question about RHEL or CentOS rpm upgrade process moved to it’s own thread:

“RHEL or CentOS - upgrade process community to percona or…”

-Michael
