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.
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.