Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread martin doc
On Wednesday 16 September 2020, andrei elkin wrote: > Martin, howdy. > > Hi, > > > > I've got a bit of a different question regarding MariaDB replication. > > > > But first, let me say that I'm familiar with both master-master and > > master-slave replication. > > > > What I'm after advice on is ho

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread andrei . elkin
Martin, howdy. > Hi, > > I've got a bit of a different question regarding MariaDB replication. > > But first, let me say that I'm familiar with both master-master and > master-slave replication. > > What I'm after advice on is how to replicate tables from a number of single > host instances of Ma

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread Antony Stone
On Tuesday 15 September 2020 at 13:07:22, martin doc wrote: > On Tuesday 15 September 2020, Antony Stone wrote: > > > > Firewall rules? > > I was thinking about that ... it would requiring sync'ing iptables rules > with VIP movement. Why? If the connection comes from the VIP, it's constant as

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread martin doc
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

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread Antony Stone
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? Antony. -- What do you get when

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread martin doc
On Tuesday 15 September 2020, Anthony Stone wrote: > On Tuesday 15 September 2020 at 11:45:05, martin doc wrote: > > What I'm after advice on is how to replicate tables from a number of single > > host instances of MariaDB to a single HA pair of MariaDB servers > > (HA-1/HA-2) that have a VIP that

Re: [Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread Antony Stone
On Tuesday 15 September 2020 at 11:45:05, martin doc wrote: > What I'm after advice on is how to replicate tables from a number of single > host instances of MariaDB to a single HA pair of MariaDB servers > (HA-1/HA-2) that have a VIP that moves between them. > > One way of looking at this might

[Maria-discuss] How to replicate TO a HA pair of MariaDB servers?

2020-09-15 Thread martin doc
Hi, I've got a bit of a different question regarding MariaDB replication. But first, let me say that I'm familiar with both master-master and master-slave replication. What I'm after advice on is how to replicate tables from a number of single host instances of MariaDB to a single HA pair of M