replication-manager
replication-manager copied to clipboard
Auto skip replication events
This task enable to repair replication on identified patterns ! Example: create temporary table select ... and selected table does not exist on slave
skipping events have in such case no impact for replica state but block replication stream waiting for DBA to skip events
auto_skip_event_trigger=”regexp1,regexp2 ”
auto_skip_event_wait_job = true|false
auto_skip_event_reset_timeout = en second combien de temp de fonctionnement de la repli pour reset le mechanisme ( fin du mode de reparation)
Regexp sur last_error Inject task “repairslave” in job table - Log last_error, relay_query , GTID, Date - Alert - Archive de relay log - https://mariadb.com/kb/en/library/show-relaylog-events/
- mettre en debut de process un event dans la table job et attendre l’execution du job ( snapshot FS ou backup)