Mysql-mmm + mysqld_multi?
arno
is it possible to run mysqld_multi with mysql-mmm ?
We have a Myisam and an InnoDB mysql process running, which we split
because their needs for optimization are totally different.
Now we want to switch over to mysql-mmm from a heartbeat/drbd setup.
From what I was able to crasp from a first look seems that mysql-mmm
does not run with multiple configurations. As replication would have
to be working in two mysql instances (ports 3306 and 3307) this would
be key.
Anyone accomplished to do that?
Thanks,
Arno
Walter Heck
--
You received this message because you are subscribed to the Google Groups "MySQL Multi Master Manager Development" group.
To post to this group, send email to mmm-...@googlegroups.com.
To unsubscribe from this group, send email to mmm-devel+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mmm-devel?hl=en.
--
Walter Heck
--
follow @walterheck on twitter to see what I'm up to!
--
Check out my new startup: Server Monitoring as a Service @ http://tribily.com
Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
petya
I needed this too a while ago, I don't see why running multiple
instances on a single box is suboptimal. MMM 1.x had a port
configuration directive in the <host> tag, which seems to be gone in MMM
2.x. I guess Arno replicates both of the instances, and don't want to
switch between instances in a box. Even switching between instances in a
box can have it's use cases like testing.
Peter Boros
On 02/24/2011 03:52 PM, Walter Heck wrote:
> The agents don't support this out of the box. I imagine it wouldn't be
> too hard to make them support it, but it kind of defeats the purpose of
> MMM altogether. I'm not sure what it is that you are doing, but it seems
> like you might be going at this in a sub-optimal way.
>
> Walter
>
> On Thu, Feb 24, 2011 at 08:20, arno <arno...@googlemail.com
> <mailto:arno...@googlemail.com>> wrote:
>
> Hello,
>
> is it possible to run mysqld_multi with mysql-mmm ?
>
> We have a Myisam and an InnoDB mysql process running, which we split
> because their needs for optimization are totally different.
>
> Now we want to switch over to mysql-mmm from a heartbeat/drbd setup.
>
> From what I was able to crasp from a first look seems that mysql-mmm
> does not run with multiple configurations. As replication would have
> to be working in two mysql instances (ports 3306 and 3307) this would
> be key.
>
> Anyone accomplished to do that?
>
> Thanks,
> Arno
>
> --
> You received this message because you are subscribed to the Google
> Groups "MySQL Multi Master Manager Development" group.
> To post to this group, send email to mmm-...@googlegroups.com
> <mailto:mmm-...@googlegroups.com>.
> To unsubscribe from this group, send email to
> mmm-devel+...@googlegroups.com
> <mailto:mmm-devel%2Bunsu...@googlegroups.com>.
Pascal Hofmann
> I needed this too a while ago, I don't see why running multiple instances on a single box is suboptimal. MMM 1.x had a port configuration directive in the <host> tag, which seems to be gone in MMM 2.x. I guess Arno replicates both of the instances, and don't want to switch between instances in a box. Even switching between instances in a box can have it's use cases like testing.
See http://mysql-mmm.org/mysql-mmm.html#SEC55 - "mysql_port"
Cheers
Pascal Hofmann
petya
Although I didn't spend much time on this, I took a look at the manual,
it seems that I am somewhat blind:). Thank you. I am happy that this is
doable.
Here is an other use case: you have a huge database, but your hot data
is not that large. Not hot data will ruin your buffer pool, since you
can't pin innodb pages to it. Running 2 instances for this can solve
your buffer pool trashing problem.
Peter Boros
petya
Sorry, I didn't have time to look at this before, but Pascal's answer
was promising.
I set this up successfully and based on this patch
https://bugs.launchpad.net/mysql-mmm/+bug/525719
and the init script, the process is pretty straightforward. I will write
some kind of howto about this on the mysql mmm wiki if multiple people
from this list would find it useful.
Peter Boros
Arjen Lentz
On 05/04/2011, at 5:57 AM, petya wrote:
> Sorry, I didn't have time to look at this before, but Pascal's
> answer was promising.
> I set this up successfully and based on this patch
> https://bugs.launchpad.net/mysql-mmm/+bug/525719
> and the init script, the process is pretty straightforward. I will
> write some kind of howto about this on the mysql mmm wiki if
> multiple people from this list would find it useful.
> Peter Boros
sounds good!
these are definitely valid use-cases for mysqld_multi
Cheers,
Arjen.
> On 02/24/2011 08:20 AM, arno wrote:
>> Hello,
>>
>> is it possible to run mysqld_multi with mysql-mmm ?
>>
>> We have a Myisam and an InnoDB mysql process running, which we split
>> because their needs for optimization are totally different.
>>
>> Now we want to switch over to mysql-mmm from a heartbeat/drbd setup.
>>
>> From what I was able to crasp from a first look seems that mysql-mmm
>> does not run with multiple configurations. As replication would have
>> to be working in two mysql instances (ports 3306 and 3307) this would
>> be key.
>>
>> Anyone accomplished to do that?
>>
>> Thanks,
>> Arno
>>
>
> --
> You received this message because you are subscribed to the Google
> Groups "MySQL Multi Master Manager Development" group.
> To post to this group, send email to mmm-...@googlegroups.com.
> To unsubscribe from this group, send email to mmm-devel+...@googlegroups.com
> .
> For more options, visit this group at http://groups.google.com/group/mmm-devel?hl=en
> .
>
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at http://openquery.com/blog/ & http://twitter.com/openquery