Available in Classic and VPC
NAVER Cloud Platform's Cloud DB for MySQL quickly and easily builds MySQL servers in cloud environments, and operates and manages them to enable a stable database service. 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. Set ACG
6. Test the MySQL Server connection
1. Create an 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. In the NAVER Cloud Platform console, you can create an application server (APP server) by navigating to Menu > Services > Compute > Server.
You can refer to the following user guides:
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 two 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.
You may refer to the following guides:
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 > Services > Database > Cloud DB for MySQL on the NAVER Cloud Platform console.
You can refer to the following user guides:
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 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. Because redundancy is provided through a DNS-based method, no application changes are required.
To configure server redundancy, click and select Support high availability when creating the MySQL Server.
Monitoring and event management
You can monitor server performance and operating system status and review events for running MySQL servers from the NAVER Cloud Platform console to manage database services in a stable manner. You can also utilize NAVER Cloud Platform's Cloud Insight to set up 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 permission 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 permissions by using system-managed and user-created policies in Sub Account on the NAVER Cloud Platform.
Sub Account is a free service with no additional charges. For detailed information about Sub Account and its pricing, 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.
Additional fees apply when you request a subscription to Load Balancer. To access information about Load Balancer introduction and pricing plans, see Services > Storage > Load Balancer on NAVER Cloud Platform portal.
For detailed instructions, see:
5. Set ACG
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 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:
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: