AnalyticDB for MySQL supports the management of O&M events, such as minor version upgrades. You can set O&M event notifications, view event details such as the task ID, switchover time, and event status in the console, and manually change the switchover time for pending events. This topic describes how to manage O&M events.
Prerequisites
The AnalyticDB for MySQL cluster is Data Warehouse Edition.
A pending O&M event exists.
NoteTo check for pending O&M events, hover over the
icon in the upper-right corner of the console.
Usage notes
During a minor version upgrade switchover, Data Warehouse Edition (Elastic mode) Basic Edition clusters become unavailable and cannot perform read, write, or control operations. Other Data Warehouse Edition clusters support read and write operations but not control operations during kernel version upgrades. Perform upgrades during off-peak hours and ensure that your application has a reconnection mechanism.
For ApsaraDB system maintenance events, such as version upgrades, notifications are typically sent at least three days before execution. For emergency threat remediation events that require immediate fixes, notifications are usually sent three days or less before execution.
If you do not set an event-triggered alert rule or enable message notifications, you will not receive related notifications.
Event description
Event type | Event switchover time | Event impact |
Minor version upgrade | The scheduled switchover time applies at the event level, and the periodic switchover time applies at the AnalyticDB for MySQL cluster level. The scheduled switchover time takes precedence over the periodic switchover time. If a scheduled switchover time is set for an event, the switchover occurs at that time regardless of whether a periodic switchover time is configured. If neither is configured, the switchover occurs by default during the cluster’s maintenance window. | For more information, see Upgrade impacts. |
Instance migration (underlying infrastructure replacement and upgrade) |
|
Set O&M event notifications
You can set O&M event notifications in either of 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 page, turn on the ApsaraDB Fault or Maintenance Notifications switch and set message recipients. We recommend that you set database O&M personnel as recipients.
View pending events
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select the region where your cluster is located. In the navigation pane on the left, click Event Center.
On the Scheduled Events page, view detailed information about pending events. For information about event causes and business impacts, see Event description.
Change the scheduled switchover time
You can set a scheduled switchover time only after a pending event is generated. The scheduled switchover time applies only to the selected event or events. After you set the scheduled switchover time, the event is automatically triggered at that time. Because an event switchover causes a transient disconnection, ensure that the scheduled switchover time is during off-peak hours.
On the Event Center page, in the Scheduled Events list, select one or more target events.
Below the Scheduled Events list, click Modify Scheduled Event.
In the Modify Scheduled Event panel, set the scheduled switchover time.
To execute the switchover immediately, click Execute Immediately. After confirmation, the cluster immediately begins switchover preparation.
NoteThe Scheduled Switchover Time cannot be later than the Deadline.
Configure a periodic switchover time
A periodic switchover time applies to all AnalyticDB for MySQL Data Warehouse Edition clusters and does not affect O&M event switchover times for other database products. After you configure a periodic switchover time, all scheduled events that have not been executed and do not have an individual scheduled switchover time are triggered at the specified periodic time.
For example, if you set the periodic switchover time to 00:00:00 on Tuesday, minor version upgrades for multiple scheduled clusters occur simultaneously at 00:00:00 on Tuesday.
On the Event Center page, click Recurring Time Window Settings in the upper-right corner.
In the Recurring Time Window Settings panel, set the periodic switchover time by Week or Month based on your business needs.
NoteThe configured periodic switchover time appears above the Scheduled Events list. If no time appears, you have not configured a periodic switchover time.
Click Save.
Cancel a scheduled configuration
Currently, only scheduled Minor Version Update events can be canceled. To cancel a scheduled Minor Version Update event, select the event and click Cancel Scheduled Event below the Scheduled Events list.
View historical events
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select the region where your cluster is located. In the navigation pane on the left, click Historical Events.
On the Historical Events page, view event details such as Task ID, Switching Time, and Status.
Related APIs
API | Description |
DescribeMaintenanceAction - Queries the details of an O&M event | Queries the details of an O&M event. |
Modifies the switchover time of a pending O&M event. |