Bug 120210 – Migration to slotted MySQL initial document

• Product: [OLD] Docs-user
• Status: RESOLVED FIXED

[Description Francesco R. (RETIRED) 2006-01-24 11:54:29 UTC]

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.

[Comment 1 Francesco R. (RETIRED) 2006-01-24 11:55:49 UTC]

Created attachment 78019 [details]
migrate-to-slot.xml

sligtly modified version of the doc already submitted to d.g mail list

[Comment 2 Jan Kundrát (RETIRED) 2006-01-24 17:32:22 UTC]

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

[Comment 3 Francesco R. (RETIRED) 2006-01-28 18:21:47 UTC]

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

[Comment 4 Francesco R. (RETIRED) 2006-01-28 18:27:13 UTC]

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

[Comment 5 Francesco R. (RETIRED) 2006-01-28 19:13:15 UTC]

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

[Comment 6 Francesco R. (RETIRED) 2006-01-28 19:18:57 UTC]

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?

[Comment 7 Chris White (RETIRED) 2006-01-29 13:05:07 UTC]

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.

[Comment 8 Chris White (RETIRED) 2006-01-29 13:05:38 UTC]

Created attachment 78470 [details]
mysql-slotted-edited.xml

The document in full.

[Comment 9 Chris White (RETIRED) 2006-01-29 13:06:11 UTC]

Created attachment 78471 [details, diff]
Differences between jtk's last version and mine

[Comment 10 nm (RETIRED) 2006-01-29 14:47:15 UTC]

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! :)

[Comment 11 nm (RETIRED) 2006-01-29 15:50:33 UTC]

Created attachment 78479 [details]
mysql-upgrade-slotted.xml

Some tiny bash code changes at ChrisWhite's request.

[Comment 12 Jan Kundrát (RETIRED) 2006-01-30 08:03:23 UTC]

In CVS, thanks.

[Comment 13 Francesco R. (RETIRED) 2006-01-30 13:46:05 UTC]

Created attachment 78523 [details, diff]
mysql-upgrade-slotted.xml.patch

undergoing change of the init.d script

[Comment 14 Jan Kundrát (RETIRED) 2006-01-30 14:00:15 UTC]

...more updates...

[Comment 15 Jan Kundrát (RETIRED) 2006-01-30 14:01:00 UTC]

Created attachment 78525 [details, diff]
rephrased vivo's proposal

[Comment 16 Jan Kundrát (RETIRED) 2006-01-30 14:07:43 UTC]

In CVS.