Enabling or Disabling Event Scheduler

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, the 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.
• 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 Relational Database Service. 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 Relational Database Service. 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.