Enabling or Disabling Event Scheduler

Scenarios

Event scheduler manages the scheduling and execution of events. The 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 MariaDB resolves this issue. With RDS for MariaDB, even if there is a failover or switchover, the events will still be properly scheduled. You can simply enable or disable the event scheduler on the RDS console.

Notes

• By default, the event scheduler is disabled after a DB instance is created.
• After a primary/standby failover or switchover is performed, the event scheduler 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 scheduler status is the same as that of the original DB instance.
• After a single DB instance is changed to a primary/standby DB instance, the event scheduler status is the same as that of the primary DB instance.

Constraints

Read replicas do not support this function.

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 in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the instance name.
5. In the DB Information area on the displayed Basic Information page, click next to the Event Scheduler field.
   

   After the event scheduler is enabled, reactivate the previously created events to ensure that the event statuses on the primary and standby instances are the same.

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 in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the primary DB instance.
5. In the DB Information area on the displayed Basic Information page, click next to the Event Scheduler field.

FAQs

What Should I Do If I Do Not Have the Permission to Change the event_scheduler Settings?

Answer: You can only enable or disable the event scheduler on the console. For details, see this section.