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] InnoDB: background jobs & fsyncs

2020-09-15 Thread Marko Mäkelä
Hi Julien, First of all, is the version really 10.2.23, which was released in March 2019? If you are actually using the latest 10.2.33 release, you might be affected by MDEV-20638, which surprisingly introduced a performance regression. Based on benchmarks, we reverted that change from the upcomin

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

[Maria-discuss] InnoDB: background jobs & fsyncs

2020-09-15 Thread Julien Muchembled
Hello, We are evaluating new hardware by reproducing real-life workload on real-life data which works fine on an existing server. We copied over the software used to ensure an apple-to-apple comparison, which is based on MariaDB 10.2.23 and uses primarily InnoDB tables, with a few Mroonga tables w

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