Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 120210 - Migration to slotted MySQL initial document
Summary: Migration to slotted MySQL initial document
Status: RESOLVED FIXED
Alias: None
Product: [OLD] Docs-user
Classification: Unclassified
Component: Other (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Jan Kundrát (RETIRED)
URL:
Whiteboard:
Keywords:
Depends on: 125599
Blocks: 120222
  Show dependency tree
 
Reported: 2006-01-24 11:54 UTC by Francesco R. (RETIRED)
Modified: 2006-03-09 06:45 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
migrate-to-slot.xml (mysql-migrate-to-slot.xml,8.02 KB, text/plain)
2006-01-24 11:55 UTC, Francesco R. (RETIRED)
Details
mysql-upgrade-slotted.xml (mysql.xml,7.90 KB, text/plain)
2006-01-24 17:32 UTC, Jan Kundrát (RETIRED)
Details
mysql-slotted-edited.xml (mysql-slotted-edited.xml,8.68 KB, text/plain)
2006-01-29 13:05 UTC, Chris White (RETIRED)
Details
Differences between jtk's last version and mine (mysql-slotted-edited.diff,12.72 KB, patch)
2006-01-29 13:06 UTC, Chris White (RETIRED)
Details | Diff
mysql-upgrade-slotted.xml (mysql-upgrade-slotted.xml,8.68 KB, text/plain)
2006-01-29 14:47 UTC, nm (RETIRED)
Details
mysql-upgrade-slotted.xml (mysql-upgrade-slotted.xml,8.68 KB, text/plain)
2006-01-29 15:50 UTC, nm (RETIRED)
Details
mysql-upgrade-slotted.xml.patch (mysql-upgrade-slotted.xml.patch,1.19 KB, patch)
2006-01-30 13:46 UTC, Francesco R. (RETIRED)
Details | Diff
rephrased vivo's proposal (mysql.patch,1.79 KB, patch)
2006-01-30 14:01 UTC, Jan Kundrát (RETIRED)
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Francesco R. (RETIRED) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 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) gentoo-dev 2006-01-29 13:05:38 UTC
Created attachment 78470 [details]
mysql-slotted-edited.xml

The document in full.
Comment 9 Chris White (RETIRED) gentoo-dev 2006-01-29 13:06:11 UTC
Created attachment 78471 [details, diff]
Differences between jtk's last version and mine
Comment 10 nm (RETIRED) gentoo-dev 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) gentoo-dev 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) gentoo-dev 2006-01-30 08:03:23 UTC
In CVS, thanks.
Comment 13 Francesco R. (RETIRED) gentoo-dev 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) gentoo-dev 2006-01-30 14:00:15 UTC
...more updates...
Comment 15 Jan Kundrát (RETIRED) gentoo-dev 2006-01-30 14:01:00 UTC
Created attachment 78525 [details, diff]
rephrased vivo's proposal
Comment 16 Jan Kundrát (RETIRED) gentoo-dev 2006-01-30 14:07:43 UTC
In CVS.