multiple IP support for exclusive roles

[[e-mail]]

mysql-mmm doesnt support multiple ip addresses for exclusive roles.

Like if I want to handle more than one IP from different subnets, mmm will fail sending arp packets and even fail to move the role without putting the current master in to admin_offline mode.

[Pascal Hofmann (pascalhofmann)]

Exclusive role should always have only one ip. mmm should check this and die if more than one is configured.
We should introduce ip "aliases" for cases where multiple ips (one per subnet) must be configured. config syntax could be something like this:
<role writer>
    hosts db1, db2
    ips 192.168.0.50
    mode exclusive
</role>

<ip 192.168.0.50>
    alias 192.168.1.50, 192.168.2.50, 192.168.3.50, 192.168.4.50
</ip>

Regards
Pascal

[Pascal Hofmann (pascalhofmann)]

The above is not perfect... we need a way to specify the network interface for these "alias" ips too

[Martin (mwb311)]

I also want to do the same because a customer has a UPS shipping tool which needs read/write access via ODBC. They do not support APIs so I think using a MySQL proxy on a host which has access to the internal network (and floating IPs) would be the best work around for now.

[Walter Heck (walterheck)]

Just FYI: Be careful with MySQL Proxy. It is not in any production-ready state.

Walter

On Wed, Nov 4, 2009 at 00:10, Martin <email address hidden> wrote:
> I also want to do the same because a customer has a UPS shipping tool
> which needs read/write access via ODBC. They do not support APIs so I
> think using a MySQL proxy on a host which has access to the internal
> network (and floating IPs) would be the best work around for now.
>
> --
> multiple IP support for exclusive roles
> https://bugs.launchpad.net/bugs/405786
> You received this bug notification because you are subscribed to mysql-
> mmm.
>
> Status in MMM for MySQL: Confirmed
>
> Bug description:
> mysql-mmm doesnt support multiple ip addresses for exclusive roles.
>
> Like if I want to handle more than one IP from different subnets, mmm will fail sending arp packets and even fail to move the role without putting  the current master in to admin_offline mode.
>