Cloud DB for MySQL scenario

Available in Classic and VPC

NAVER Cloud Platform's Cloud DB for MySQL easily and quickly builds MySQL Servers in cloud environments, and operates and manages them to enable stable cache service. The full sequence for utilizing NAVER Cloud Platform's Cloud DB for MySQL is as follows.

The descriptions for each step is as follows.

1. Create application server
2. Set access environment
3. Test application server connection
4. Create MySQL Server
5. Set ACG
6. Test MySQL Server connection

1. Create application server

First, create an application server (app server) that will communicate with the MySQL Server to be created from the Cloud DB for MySQL of the NAVER Cloud Platform console. The application server (app server) can be created from the Services > Server menu of the NAVER Cloud Platform console.
You can refer to the following guides:

• Create Server

2. Set access environment

Once you've completed creating an application server, set up an access environment so that users can access the application server. You have two ways of setting the access environment, which are described as follows:

• Set up access using the port forwarding of NAVER Cloud Platform (Classic environment)
• Set up access to a private domain using the public IP of NAVER Cloud Platform (VPC environment)
  For access settings using the public IP, you need to check the admin (root) password required for the server access, using the Get admin password feature.

You can refer to the following guides:

• Checking server information and managing server guide

3. Test application server connection

Once you complete setting up the access environment, use the terminal program to test if you can connect to the application server properly.
You can refer to the following guides:

• Getting started with Cloud DB for MySQL
• Download terminal program (PuTTY)

4. Create MySQL Server

After you complete testing the application server connection, create a MySQL Server that will communicate with the application server. The MySQL Server can be created from the Services > Database > Cloud DB for MySQL menu of the NAVER Cloud Platform console without a separate service subscription request.
You can refer to the following guides:

• Getting started with Cloud DB for MySQL

Server redundancy configuration

To prevent data loss and minimize service impact if failures occur, you can set server redundancy. When you create an active master server and a standby master server, Cloud DB for MySQL provides a feature that performs an automatic failover to the standby master server when a failure occurs in the master server. Since the redundancy is provided in the DNS method, no additional application change is required.

To configure server redundancy, click and select Support high availability when creating the MySQL Server.

Manage monitoring and events

For MySQL Servers that have been created and are in operation, you can check monitoring for server performance and operating system status as well as events that occurred, and manage them for stable cache service from the NAVER Cloud Platform console. You can also utilize the NAVER Cloud Platform's Cloud Insight to configure event and notification settings.

You can refer to the following guides:

• Monitoring
• Event

Manage management and administration permissions

You can create sub accounts in addition to the main user account, and set various management and administration permissions for Cloud DB for MySQL. You can design permissions by utilizing the System Managed and User Created policies in the NAVER Cloud Platform's Sub Account.

You can refer to the following guides:

• Managing Sub Account permissions

Set read load balancing

You can utilize the NAVER Cloud Platform's Load Balancer to configure read load balancing of MySQL Servers.

You can refer to the following guides:

• Set read load balancing

5. Set ACG

Set the ACG (Access Control Group) for the MySQL Server to allow the access of the application server to the created MySQL Server.
You can refer to the following guides:

• ACG settings guide

6. Test MySQL Server connection

Use the MySQL client and test to see if you can properly connect to the created MySQL server.
You can refer to the following guides:

• Getting started with Cloud DB for MySQL