Hi all,
I need to set up multiple MySQL instances on the same host for one of
our customers. As far as I see I could go with:

1. mysqld_multi
2. MySQL Sandbox

This should be a long term solution for an enterprise class production
environment.

Any comments and suggestions - pros, cons and real world experience are
very welcome!



Thanks
Dimitre

Radoulov, Dimitre wrote:
why ?

what is wrong with multiple databases and one instance?

On Fri, 30 Sep 2011 17:20:50 +0100, The Natural Philosopher wrote:
And if one really DOES need multiple instances, well, go ahead and
install it twice with different install locations (and possibly just
using symlinks to get to stuff that really WOULD be duplicated between
instances), with different configuration files that specify different
ports, etc. There's very little that actually prevents this from
happening.

--
A way of life that is odd or even erratic but interferes with no rights
or interests of others is not to be condemned because it is different.
-- Chief Justice Warren E. Burger

On 30/09/2011 18:20, The Natural Philosopher wrote:

Hi,
we need to migrate an already existing environment which currently uses
the RedHat Cluster with active/passive nodes to a new VM without the
clustering software (VMware HA solutions will be used, it will be
different, I know). There are 3 separate mysql instance/cluster
resources. I don't know the original motivation for this separation, but
I suppose that the customer wants to be able to stop/start (patch,
upgrade ...) the different resources autonomously ...



Regards
Dimitre

"Radoulov, Dimitre" <cichomitiko (AT) gmail (DOT) com> wrote:

This sucks and often malfunctions

And this is not for productive use

Just RTFM for what has to be configured to have multiple instances
running on one machine. Then write the respective number of my.cnfs
and create multiple instances of /etc/init.d/mysqld

It's not rocket science


XL

On 30/09/2011 23:13, Axel Schwenke wrote:
Thanks again Axel,
I'll try to implement a custom solution.
I'll definitely have more control in this way.


Regards
Dimitre

If you have a recent Linux kernel, you could also try kernel-level
para-virtualisation (it probably has another name, but I don't know it).
You can separate a process with it from other processes. It's a kind of
elegant chroot.

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

On 03/10/2011 09:31, Willem Bogaerts wrote:
Thanks Willem,
I'll look at it.



Regards
Dimitre