Details
-
Task
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
Description
The documentation about "DISABLE ON SLAVE" option of "CREATE EVENT" statement is unclear, if not wrong.
https://mariadb.com/kb/en/mariadb/create-event/
The documentation states:
Another option is DISABLE ON SLAVE, which prevents slave servers from executing the event.
This suggests that creating an event on a master with DISABLE ON SLAVE option makes event ENABLED on the master and DISABLED on slaves... However, it disables the event everywhere (on master and slaves).
MySQL documentation is a little clearer on this option:
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
A third value may also appear in place of ENABLE or DISABLE; DISABLE ON SLAVE is set for the status of an event on a replication slave to indicate that the event was created on the master and replicated to the slave, but is not executed on the slave.
I think we should mention this (or something like that) to avoid confusion.