Help Center > > User Guide> Working with RDS for MySQL> Database Management> Enabling or Disabling Event Scheduler

Enabling or Disabling Event Scheduler

Updated at: Apr 20, 2020 GMT+08:00

Scenarios

Event scheduler manages the scheduling and execution of events. The MySQL built-in event scheduler cannot guarantee the consistency of event statuses between primary and standby DB instances. If a failover or switchover occurs, events will not be scheduled. RDS for MySQL resolves this issue. With RDS for MySQL, even if there is a failover or switchover, event status will still be properly scheduled. You can simply enable or disable the event scheduler on the RDS console.

  • By default, the event scheduler is disabled after a DB instance is created.
  • After a primary/standby failover or switchover, the event status remains unchanged. The event_scheduler is on for the original primary DB instance and off for the original standby DB instance.
  • After a restoration to a new DB instance, the event status is the same as that of the original DB instance.
  • After a single DB instance is changed to primary/standby DB instances, the event status is the same as that of the primary DB instance.

Constraints

  • Only MySQL kernel 5.6.43.2, 5.7.25.2, and later versions are supported. If your database version does not meet this requirement, you can upgrade the minor version by referring to Upgrading the Minor Version to use this function.
  • Event scheduler cannot be enabled for read replicas.

Enabling Event Scheduler

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target primary/standby DB instances.
  5. In the DB Information area on the displayed Basic Information page, click in the Event Scheduler field.

    After you enable the event scheduler on the RDS console, log in to the DB instance and check that the event status has been set to enable

Disabling Event Scheduler

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target primary/standby DB instances.
  5. In the DB Information area on the displayed Basic Information page, click in the Event Scheduler field.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel