Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Ciro
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote:
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Best thing to do is to check:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Leo
2007/8/5, Leo Eraly leo@unstable.be:
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote:
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Best thing to do is to check:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Leo
Leo Eraly leo@unstable.be
Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade.
Ciro
2007/8/5, Ciro Iriarte cyruspy@gmail.com:
2007/8/5, Leo Eraly leo@unstable.be:
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote:
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Best thing to do is to check:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Leo
Leo Eraly leo@unstable.be
Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade.
Ciro
Also noticed that those packages appeared on July (in many years i've looked after SLES9, there weren't packages for mysql5), maybe they're going to be included on SP4?
Ciro
Ciro Iriarte wrote:
2007/8/5, Ciro Iriarte cyruspy@gmail.com:
2007/8/5, Leo Eraly leo@unstable.be:
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote:
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Also noticed that those packages appeared on July (in many years i've looked after SLES9, there weren't packages for mysql5), maybe they're going to be included on SP4?
They appeared recently because the SLES9 builds were broken previously:
* Fri Jun 01 2007 - mmarek@suse.cz - fixed build for older distributions in the buildservice
This has nothing to do with SP4.
Michal
Ciro Iriarte wrote:
2007/8/5, Leo Eraly leo@unstable.be:
On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote:
Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/)
Best thing to do is to check:
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Leo
Leo Eraly leo@unstable.be
Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade.
I would be interested as well. But I'm affraid the buildservice packages for SLES9 don't have many users, given that two months ago they didn't exist. You'll probably be the first one! ;-)
Michal
2007/8/7, Michal Marek mmarek@suse.cz:
Thanks, i've already seen this (exactly http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i was willing to hear experiences from someone that actually did the upgrade.
I would be interested as well. But I'm affraid the buildservice packages for SLES9 don't have many users, given that two months ago they didn't exist. You'll probably be the first one! ;-)
Michal
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)?
I'll report back the result of my tests.
Regards, Ciro
Ciro Iriarte wrote:
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as well btw, or adding the repo to yast (if you want to update all packages).
For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)?
I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is "soon after the official release" ;)
I'll report back the result of my tests.
Cool. Looking forward for your results :)
Michal
2007/8/9, Michal Marek mmarek@suse.cz:
Ciro Iriarte wrote:
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as
That probably won't do it, the package are not the same. We currently have:
mysql-4.1.10a-3.4 <---- taken from suse 9.3 mysql-client-4.1.10a-3 <---- taken from suse 9.3 mysql-shared-4.0.18-32.1 <--- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 <--- stock too
MySQL5:
libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm <--- huh?
libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm <--- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm <--- confused
mysql-5.0.45-2.1.x86_64.rpm <--- goes in mysql-Max-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-client-5.0.45-2.1.x86_64.rpm <--- goes in mysql-debug-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-test-5.0.45-2.1.x86_64.rpm <-- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm <-- not sure pgpool-3.1.1-4.3.x86_64.rpm <-- sounds out of place
well btw, or adding the repo to yast (if you want to update all packages).
For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)?
I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is "soon after the official release" ;)
I'll report back the result of my tests.
Cool. Looking forward for your results :)
Michal
Ciro
Ciro Iriarte wrote:
2007/8/9, Michal Marek mmarek@suse.cz:
Ciro Iriarte wrote:
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as
That probably won't do it, the package are not the same. We currently have:
mysql-4.1.10a-3.4 <---- taken from suse 9.3 mysql-client-4.1.10a-3 <---- taken from suse 9.3 mysql-shared-4.0.18-32.1 <--- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 <--- stock too
MySQL5:
libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm <--- huh?
libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm <--- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm <--- confused
mysql-5.0.45-2.1.x86_64.rpm <--- goes in mysql-Max-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-client-5.0.45-2.1.x86_64.rpm <--- goes in mysql-debug-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-test-5.0.45-2.1.x86_64.rpm <-- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm <-- not sure pgpool-3.1.1-4.3.x86_64.rpm <-- sounds out of place
And what's the problem? 'rpm -Uvh mysql-5.0.*.rpm mysql-client-5.0.*.rpm libmysqlclient15-5.0.*.rpm' will give you a working mysql5 setup. And it'll keep the 4.x libs for apps linked against it (php).
Michal
2007/8/10, Michal Marek mmarek@suse.cz:
Ciro Iriarte wrote:
2007/8/9, Michal Marek mmarek@suse.cz:
Ciro Iriarte wrote:
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as
That probably won't do it, the package are not the same. We currently have:
mysql-4.1.10a-3.4 <---- taken from suse 9.3 mysql-client-4.1.10a-3 <---- taken from suse 9.3 mysql-shared-4.0.18-32.1 <--- stock, needed by php and other packages. It'll be a mess to try to compile php with the new libs i guess mysql-devel-4.0.18-32.20 <--- stock too
MySQL5:
libedit-devel-2.10.snap20070302-11.1.x86_64.rpm libedit0-2.10.snap20070302-11.1.x86_64.rpm <--- huh?
libmysqlclient-devel-5.0.45-2.1.x86_64.rpm libmysqlclient15-5.0.45-2.1.x86_64.rpm <--- confused libmysqlclient_r15-5.0.45-2.1.x86_64.rpm <--- confused
mysql-5.0.45-2.1.x86_64.rpm <--- goes in mysql-Max-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-bench-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-client-5.0.45-2.1.x86_64.rpm <--- goes in mysql-debug-5.0.45-2.1.x86_64.rpm <-- not interested in mysql-test-5.0.45-2.1.x86_64.rpm <-- i don't think we need it mysql-tools-5.0.45-2.1.x86_64.rpm <-- not sure pgpool-3.1.1-4.3.x86_64.rpm <-- sounds out of place
And what's the problem? 'rpm -Uvh mysql-5.0.*.rpm mysql-client-5.0.*.rpm libmysqlclient15-5.0.*.rpm' will give you a working mysql5 setup. And it'll keep the 4.x libs for apps linked against it (php).
Michal
Ok, i'll try it.. I'm curious about the difference between libmysqlclient15 and libmysqlclient_r15.
Ciro
2007/8/9, Michal Marek mmarek@suse.cz:
Ciro Iriarte wrote:
Probably i'll copy the datafiles (as soon as i get the needed space) to a vmware installation and try to update mysql or probably reinstall it (rpm -e mysql/rpm -i mysql-5.blah).
If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as well btw, or adding the repo to yast (if you want to update all packages).
For production i would like to wait for 5.1 as i'm interested on using table partitions (there's an ugly +60GB table around). Have any idea when it's going to be released (and added to Build Service)?
I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is "soon after the official release" ;)
I'll report back the result of my tests.
Cool. Looking forward for your results :)
Michal
Hi, reporting back :D Unlukily i couldn't get enought disk space in my workstation to install a VM and copy over all the production datafiles to test a direct upgrade. Two weeks ago one of our replicated 4.1 servers crashed and couldn't recover the datafiles, so last night I wiped the DB filesystem and started from scratch.
Succesfully installed the 5.1 packages from http://download.opensuse.org/repositories/server:/database:/mysql51/SLES_9/x... and i'm currently restoring from a DB dump. Would be great just to start with the binary files though...
I'll report any issue.
Regards, Ciro
Ciro Iriarte wrote:
Succesfully installed the 5.1 packages from http://download.opensuse.org/repositories/server:/database:/mysql51/SLES_9/x... and i'm currently restoring from a DB dump. Would be great just to start with the binary files though...
Hi,
any news? I'm quite interested in experience with the 5.1 rpms, as that will sooner or later become part of the distribution.
thanks, Michal
-
Ciro Iriarte -
Leo Eraly -
Michal Marek