AnalyticDB:Manage O&M events

Prerequisites

• The cluster must be an AnalyticDB for MySQL Data Warehouse Edition cluster.

• At least one pending O&M event exists.

  Note

  To check for pending O&M events, hover over the icon in the upper-right corner of the console.

Usage notes

• During the switchover for a minor version upgrade event, a Data Warehouse Edition (Elastic mode) cluster in single-node mode is unavailable for read, write, and control operations. Other Data Warehouse Edition clusters support read and write operations but not control operations during the kernel version upgrade. Schedule the upgrade during off-peak hours and make sure your application has a reconnection mechanism.

• For system maintenance events of ApsaraDB such as version upgrades, notifications are typically sent at least three days before execution. For emergency risk remediation events that require an immediate fix, notifications are sent three days or less before execution.

• If you do not configure an event-triggered alert rule or enable message notifications, you will not receive event notifications.

Events

Set up O&M event notifications

You can set up O&M event notifications in the following ways:

• Log on to the CloudMonitor console and set an event-triggered alert rule. For more information, see Set an event-triggered alert rule.

• Log on to Message Center. On the Message Settings > Common Settings page, enable ApsaraDB Fault or Maintenance Notifications and specify the message recipients. Specify database O&M personnel as the recipients.

View pending events

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner, select the region where your cluster resides. In the left-side navigation pane, click Event Center.

2. On the Pending Events page, view the details of pending events. For information about the causes and business impacts of the events, see Events.

Modify scheduled switchover time

You can set a scheduled switchover time only after a pending event is generated. The time applies only to the selected events. After you set a scheduled switchover time, the switchover is automatically performed at the specified time. Because a switchover can cause a transient disconnection, schedule it during off-peak hours.

1. On the Event Center page, in the Scheduled Events list, select one or more events.

2. Click Schedule Event below the Scheduled Events list.

3. In the Schedule Event panel, set the scheduled switchover time.

   To perform the switchover immediately, select Earliest Execution Time. After you confirm the setting, the cluster immediately starts preparing for the switchover. If the preparations are complete by the specified time, the switchover is performed immediately.

   Note

   The Scheduled Switchover Time cannot be later than the Deadline.

Configure recurring time window

A recurring time window applies to all AnalyticDB for MySQL Data Warehouse Edition clusters and does not affect switchover times for other database products. After you configure a recurring time window, the switchover for all pending events without a scheduled time occurs during this window.

For example, if the recurring time is set to 00:00:00 on Tuesday, the minor version upgrade is performed for multiple scheduled clusters at 00:00:00 on Tuesday.

1. On the Event Center page, click Set Global Schedule in the upper-right corner.

2. In the Set Global Schedule panel, you can set a recurring switchover time by Weeks or Months.

   Note

   You can view the configured recurring switchover time above the Scheduled Events list. If no time is displayed, no recurring time window is configured.

3. Click Save.

Cancel scheduled event

Currently, only scheduled Upgrade Minor Version events can be canceled. Select a scheduled Upgrade Minor Version event and clickCancel Event in the upper-left corner.

View historical events

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner, select the region where your cluster resides. In the left-side navigation pane, click Historical Events.

2. On the Historical Events page, view the details of historical events, such as Job ID, Switching Time, and Status.

Related APIs