Re: [gentoo-user] Two instances of MySQL Database Server

[kashani <kashani-list@badapple.net>]

Daniel da Veiga wrote:
> On Thu, Apr 3, 2008 at 6:18 PM, kashani <kashani-list@badapple.net> wrote:
>> Daniel da Veiga wrote:
>>
>>> I don't understand why use a chroot to simply run another instance of
>>> MySQL. Is there any good reason?
>>> All you gotta do is create a new configuration file that points to a
>>> different database location and uses a different port, and clone and
>>> edit another /etc/init.d/mysql script to point to the new config file.
>>>
>>> A chroot would be just a waste of space, since you can use the same
>>> binary for multiple instances.
>>>
>>  About the only reason to run multiple instances is testing different
>> versions hence the chroot.
>>
> 
> The OP asked about different instances, not versions.

true, but again one of the few rational reasons to do this is to test 
multiple versions. Otherwise it's an efficient way to split your system 
resources in half. The OP could look at /etc/init.d/mysqlmanager which 
seems to support the idea of instances, but I'm not sure it would be 
useful outside running the same binary on a different port.

> Isn't MySQL slotted, so you can run different major versions (4 and 5,
> for example) at the same time?
> 

Not slotted in any meaningful within the system. You have to chroot. 
There was an attempt to do it within Gentoo a few years back, but it 
overly complicated for the average user and poorly implemented.

kashani
-- 
gentoo-user@lists.gentoo.org mailing list