[MDEV-12284] Unclear documentation about event DISABLE ON SLAVE option Created: 2017-03-16  Updated: 2017-03-23  Resolved: 2017-03-23

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: N/A

Type: Task Priority: Trivial
Reporter: Nicolas Payart Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: event


 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.



 Comments   
Comment by Ian Gilfillan [ 2017-03-23 ]

Clarified in the docs.

Generated at Thu Feb 08 07:56:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.