Available in Classic and VPC
Cloud DB for MySQL on NAVER Cloud Platform enables you to easily and quickly deploy MySQL Server in a cloud environment. It also helps you operate and manage the database service in a stable manner. The full sequence for utilizing NAVER Cloud Platform's Cloud DB for MySQL is as follows:
Each step is described as follows:
1. Create an application server
2. Configure the connection environment
3. Test the application server connection
4. Create MySQL Server
5. ACG settings
6. Test the MySQL Server connection
7. Create a database
8. Integrate external solutions
1. Create an application server
First, create the application server (App server). This server communicates with the MySQL Server that will be created later in Cloud DB for MySQL. To create an application server, navigate to Menu > All services > Compute > Server in the NAVER Cloud Platform console.
For detailed instructions, see:
2. Configure the connection environment
After you complete the application server creation, configure the connection environment so you can access the application server. There are 2 ways to configure the connection environment:
- Configure access by using port forwarding on the NAVER Cloud Platform (Classic environment)
- Configure access to the private domain using a public IP on the NAVER Cloud Platform (VPC environment)
When you configure access using a public IP, check the administrator (root) password required to access the server by using the Administrator password check feature.
For detailed instructions, see:
SSL VPN makes connecting to MySQL Server more secure. Using SSL VPN is more secure when the server is used for administrative purposes.
3. Test the 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.
For detailed instructions, see:
4. Create MySQL Server
After you complete testing the application server connection, create a MySQL Server that will communicate with the application server. A MySQL Server can be created without a separate service subscription by navigating to Menu > All services > Database > Cloud DB for MySQL on the NAVER Cloud Platform console.
For detailed instructions, see:
Server redundancy configuration
You can configure server redundancy to prevent data loss and minimize service impact in the event of a failure. Cloud DB for MySQL creates both a Master Server and a Standby Master Server. If a failure occurs on the Master Server, it automatically fails over to the standby Master Server, minimizing service downtime.
To configure server redundancy, click and select support high availability when creating the MySQL Server.
Monitoring and event management
You can monitor the performance and operating system status of a running MySQL Server from the NAVER Cloud Platform console and check any events that occur. This allows you to manage the database service in a stable manner. You can also use Cloud Insight to configure events, notifications, and alarms.
Additional fees apply when you subscribe to Cloud Insight. For more information on Cloud Insight introduction and pricing, see Services > Management & Governance > Cloud Insight on the NAVER Cloud Platform portal.
For detailed instructions, see:
Administrative and operational permissions management
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 detailed permissions by using the System Managed policies and User Created policies of Sub Account.
Sub Account is a free service with no additional charges. For detailed information about Sub Account and pricing plans, see Services > Management & Governance > Sub Account on the NAVER Cloud Platform portal.
For detailed instructions, see:
Set read load balancing
You can set the read load balancing of MySQL Server using the Load Balancer of the NAVER Cloud Platform.
Load Balancer is a service with additional charges. For more information about Load Balancer and pricing plans, see Services > Storage > Load Balancer on NAVER Cloud Platform portal.
For detailed instructions, see:
5. ACG settings
Set the Access Control Group (ACG) for a MySQL Server to allow the access of the application server to the created MySQL Server. For detailed instructions, see:
6. Test the MySQL Server connection
Use the MySQL client and test to see if you can properly connect to the created MySQL Server.
For detailed instructions, see:
7. Create a database
You can create a DB in one of the 3 ways below. To prevent misuse of privileges, users are not directly granted permission to create databases. Instead, when a database is created, the account with DDL privileges is granted all permissions on that database.
For detailed instructions, see:
- Create a database via the console
- Create a database using store procedure
- Create a database using Cloud DB for MySQL API
8. Integrate external solutions
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.
For detailed instructions, see: