maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05939
Re: How to replicate TO a HA pair of MariaDB servers?
-
To:
Antony Stone <Antony.Stone@xxxxxxxxxxxxxxxxxxxxxx>, "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
martin doc <db1280@xxxxxxxxxxx>
-
Date:
Tue, 15 Sep 2020 11:07:22 +0000
-
Accept-language:
en-AU, en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=xqH4iMBHADyl28K35wtKaiVMJQ/CnlONQMQPmKiNEKQ=; b=InLBhVYGDht9uI4g3DY9ktvbQJZ8dKUQ8Y8aX1mMGYxWgx8fUehO+775zDm4/xAUlt4BSgCYhPaxAXy1fKO1vSrzD+RHjdoDjN1373LlpdBYqcrSIN38DAX5///a6vORwDB8Jh0v4qt+lk6WHWY6NvOJSLEVeKEhQOWHVIwEF/t1SNQBLIsDU8HN7cgPEMCUltbL0cyR+5CrBCU8IESODOe/d/maiR9R9S6PDVJtckGeZWeT2c1Z1Zop0G9Y3Y48fEwgMtDef+k2oES+ZBj1P4OEA/dbLD1JyMdAw28+ogOhuqtdpU+4p9uFVQJmK4dS3s1vsoYowzSqzxXoB7191A==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=IXbjlHwCF41B5205yqAi3QDw5ys5EoGls3YEmFOYsGlq0mxfRUnTs/SO8yGsimz0YbidofLBi4+nFzjEOA0tJLAv1S78ikkuX3LcKemXBdPzlmb9saq4lax893ee5BgxC9RpIUm8w7QXgwOlIwNBOnomaVo4r1otNeytbg4sR8XSWuf/9/G+0Y/SGujUukspA76SlOncIObd9LpLVkA1YB2X63sSydL5VUwkL2NCjkMY0jF3BefRllfp9roP7LyKTHoU343yQeAN5IGBGcZn1R2X4Ch9ZtTqPIL1EV2ux+nT3N7CjULy3i1SLoS4hvKRtwY+w7B8avfktqum6f0TMg==
-
In-reply-to:
<202009151250.10796.Antony.Stone@mariadb.open.source.it>
-
Thread-index:
AQHWi0i2Ugrea6Zreka0qVWP+6UTmKlpf5lxgAAFzACAAAFh/w==
-
Thread-topic:
[Maria-discuss] How to replicate TO a HA pair of MariaDB servers?
On Tuesday 15 September 2020, Anthony Stone wrote:
> On Tuesday 15 September 2020 at 12:39:16, martin doc wrote:
> > I've also used multi-master configurations with GTID before but there's
> > still the problem of how to restrict the connection accepted on the slave
> > to only be the host with the VIP.
> Firewall rules?
I was thinking about that ... it would requiring sync'ing iptables rules with VIP movement.
Then I could selectively NAT to force outgoing connections to appear as if they come from the VIP.
Is it possible to run a script when a VIP moves as some kind of event based action?
Follow ups
References
