[MXS-3161] Galera cluster: EVENTs' status ENABLED moved to the Master Created: 2020-09-07 Updated: 2022-09-08 Resolved: 2022-09-08 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | 2.4.12 |
| Fix Version/s: | N/A |
| Type: | New Feature | Priority: | Major |
| Reporter: | Claudio Nanni | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | None | ||
| Description |
|
In Galera Cluster events creation is properly replicated to all nodes. Indeed when executing on any node: ALTER EVENT myEvent ENABLE; The EVENT status on the other nodes will be: SLAVESIDE_DISABLED The question is now if MaxScale should move the ENABLED status to the current Master whenever the Master flag is moved from one node to another. While it is true that there is no data issue if the EVENT only runs on a 'Slave' node, performance wise in case of 'heavy' events we would be changing data on two Galera nodes. So maybe moving the ENABLED status to the current Master is preferrable. Now, if we consider this: https://jira.mariadb.org/browse/MDEV-19165 MaxScale would become actually critical because in case of crash or stop of the Master that needs SST on restart all nodes will have SLAVESIDE_DISABLED for the EVENT. Considering all this, in my opinion, it would be ideal that MaxScale could move the ENABLED status to the Master. Doing such thing should be as easy as: ALTER TABLE myEvent ENABLE; Galera will take care of disabling it on the other nodes. |
| Comments |
| Comment by markus makela [ 2020-09-08 ] |
|
Converted to a New Feature as it's not expected behavior and it's not a Task. |
| Comment by Claudio Nanni [ 2020-09-08 ] |
|
Sure, sorry for the wrong classification. |