[MXS-1639] Perform SQL statements prior to client operations during failover Created: 2018-01-30  Updated: 2020-08-25  Resolved: 2018-04-24

Status: Closed
Project: MariaDB MaxScale
Component/s: Monitor
Affects Version/s: 2.2.0
Fix Version/s: 2.2.5

Type: New Feature Priority: Minor
Reporter: Kyle Joiner (Inactive) Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-56

 Description   

Provide a mechanism to perform SQL statements to a master prior to allowing client connections after promotion when performing a failover. This will allow to change the value of log_slave_updates or enabling triggers and events.



 Comments   
Comment by Johan Wikman [ 2018-04-18 ]

A limited version will be made available in 2.2.5. A more versatile one in 2.3.

Comment by Richard Lane [ 2018-04-18 ]

I assume that the "limited" version will still leave no windows where the repliation_ignore_tables would not be done before replication starts when a server goes Master?

Comment by Johan Wikman [ 2018-04-26 ]

Limited meant only that we will not make the functionality very configurable or provide means for handling things intelligently in case some intermediate steps in the executed SQL statements fail.

Sorry for the long delay in the answer.

Generated at Thu Feb 08 04:08:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.