Re: [Maria-discuss] "Rewind" type of mechanisms?

2022-08-19 Thread Sergei Golubchik
Hi, Sam, It's not automatic, but you can replay binlog backwards and undo already committed changes: https://mariadb.com/kb/en/flashback/ On Aug 19, Sam R. wrote: > >Gordan Bobic wrote: > > There is no built in rewind option to roll back a committed > > transaction that I am aware of -

Re: [Maria-discuss] "Rewind" type of mechanisms?

2022-08-19 Thread Gordan Bobic
On Fri, Aug 19, 2022 at 3:05 PM Sam R. wrote: > > Thank you again! > > Sam wrote: > > Q: > > resync automatically --> Does it remove a possible (obsolete) rogue > row? > > Gordan Bobic wrote: > > A: > In asynchronous replication, yes it does. > > Only to double check the same. To make sure we

Re: [Maria-discuss] "Rewind" type of mechanisms?

2022-08-19 Thread Gordan Bobic
On Fri, Aug 19, 2022 at 12:37 PM Sam R. wrote: > > Thank you! > > > "You can automatically resync either with gtid based async replication" > > Few questions: > resync automatically --> Does it remove a possible (obsolete) rogue row? In asynchronous replication, yes it does. In Galera, it

Re: [Maria-discuss] "Rewind" type of mechanisms?

2022-08-19 Thread Gordan Bobic
You can automatically resync either with gtid based async replication or with Galera without full reseeding. On Fri, Aug 19, 2022 at 11:57 AM Sam R. wrote: > > Hi! > > I would like to know about following topic regarding MariaDB. > We would like to run DB cluster with HA (high availability). --