The attached document is a draft for to migrate MySQL 4.1 and 5.0 to their slotted counterpart. It's still in "draft" status, since need to be wider tested. It has some elements (and enhanchements) from mysql-upgrading.xml and may be expanded to replace mysql-upgrading totally. The named ebuilds are already in the portage tree, still masked but working.
Created attachment 78019 [details] migrate-to-slot.xml sligtly modified version of the doc already submitted to d.g mail list
Created attachment 78040 [details] mysql-upgrade-slotted.xml Fixed coding style (ie. removed the <br/> mess, touched up <ul> etc), fixed some English stuff. It's 2:31 AM here so someone should review this :).
typo: in "Code Listing 3.1: Dump of all databases", "--defaults-file=/etc/mysql/my.cnf" should be "--defaults-file=/etc/mysql/my.cnf \". Notice the ending slash
in "Code Listing 3.2: Load data" """ # mv /etc/conf.d/mysql.orig /etc/conf.d/mysql # /etc/init.d/mysql-500 stop """ the order should be inverted """ # /etc/init.d/mysql-500 stop # mv /etc/conf.d/mysql.orig /etc/conf.d/mysql """ It work anyway but it's not logical
And also: Code Listing 4.2: cleanup first step """ rm -rf /usr/lib/*.TMP rm -rf /usr/lib/*.TMP """ duplicated line """ # for i in /usr/lib/*mysql* ; do readlink -f $i || [[ -L $i ]] && rm $i done """ does _not_ work as intended, it should be """ # for i in /usr/lib/*mysql* ; do [[ -z "$( readlink -f $i )" ]] && [[ -L $i ]] && rm $i done """ or """ emerge app-misc/symlinks && symlinks -rd /usr/lib """
please add a note in "Copy the data to the newly installed server", if we are moving say from "dev-db/mysql-5.0.18" to "dev-db/mysql-5.0.18-r30" it's possible to: - stop the databases - simply move data from one datadir to the other - start it again skipping that section entirely With these changes I consider the document ready to be published, toughts?
Ok, I've added vivo's changes and edited/added in some additional points. I'm attaching the document in full, as well as a diff to show the relevant changes. An "Ok" rendered version is avaliable here: http://dev.gentoo.org/~chriswhite/docs/mysql-slotted.html Attaching the stuff.
Created attachment 78470 [details] mysql-slotted-edited.xml The document in full.
Created attachment 78471 [details, diff] Differences between jtk's last version and mine
Created attachment 78478 [details] mysql-upgrade-slotted.xml Okay, this cleans up ChrisWhite's version. Fixes numerous spelling and grammatical errors, and also clarifies/rewrites certain sections for legibility. Oh, and the bash scripts were fixed. :p Please review and comment on the changes. Thanks! :)
Created attachment 78479 [details] mysql-upgrade-slotted.xml Some tiny bash code changes at ChrisWhite's request.
In CVS, thanks.
Created attachment 78523 [details, diff] mysql-upgrade-slotted.xml.patch undergoing change of the init.d script
...more updates...
Created attachment 78525 [details, diff] rephrased vivo's proposal
In CVS.