← Back to team overview

maria-discuss team mailing list archive

Re: "Rewind" type of mechanisms?


 Thank you!

> "You can automatically resync either with gtid based async replication"

Few questions:
resync automatically --> Does it remove a possible (obsolete) rogue row?
How long task is such resyncing operation? --> Does it "recreate" the whole DB node?
Best Regards
    On Friday, August 19, 2022 at 12:23:03 PM GMT+3, Gordan Bobic <gordan.bobic@xxxxxxxxx> wrote:  
 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. <samruohola@xxxxxxxxx> wrote:
> Hi!
> I would like to know about following topic regarding MariaDB.
> We would like to run DB cluster with HA (high availability). -- E.g. with MaxScale.
> My Q:
> Does MariaDB support such mechanism which would be similar to pg_rewind? Reference: PostgreSQL supports such a rewind operation.
> Or, are there plans to support such regarding MariaDB?
> ( If such would be needed / useful. )
> Rewind: "A typical scenario is to bring an old primary server back online after failover as a standby that follows the new primary."
> Target: robustness/stability of a DB cluster. Avoiding needs to manually fix DB cluster.
> Best Regards
> Sam
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to    : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help  : https://help.launchpad.net/ListHelp

Follow ups