Event

Available in Classic and VPC

In Event, you can check the history of events that occurred in the Cloud DB for MySQL server. The events that occur in MySQL are saved automatically in the history and stored permanently without requiring additional settings by the user. If you create events by setting notification items and thresholds for each MySQL Server, then you can emails and SMS notifications when the events occur.

Event page (VPC)

The basics of using events in the VPC environment are as follows.

Event page (Classic)

The basics of using events in the Classic environment are as follows.

Check events (VPC)

The following describes how to check the events that occurred in the MySQL Server of the VPC environment.

1. From the NAVER Cloud Platform console's VPC environment, click the Services > Database > Cloud DB for MySQL menus, in that order.
2. Click the Event menu.
3. When the event list appears, check the required information.
   • DB Server name: Name of the MySQL Server where the event occurred
   • Event occurrence time: Time when the event occurred
   • Event type: Type of the event that occurred
   • Event name: Name of the event that occurred
     • DB: Events that occurred in DB
     • Backup: Start or end events of backup
     • Storage Size: Change of storage size
     • Failover: Events that occurred upon failover
   • Content: Description of the event that occurred
   • Access IP: Access IP address of the admin account where the event occurred
4. If the event type is DB Server, then click it to see the details.
   
   • DB service name: Service name of the MySQL Server
   • DB status: Status of the MySQL Server in operation
   • DB role: Role of the MySQL Server in operation
   • Creation date: Date that MySQL Server in operation was created
   • DB engine version: DB engine version

Check events (Classic)

The following describes how to check the events that occurred in the MySQL Server of the Classic environment.

1. From the NAVER Cloud Platform console's Classic environment, click the Services > Database > Cloud DB for MySQL menus, in that order.
2. Click the Event menu.
3. Click the Event History tab, and check the necessary information when the event list appears.
   • DB Server name: Name of the MySQL Server where the event occurred
   • Event occurrence time: Time when the event occurred
   • Event type: Type of the event that occurred
   • Event name: Name of the event that occurred
     • DB: Events that occurred in DB
     • Backup: Start or end events of backup
     • Storage Size: Change of storage size
     • Failover: Events that occurred upon failover
   • Content: Description of the event that occurred
   • Access IP: Access IP address of the admin account where the event occurred
4. If the event type is DB Server, then click it to see the details.
   
   • DB service name: Service name of the MySQL Server
   • DB status: Status of the MySQL Server in operation
   • DB role: Role of the MySQL Server in operation
   • Creation date: Date that MySQL Server in operation was created
   • DB engine version: DB engine version

Set events (VPC)

You can utilize the NAVER Cloud Platform's Cloud Insight to specify event rules of MySQL Server in the VPC environment, and set notifications.

Set event rules (VPC)

If you use Cloud Insight, NAVER Cloud Platform's service specialized for monitoring, then you can set more detailed event rules for MySQL Servers and monitor them. The events collected by the rules set by the user can be checked from the Cloud Insight dashboard.

Please refer to the Cloud Insight Guide for information on setting event rules for MySQL Servers and checking them on the dashboard in Cloud Insight.

Basic metric indicators

The basic metric indicators that can be checked from the MySQL Server dashboard of Cloud Insight are as follows.

Custom schema configuration items

The metric event monitoring items that can be configured in the Custom schema menu of Cloud Insight are as follows.

Notification settings (VPC)

By using Cloud Insight, NAVER Cloud Platform's service specialized for monitoring, if you have set event rules for MySQL Servers, then you can set thresholds for specific rules and set email and SMS notifications to predetermined users when the thresholds are exceeded.

Please refer to the Cloud Insight Guide for information on setting notifications for event rules by MySQL Server in Cloud Insight.

Set events (Classic)

You can set events so that users can be notified when a specified situation occurs in the MySQL Server.

Set events

You specify event rules and set notifications for each MySQL Server in the NAVER Cloud Platform console.

The following describes how to set up events of a MySQL Server in the Classic environment.

1. From the NAVER Cloud Platform console's Classic environment, click the Services > Database > Cloud DB for MySQL menus, in that order.
2. Click the Event menu.
3. Click the Event settings status tab, and then click the MySQL Server you want to set events for.
4. Click the [Set events] > [Set event items] buttons, in that order.
5. Select an item by referring to the table shown below, enter the threshold that will cause notifications, and then click the [Add] button.
   
   
   

   Notification item	Detailed notification item	Description
   CPU	① Used(%) ② Iowait(%)	① CPU usage ② CPU IOwait usage
   Memory	Used(%)	Memory usage
   Swap	swap_pct	Generated swap memory
   Disk I/O	① Read kbytes ② Write kbytes	① Disk read actions ② Disk write actions
   Load Average	1min, 5min, 15min	Server load
   Filesystem	Used(kByte)	Disk usage
   Connections	Running	Number of MySQL Server access sessions
   SlowQuery	SlowQueryCount	Number of queries executed for 1 second or longer
   Replication	① Stop ② Delay	① Replication suspension information ② Replication latency against the master
   DB	Down	DB down information

   • You can modify or delete the added events by clicking the [Modify] or [Delete] button.
6. Click the [Next] button.
7. Add the recipient for occurred notifications, select the notification method, and then click the [Add] button.
   
   • You can modify or delete the added events by clicking the [Modify] or [Delete] button.
8. Click the [Next] button, check the settings, and then click the [OK] button.
   

Manage events

You can check the content and notification recipients of the set events, suspend or restart notifications, or remove events.

Remove events

The following describes how to remove set events.

1. From the NAVER Cloud Platform console's Classic environment, click the Services > Database > Cloud DB for MySQL menus, in that order.
2. Click the Event menu.
3. Click the Event settings status tab, and then click the MySQL Server you want to remove events from.
4. Remove events as shown below.
   • Delete individual events: From the event list displayed under the row of the selected MySQL Server, find the event you want to delete, click the [Delete] button, and then click the [Yes] button from the confirmation pop-up window.
   • Delete all events from the server: Click the [Remove events] button, and then click the [Yes] button from the confirmation pop-up window.

Manage notifications

You can check the notification recipients for the occurrence of event notifications, and suspend or restart notifications. If you suspend notifications, then the notifications are not sent, even when the events occur for the set period.

You can manage notifications as follows.

1. From the NAVER Cloud Platform console's Classic environment, click the Services > Database > Cloud DB for MySQL menus, in that order.
2. Click the Event menu.
3. Click the Event settings status tab, and then click the MySQL Server you want to check event notifications for.
4. Manage event notifications settings as shown below.
   • Manage notification recipients: Click the [View] button of the selected MySQL Server's row, and manage notification recipients from the settings pop-up window.
   • Suspend notifications: Click the [Suspend notifications] button, enter the period and the registrant, and then click the [Set] button.
   • Restart notifications: Click the [Restart notifications] button, and then click the [Yes] button from the confirmation pop-up window.