Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 125599

Summary: deprecation of "Slotted MySQL Upgrade and Migration Guide"
Product: [OLD] Docs on www.gentoo.org Reporter: Francesco R. (RETIRED) <vivo>
Component: Other documentsAssignee: Xavier Neys (RETIRED) <neysx>
Status: RESOLVED FIXED    
Severity: normal CC: docs-team, gurligebis, mmokrejs, wschlich
Priority: High    
Version: unspecified   
Hardware: All   
OS: Linux   
URL: http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml
Whiteboard:
Package list:
Runtime testing required: ---
Bug Depends on:    
Bug Blocks: 120210    

Description Francesco R. (RETIRED) gentoo-dev 2006-03-09 06:43:36 UTC
see also "https://forums.gentoo.org/viewtopic-t-438557.html"

my apologies goes to everybody has wasted his time for what has been basically a chain of errors made by me.


Due to the negative response (see previous phrase) to the slotted MySQL introduction, these packages are going to be removed.

asking if it's possible to update the mentioned document, stating that:

a) the slotted mysql packages will be masked and masked/removed as soon as possible

b) _ONLY_ for people that has already migrated to slotted to upgrade to un-slotted following procedure:

--- cut & paste ---
echo " building a unslotted copy of mysql "
emerge --buildpkgonly '=dev-db/mysql-5.0.18-r60'

echo " stopping the server  "
/etc/init.d/mysql stop

echo " removing most of symlinks "
eselect mysql remove

echo " config files "
mv /etc/mysql /etc/mysql.old
mv /etc/mysql-500 /etc/mysql

echo " removal of remaining symlinks, and eselect stuff "
rm /usr/lib/mysql /usr/include/mysql /usr/bin/mysql_config
rm -rf /var/lib/eselect/mysql/

echo " unmerge slotted mysql "
emerge -C \
=dev-db/mysql-4.0.26-r30 \
=dev-db/mysql-4.1.15-r30 \
=dev-db/mysql-4.1.16-r30 \
=dev-db/mysql-4.1.18-r30 \
=dev-db/mysql-5.0.15-r30 \
=dev-db/mysql-5.0.16-r30 \
=dev-db/mysql-5.0.17-r30 \
=dev-db/mysql-5.0.18-r30 \
=dev-db/mysql-5.1.3_alpha-r30 \
=dev-db/mysql-5.1.4_alpha-r30 \
=dev-db/mysql-5.1.6_alpha-r30 \
app-admin/eselect-mysql

echo " ready to merge again MySQL "
emerge --usepkgonly '=dev-db/mysql-5.0.18-r60'
--- cut & paste ---

Additionally it's optional but adviceable move "datadir" and other directory or files whose
location is driven by /etc/mysql/my.cnf config file.


The new, unslotted packages are _already_ in the tree, masked but ready to be deployed when the user-base have been informed.
Comment 1 nm (RETIRED) gentoo-dev 2006-03-09 10:14:23 UTC
(In reply to comment #0)
I don't regret all the time and work I put into the doc. I'm just sad to see it go. :(
Comment 2 Francesco R. (RETIRED) gentoo-dev 2006-03-10 02:13:57 UTC
(In reply to comment #1)
> (In reply to comment #0)
> I don't regret all the time and work I put into the doc. I'm just sad to see it
> go. :(
> 

Thanks for the support Josh, I will find a solution to not trash all the work putted into this.

...........

there is an additional cleanup to do under 

echo " removal of remaining symlinks, and eselect stuff "
rm /usr/lib/mysql /usr/include/mysql /usr/bin/mysql_config
rm -rf /var/lib/eselect/mysql/

Should be extended like this:

echo " removal of remaining symlinks, and eselect stuff "
rm /usr/lib/mysql /usr/include/mysql /usr/bin/mysql_config \
/usr/lib/libmysql*
rm -rf /var/lib/eselect/mysql/ /usr/lib/mysql-[45]0[01]

Comment 3 Xavier Neys (RETIRED) gentoo-dev 2006-03-10 14:57:16 UTC
File is ready to go, please ping me on irc or comment here when you want it to be committed.
Comment 4 Xavier Neys (RETIRED) gentoo-dev 2006-03-10 15:10:12 UTC
In CVS. Thanks.
Comment 5 email_deleted_GqKU 2006-03-16 07:31:37 UTC
(In reply to comment #2)
>
> there is an additional cleanup to do under 
> 

It seems we also have to remove/edit the /etc/conf.d/mysql and mysqlmanager file, if they were configured for slotting...
Comment 6 Francesco R. (RETIRED) gentoo-dev 2006-03-16 11:37:39 UTC
(In reply to comment #5)
> 
> It seems we also have to remove/edit the /etc/conf.d/mysql and mysqlmanager
> file, if they were configured for slotting...
> 

those files are present from few months before the slot change, are specifically enginered to work with both slotted and unslotted installations, and provide some enanchments in both the environment, DEBUG support, multiple instance running (also un-slotted), reordered options passed to the daemon.
Theese will be hidden to the end user if un-needed, so I see them only as a plus and justify the additional complexity needed for it.
There is some quick cleanup to do in the conf.d/mysql file (comments) and also in the init.d/mysql (really not a big simplification) but this last one will need more care and love.

rgds, Francesco