[debian-mysql] Bug#435165: mysql-server-5.0: Clearly note we don't support multi-instances by duplicating init script

[sean finney]

severity 435165 wishlist
thanks

hi dan,

yes, i've actually been talking with on of the "debian guys" within mysql 
about how this is a fairly common problem in real-world installations for 
them as well.  not only multiple instances, but multiple versions as well.  
i'll probably be talking with him more about the details of implementing 
this, but i'm sure the patch below would be a good first step since we'll 
have to do this abstraction at some point anyway.

for a final version, i think we'll probably do something similar to what pitti 
set up with the postgres packages, but i'm also not familiar enough with that 
to know all the details of the implementation.

i'll take a look at the specifics of the patch the next time i'm sitting down 
with the packaging, and maybe we can use this BR for general discussion about 
this topic both in the meantime and until we get the full support.


thanks,
	sean

On Sunday 29 July 2007 09:24:46 pm Dan Munckton wrote:
> Package: mysql-server-5.0
> Version: 5.0.45-1
> Severity: minor
>
> This is the result of the bug reported in Ubuntu. Raised here to pass
> the debdiff upstream to Debian.
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/106244
>
> A user reported that they were trying to run multiple instances of
> mysqld by duplicating the init script and changing the value of the CONF
> variable within it to point to another configuration file. They raised
> the bug in Ubuntu because the /etc/mysql/my.cnf is hard coded in a lot
> of the startup scripts, and prevented them from easily running
> multi-instances in this way.
>
> After some analysis and discussion with mathiaz and infinity from the
> ubuntu-server team it was agreed that we cannot properly support
> multi-instances in this way because the maintainer scripts are not
> designed to deal with this situation and could therefore lead to
> problems on package upgrade/removal. Instead the proper way to do things
> would seem to be to use mysqld_multi.
>
> A patch has been prepared which clearly comments the CONF variable
> stating that multi-instances are not supported in this way, and removes
> some of the hard-coded instances of '/etc/mysql/my.cnf' for the sake of
> tidyness.
>
> (This is my first bug report to the Debian BTS sorry if there are any
> slip-ups).
>
>
> -- System Information:
> Debian Release: 4.0
>   APT prefers feisty-updates
>   APT policy: (500, 'feisty-updates'), (500, 'feisty-security'), (500,
> 'feisty-backports'), (500, 'feisty') Architecture: i386 (i686)
> Shell:  /bin/sh linked to /bin/dash
> Kernel: Linux 2.6.20-16-generic
> Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070730/140f0d05/attachment-0001.pgp