percona-server icon indicating copy to clipboard operation
percona-server copied to clipboard

Published 20 hours ago • verified publisher icon percona

PS-6002: CREATE/ALTER EVENT STATE TO KEEP ENABLED ON REPLICAS

Open venkatesh-prasad-v opened this issue 2 years ago • 0 comments

https://jira.percona.com/browse/PS-6002

This feature introduces a global config variable --replica-enable-event that accepts the regex patterns of the events in format "db_pattern.event_pattern" for those events that need to be re-enabld after the creation or modification of event on replica server, unlike the current behavior where the replicated events are by default set to the state SLAVESIDE_DISABLED.

The below shall be the behavior when a replicated event matches the pattern specified in the --replica-enable-event.

  1. When an event is created as ENABLED on source, it shall remain ENABLED on replica as well.

  2. When an event is created as DISABLED it shall remain DISABLED on replica as well.

  3. If an event in ENABLED state is altered as DISABLED on source, then it shall become DISABLED on replica as well.

  4. If an event in ENABLED state is altered and if it remains ENABLED on source, then it shall remain ENABLED on replica as well.

  5. If an event in DISABLED state is altered and if it remains DISABLED on source then, shall remain DISABLED on replica as well.

  6. If an event in DISABLED state is altered to ENABLED state on the source server, then it shall become ENABLED on replica as well.

Related approved PR: https://github.com/percona/percona-server/pull/4400

venkatesh-prasad-v avatar Aug 15 '22 12:08 venkatesh-prasad-v