Updated on 2024-09-24 GMT+08:00

Enabling or Disabling Event Scheduler

You can enable or disable event scheduler on the GaussDB(for MySQL) console. Read Disclaimer carefully before using it.

Disclaimer

Normal product functions on Huawei Cloud can meet the daily needs of most customers. For trigger-related functions, you are advised to implement them on the business program side. If you do need to enable event scheduler, be aware of the following issues due to known community risks:

  • The actual time for triggering the event scheduler is inconsistent with the configured time.
  • The event scheduler is not triggered.
  • Due to the particularity of the event scheduler, the actual execution may be different from what you expected.
  • The event scheduler may impact analysis and judgment for issues with database usage.
  • Heterogeneous disaster recovery cannot be used.
  • Other unknown issues.

If any of these issues occur, your workloads may be affected.

Constraints

When the instance is being rebooted or its specifications are being changed, event scheduler cannot be enabled or disabled.

Enabling Event Scheduler

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the Instance Information area, click in the Event Scheduler field.

    Figure 1 Enabling event scheduler

  6. In the displayed dialog box, confirm the disclaimer and click Agree and Continue.

    Figure 2 Reading the disclaimer

  7. In the displayed dialog box, confirm the instance information and click OK.

    Figure 3 Confirming information

Disabling Event Scheduler

  1. On the Instances page, click the instance name to go to the Basic Information page.
  2. In the Instance Information area, click in the Event Scheduler field.

    Figure 4 Disabling event scheduler

  3. In the displayed dialog box, click OK.

    Figure 5 Confirming information