The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

questions about upgrading from mysql 5.1 to 5.5

Discussion in 'Database Discussions' started by Venomous21, Jun 25, 2014.

  1. Venomous21

    Venomous21 Well-Known Member

    Joined:
    Jun 28, 2012
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    I've read a couple dozen threads and information on various sites and could use some advice / feedback. I am running several vps with latest CentOS 5 x64 / cpanel 11.42.x. All servers run the latest version of php 5.3 and mysql 5.1 and apache 2.2. I'd like to get mysql updated to 5.5 so I can update cpanel to 11.44.

    I want to update mysql from 5.1 to 5.5 on our test server first and let it run for about a week but here's my concern. It's possible a developer will need to move a database from test to live and would be moving it from version 5.5 (test server once updated) to 5.1 live. Most of our sites run latest version of release drupal and wordpress. If I run mysqldump command, will I be able to import a database dumped from 5.5 back into 5.1 or is this going to potentially cause a lot of headaches and/or corruption? The mysql documentation makes it sound like as long as I use mysqldump it should be ok but then other stuff on there made me think otherwise. What are your thoughts?

    If this is a serious concern, should I try to roll out 5.5 to all the servers fairly quickly? I'd like to avoid this in case any unforeseen issues arise. Obviously, would rather have issues confined to a test server than the live servers too. What do you think the best way to handle this issue?

    Should I make any modifications before the upgrade to my.cnf?

    cat /etc/my.cnf
    [mysqld]
    set-variable = max_connections=500
    log-slow-queries
    safe-show-database
    open_files_limit=7198

    Should I definitely increase the open files limit after the upgrade? I've seen that mentioned several times.

    I appreciate any info and advice you can provide. Thank you.
     
    #1 Venomous21, Jun 25, 2014
  2. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    56
    cPanel Access Level:
    Root Administrator
    Mysql dump is the proper way to take a db backup and restore it on another server. There won't be any issues based on the server version.
     
    #2 SS-Maddy, Jun 26, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #3 cPanelMichael, Jun 26, 2014
  4. Venomous21

    Venomous21 Well-Known Member

    Joined:
    Jun 28, 2012
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    Have any others tried to create a mysqldump from 5.5 and then tried importing it back into 5.1? I'm concerned this may cause issues and the mysql documentation isn't too clear. Has anyone tried it? If there's even a remote chance it will cause issues, I may update our test/development server last even though this goes against the grain since we move databases from test/development to the live servers. I know this is against the conventional wisdom but may make the most sense in this case if there are issues exporting 5.5 and then importing it back into 5.1. There aren't issues going from 5.1 to 5.5 from what I've seen (at least on updated wordpress/ drupal installs)

    Once the update is done, do you recommend I go into my.cnf and set open_files_limit=20000 ? Is this recommended or should I leave the default option set?

    I've read some horror stories about users going from 5.1 to 5.5 and I'm concerned. I am only updating since it's end-of-life and I want the latest release candidate cpanel updates. 5.1 has been remarkably stable and I've read 5.5 hasn't been for many people but am hoping these bugs / issues have been worked out since its release.

    Thank you!
     
    #4 Venomous21, Jun 30, 2014
  5. Archmactrix

    Archmactrix Well-Known Member

    Joined:
    Jan 20, 2012
    Messages:
    133
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    You should have the below instead for MySQL 5.5 and recent versions of 5.1 if you need to enable these options or change their values:

    I'm not sure about the open_files_limit variable, but I did include your own value.

    safe-show-database variable is deprecated.

    Code:
    [mysqld]
slow-query-log
slow_query_log_file
long_query_time=1
max_connections=500
open-files-limit=7198
    You can change the long_query_time value or you can remove that variable, which will let the server use the default 10 sec value.

    You can use slow_query_log_file variable as it is, which will use the default name host_name-slow.log, or you can change the name like this:

    Code:
    slow_query_log_file=your-slow-log-name.log
     
    #5 Archmactrix, Jul 1, 2014
    Last edited: Jul 1, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - questions upgrading mysql
  1. EneTar

    Questions before upgrading to Cloulinux

    EneTar, Sep 30, 2016, in forum: CloudLinux
    Replies:
    4
    Views:
    513
    Bazinga
    Oct 7, 2016
  2. delphiman

    Setting up DKIM questions

    delphiman, Aug 10, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    72
    cPanelMichael
    Aug 11, 2017
  3. Droidism20011

    MySQL -> MariaDB security questions

    Droidism20011, Jul 20, 2017, in forum: Security
    Replies:
    3
    Views:
    113
    Droidism20011
    Jul 24, 2017
  4. tibbitts

    IP Migration Tool questions

    tibbitts, Jun 20, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    120
    tibbitts
    Jun 20, 2017
  5. PeteS

    FirewallD setup questions

    PeteS, Jun 19, 2017, in forum: Security
    Replies:
    16
    Views:
    250
    cPanelBenny
    Jun 29, 2017

Share This Page