Getting started

Available in Classic

Getting started with Cloud DB for MySQL describes what you need to do to properly use Cloud DB for MySQL after checking the Cloud DB for MySQL user environment and supported specifications and fully understanding the overall usage quickstart and glossary. The following is the content dealt with in getting started with Cloud DB for MySQL:

• How to create an application server in the NAVER Cloud Platform console.
• How to test application server connection.
• How to create MySQL Servers from the NAVER Cloud Platform console.
• How to test MySQL Server connection.

If you completed the above, then you've completed the basic procedure for using Cloud DB for MySQL. Afterward, you can perform the following tasks for more efficient server management and operation:

• Event and notification (alarm) settings using NAVER Cloud Platform's Cloud Insight.
• Permissions management for using NAVER Cloud Platform's Sub Account.
• Storage of log files and backup files using NAVER Cloud Platform's Object Storage.
• Setting DB server read load balancing using NAVER Cloud Platform's Load Balancer.

The above tasks can be done from Cloud Insight, Sub Account, Object Storage, and Load Balancer after subscribing, rather than in Cloud DB for MySQL. They are not explained in detail in this guide. For detailed instructions, see Cloud Insight user guide, Sub Account user guide, Object Storage user guide, and Load Balancer user guide.

Create an application server

To create an application server from the NAVER Cloud Platform console:

1. Access the NAVER Cloud Platform console.
2. Click Region & Platform at the upper right of the console interface.
3. Select the Region in use and the Classic platform, and then click [Apply].
4. Click Menu at the upper left of the console interface.
5. Navigate to Services > Compute > Server.
6. Click [Create server].
7. Select the server image and click [Next].
8. Enter the required information and click [Next].
9. If you do not have an existing authentication key, then create a new authentication key and click [Next].
10. If you do not have any ACG, create a new one.
11. After the final confirmation, click [Create server].

Configure the connection environment

To configure the server connection environment in the Classic environment of the NAVER Cloud Platform console, you must configure port forwarding.

Configure port forwarding

The following describes how to set port forwarding in Classic:

1. From the Classic environment of the NAVER Cloud Platform console, navigate to Services > Compute > Server.
2. After selecting the server for which you want to configure port forwarding, click [Port Menu > Forwarding settings] menu.********
3. Enter the external port number to configure and click [Add].
   • The available external port range is 1,024–65,534. This external port can be used only for server access.
4. Click [Apply].

Check admin password

To check the administrator (root) password required to access the application server, after configuring port forwarding:

1. From the Classic environment of the NAVER Cloud Platform console, navigate to Services > Compute > Server.
2. Click [Server Management and Settings] and navigate to Menu > Check Administrator Password.
3. Enter the authentication key generated while creating the server.
4. Click [Check password].
5. Check the password.

Test the application server connection

To test connectivity to the application server using the PuTTY terminal program:

1. Run PuTTY.
2. Enter the IP address and port number acquired from the access environment settings for Host Name (or IP address) and Port.
   
3. Click [Open].
4. When the PuTTY Security Alert popup appears, click [Accept].
   
5. When the cmd window for server access appears, enter the password you got from Get admin password.
   

Create MySQL Server

Some of the services provided by NAVER Cloud Platform require you to go through the subscription procedure from the console before the start of actual usage. However, for Cloud DB for MySQL, you can start using it upon creation of a MySQL Server without a separate subscribe step. The following describes how to create a MySQL Server from the NAVER Cloud Platform console:

1. From the NAVER Cloud Platform console, navigate to Services > Database > Cloud DB for MySQL.
2. Click Menu >
   DB Server.********
3. Click [Create DB Server].
4. When the subscribe interface appears, enter the required information and click [Next].
5. Click [Create].

Set ACG

To set the Access Control Group (ACG) for a MySQL server in the NAVER Cloud Platform console:

1. From the NAVER Cloud Platform console, navigate to Services > Database > Cloud DB for MySQL.
2. In the Classic environment of the NAVER Cloud Platform console, navigate to Menu >
   Services > Database > Cloud DB for MySQL.
   
3. Click and select the ACG to set up, and then click [Set ACG].
   • Select the ACG of the MySQL Server automatically created
4. Enter the ACG name of the application server in Access source.
5. Enter the port number in Allowed port.
6. Click [Add].
7. Click [Apply].

Test the MySQL Server connection

The following describes how to test if you can connect properly to the created MySQL Server by installing the MySQL client:

1. Access the application server, run the following commands, and install MySQL.
   • CentOS 6.x or 6.x earlier

   [root@localhost ~] # yum -y install mysql mysql-server
   

   • CentOS 7.x - MySQL 5.7 version

   [root@localhost ~] # yum -y install https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
   [root@localhost ~] # rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
   [root@localhost ~] # yum -y install mysql-community-server
   [root@localhost ~] # mysqld --initialize-insecure --user=mysql
   [root@localhost ~] # systemctl start mysqld
   

   • CentOS 7.x - MySQL 8.0 version

   [root@localhost ~] # yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
   [root@localhost ~] # rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
   [root@localhost ~] # yum -y install mysql-community-server
   [root@localhost ~] # mysqld --initialize-insecure --user=mysql
   [root@localhost ~] # systemctl start mysqld
   

   • Rocky 8.x - 9.x version

   [root@localhost ~] # sudo dnf install -y mysql-server
   [root@localhost ~] # sudo systemctl start mysqld
   

   Note

   • Starting with CentOS 7, the default DB for MySQL installed with yum has changed to MariaDB, so you must run the above command to install it.
   • For MySQL 5.7 version, when restoring with Xtrabackup, you must add innodb_undo_tablespaces = 2 to the [mysqld] part of the my.cnf file before mysqld --initialize-insecure --user=mysql.
2. Access the DB server by executing the following commands.
   • You can check port number, user ID, and password required for DB access from the DB Server menu of the NAVER Cloud Platform console.

   [root@localhost ~] # mysql -h ① Private domain name -u ②user_id -p --port ③DB access port
   
   -- Access success examples
   
   [root@localhost ~] # mysql -h db-gmcp.cdb.ntruss.com -umysql_dba -p --port 3306
   Enter password: **********
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 17199
   Server version: 5.7.19-log MySQL Community Server (GPL)
   
   Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>