From: Marcus Bointon
Date: September 23 2011 8:02pm
Subject: Re: mmm - mysql
List-Archive: http://lists.mysql.com/replication/2230
Message-Id: <1F411DC3-2E70-4558-BA7A-23036FF9C047@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1244.3)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

On 23 Sep 2011, at 19:57, Ricardo Freitas wrote:

> Followed your gentle advice regarding the mmm-mysql system and It is a =
go. I
> have a few questions that I've tried to found asnwer too but in vain.
> Regarding the configuration of the monitor, I found that there are a =
bunch
> of virtual addresses that the manual doesn't specify if I need to =
create
> them (on my network) or if is just something the monitor will handle.=20=


The only one you actually need is one for the writer role. If you want =
slaves to float too, you'll need an additional IP for each slave (=3D=3D =
reader role). You need to have a suitable allocated IP, mmm will =
configure it for you. Note that the floating IP is published by the =
agents (i.e. the database nodes) though the monitor node tells them to =
do it.

The MMM docs are a bit strangely formatted and it's sometimes hard to =
see what you need to set - post your config if you're still having =
trouble.

Much as for heartbeat, you might (try without first) also need to set =
sysctl to allow binding to non-local IPs. I have this line in =
/etc/sysctl.d/60-user.conf:

net.ipv4.ip_nonlocal_bind=3D1

This allows you to start daemons listening on IP addresses that he =
server doesn't currently have.

Marcus
--=20
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/