AnalyticDB for MySQL lets you manage O&M events, such as minor version upgrades. You can set notifications for O&M events, view event details such as task IDs, switchover times, and statuses in the console, and manually change the switchover time for pending events. This topic describes how to manage O&M events.
Prerequisites
An AnalyticDB for MySQL Data Warehouse Edition cluster is created.
A pending O&M event exists.
NoteTo check for pending O&M events, you can hover over the
icon in the upper-right corner of the console.
Usage notes
During the switchover for a minor version upgrade event, Data Warehouse Edition (Elastic mode) Basic Edition clusters are unavailable and do not support read, write, or control operations. Other Data Warehouse Edition clusters can perform read and write operations but cannot perform control operations when the kernel version is upgraded. 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 3 days in advance. For emergency threat remediation events that require immediate fixes, notifications are typically sent 3 days or less in advance.
If you do not set an event-triggered alert rule or enable message notifications, you will not receive the corresponding notifications.
Event description
Event type | Event switchover time | Event impact |
Minor version upgrade | The scheduled switchover time applies to a specific event, and the periodic switchover time applies to an AnalyticDB for MySQL cluster. 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 set. If neither a scheduled nor a periodic switchover time 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 Message Subscriptions > Basic Subscriptions page, turn on the ApsaraDB Failure Or O&M Notification switch and set the message recipients. We recommend that you set your database O&M personnel as the 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 Pending Events page, you can view the details of each event. For information about the causes and business impacts of the events, see Event description.
Change the scheduled switchover time
You can set a scheduled switchover time only after a pending event is created. The scheduled switchover time applies only to the event or events that you select. After you set a scheduled switchover time for an event, the switchover is automatically performed at the specified time. An event switchover causes a transient disconnection. Ensure that the scheduled switchover time is during off-peak hours.
In the Event Center, on the Scheduled Events tab, select one or more target events.
Below the Planned Event list, click Configure Scheduled Time.
In the Configure Scheduled Time panel, set the scheduled switchover time.
To perform the switchover at the earliest possible time, select Set Earliest Execution Time. After you confirm this setting, the cluster immediately begins to prepare for the switchover. The switchover is performed at the specified time if the preparation is complete.
NoteThe Planned switchover time must be on or before the Latest operation time.
Configure a periodic switchover time
A periodic switchover time applies to all AnalyticDB for MySQL Data Warehouse Edition clusters and does not affect the switchover time of O&M events for other database products. After you configure a periodic switchover time, switchovers are performed at the specified time for all scheduled events that have not yet been performed and for which no individual scheduled switchover time is set.
For example, if you set the periodic switchover time to 00:00:00 on Tuesday, the minor version upgrades for multiple scheduled clusters are performed at 00:00:00 on Tuesday.
On the Event Center page, click Configure Periodic Time in the upper-right corner.
In the Configure Periodic Time panel, you can set the periodic switchover time by Week or Month.
NoteThe configured periodic switchover time is displayed above the Planned Event list. If no time is displayed, a periodic switchover has not been scheduled.
Click OK.
Cancel a scheduled configuration
Currently, only Minor Version Upgrade events can be canceled. To cancel an upgrade, select a Minor Version Upgrade event and click Cancel Scheduled Configuration in the upper-left corner.
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, you can view event details, such as Job ID, Switching Time, and Status.
Related APIs
API | Description |
DescribeMaintenanceAction - Retrieves the details of a maintenance event | Queries the details of an O&M event. |
Modifies the switchover time of a pending O&M event. |