Cloud DB for MySQL scenarios

Available in Classic and VPC

NAVER Cloud Platform's Cloud DB for MySQL easily and quickly builds MySQL Server 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 are 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 MySQL Server to be created from Cloud DB for MySQL on the NAVER Cloud Platform console. The application server (APP server) can be created from the > Services > Compute > Server menu on the NAVER Cloud Platform console.
You can refer to the following user 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 2 ways of setting the access environment, which are described as follows:

• Access settings using port forwarding of the NAVER Cloud Platform (Classic)
• Set up access to Private Domain using an public IP of the NAVER Cloud Platform (VPC)
  When setting up access using an public IP, you must check the administrator (root) password required to access the server, using the Get amin password feature.

You can refer to the following user guide:

• Get server information and server management 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 on the NAVER Cloud Platform console without a separate service subscription request.
You can refer to the following user guides:

• Getting started with Cloud DB for MySQL

Server redundancy configuration

To prevent data loss and minimize service impact in occurrence of failures, you can set server redundancy. Cloud DB for MySQL creates a Master Server and a Standby Master Server, which automatically Fails over to a Standby Master Server in the event of a Master Server failure. As the redundancy is provided with 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 event

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 occurred events, and manage them for stable cache service from NAVER Cloud Platform console. You can also utilize NAVER Cloud Platform's Cloud Insight to set up events, notifications, and alarms.

You can refer to the following user guide:

• 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 NAVER Cloud Platform's Sub Account.

You can refer to the following user guide:

• Managing Sub Account permissions

Set read load balancing

You can set the read load balancing of MySQL Server using the Load balancer of the NAVER Cloud Platform.

You can refer to the following user guide:

• Set read load balancing

5. Set ACG

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

• 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 user guide:

• Getting started with Cloud DB for MySQL

7. Create database

You can create a DB in one of the 3 ways below. To prevent problems caused by misuse of permissions, we do not grant users the permission to create DB directly. When creating a DB, an account with DDL permissions will have full control over the created database.
You can refer to the following user guide:

• Create a database through the console
• Create a database using stored procedure
• Create a database using Cloud DB for MySQL API

8. External solution integration

You can integrate external solutions such as Zero Board, GNU Board, and so on. You can also use InnoDB as the storage engine during installation. If you require a different storage engine, consider using the MySQL installation-type service.
You can refer to the following user guide:

• MySQL installation-type service