By user1805458

2014-10-17 16:27:04 8 Comments

I am planning my MySQL DB ver5.1.73 running on a CentOS 6.5 machine to MySQL 5.6.21.

I understand the basic procedure for this based on what I have read on StackOverflow, but I was curious if anyone has encountered any specific problems when they have gone the 5.1 to 5.6 route?

One that I have heard of is that certain TIMESTAMP columns might end up with incorrect timestamps. But I am curious if there are any other ones that people have heard of or run into.

To narrow down on the issues I am concerned about, I am only concerned of anything where there might be data loss or consistency issues

Thanks! IS


@RolandoMySQLDBA 2014-10-17 17:12:12

ISSUE #1 : Upgrade Path

Your grant tables can get screwed up because you are leaping two versions instead of one.

I just helped someone a week ago because they did just that (MySQL service stops after trying to grant privileges to a user). The solution for that question was to manually fix the mysql.user. Rather than going through that heavy-handed route, there are two ways go about this.

TECHNIQUE #1 : Upgrade the Politically Correct Way

TECHNIQUE #2 : Upgrade Directly from MySQL 5.1 to MySQL 5.6

I already described how to upgrade two versions


If you use FULLTEXT indexes before MySQL 5.6, those tables use the MyISAM Storage Engine. You need to convert those tables to InnoDB (See my post When to switch from MyISAM to InnoDB? under NEED #2). Then, separately tune the InnoDB FULLTEXT options (See my post MySQL FullText search on string shorter than 3 chars returns no rows).

ISSUE #3 : Security Issues

I am sure you are aware of this since you are going straight to MySQL 5.6.21

For the rest who do not know, as of October 16, 2014, Oracle just announced that there are security issues with MySQL 5.5 and MySQL 5.6. This was also announced at Amazon. Both MySQL 5.5.40 and MySQL 5.6.21 will have the security patches in places, so it is best to upgrade to one of these.

Related Questions

Sponsored Content

2 Answered Questions

[SOLVED] Set sql_mode “blank” after upgrading to MySQL 5.6

1 Answered Questions

1 Answered Questions

Reversion strategy when upgrading MySQL

  • 2018-06-25 14:34:42
  • m1s4mike
  • 54 View
  • 2 Score
  • 1 Answer
  • Tags:   mysql upgrade

2 Answered Questions

[SOLVED] Upgrading the mysql server from 5.1 to 5.6?

3 Answered Questions

[SOLVED] Question on having a MySQL 5.1 replicate from a MySQL 5.6 DB

1 Answered Questions

[SOLVED] Upgrading from MySQL 5.1.37 to MySQL 5.1.73

  • 2014-10-10 18:25:20
  • antee
  • 376 View
  • 1 Score
  • 1 Answer
  • Tags:   mysql mysql-5.1

1 Answered Questions

Sponsored Content