Create and attach databases

Quickstarts > 6. Create and attach databases

This learning module will guide you through the basic configuration procedures to create a database and connect it with an application in the NHN Cloud environment. NHN Cloud provides reliable and scalable database services to help users build and operate databases easily and efficiently.

mod_info

Learning objectives

In this learning module, you'll learn to

Utilizing Database Services
- Creating and initializing a database instance
- Accessing databases and working with simple data

mod_diagram

Final configuration diagram

Before you begin

To get started with NHN Cloud, you need to prepare the following things

Standard Internet browser
- You must have the latest version of a browser installed, such as Google Chrome, Microsoft Edge, Firefox, or Safari.
- JavaScript and cookies must be enabled in your browser settings.
Internet connection environment
- A stable internet connection is required, with a recommended bandwidth of at least 5 Mbps.
- You must be able to communicate securely over HTTPS.
Member account
- You must have an NHN Cloud account with a registered payment method.
- You must be logged in to the NHN Cloud portal.
This guide starts after step 5. Configure security.

Create databases and query data

Step 1. Create a MySQL database instance

From the top menu of the NHN Cloud console, select the organization(MyORG), project(MyPRJ), and Korea (Pyeongchon) regionthat you want to use for your lab.
Click Database - MySQL Instancein the left menu of the console window.
Click Create instance.
In the Create instance window, set the information below and click Create instance.
- Instance Templates
  - Enabled: Disabled
- Image
  - Click Public Images > Image Name: Ubuntu Server 20.04 LTS
- Instance information
  - Availability zones: Any availability zone.
  - Instance name: mysql-db-basic
  - Instance type: Select Instance Type > click t2.c1m1 in the instance type name, then click Select
  - Number of instances: 1
  - Keyfair > MyKey
    - To create and use additional keypairs, see the Keypair user guide.
- Root block storage
  - Block storage type: HDD
  - Block storage size (GB): 20 GB
- Network settings: Select Create network interface
- Network
  - Under Available subnets, click the MySubnet (192.168.0.0/24 ) resource to use it as the selected subnet.
- Floating IP: Click Change settings
  - Enabled: Disabled (Default)
- Security groups
  - Click Create security group
  - In the Create security group window, set the information below and click OK.
    - Name: MySG-DB
    - Click + for Add a security rule, and then add a security rule with the following settings
      - Direction: Incoming
      - IP Protocol: My SQL
        
        Select the appropriate IP protocol and the port information is automatically filled in.
        
        [Note] Custom TCP
        
        If you select "Custom TCP" as the IP protocol, you can enter your own port value. Enter 3306 in the field labeled 1.
    - Ether: IPv4
    - Remote: CIDR - 192.168.0.0/24
  - In the Success window, click OK.
  - In the Security group selection, select MySG-DB, which you created above.
- Additional block storage: Disabled (default)
- User script
  - View Script
- Erasure protection: Disabled (default)
In the Instance creation information pane, click Create instance.
The instance creation operation proceeds. The instance will be created in about a minute or so.
After creating the instance, copy and record IP address that is mysql-db-basic.

Step 2. Test database access on a Linux instance

Access the database using the Linux instance linux-server-basicthat you created in Module 4. For instructions on creating and accessing the linux-server-basic instance, see 04-Creating a Network Setup and Instance.

Run a new terminal or PowerShell.
Remotely connect to linux-server-basicwith the command below.

#PowerShell
cd /(name of folder where MyKey.pem file is located)

ssh -i MyKey.pem ubuntu@(Floating IP address of the linux-server-basic instance)

In a remote connection environment, run the command below to install the MySQL-Client tool.

#bash
sudo apt update 
sudo apt install mysql-client -y

Run the command below to see the results in your database.

#bash
export MYSQL_PWD=nhnpassword

mysql --host=(virtual IP address of mysql-db-basic instance) --user=nhncloud -e "SELECT * FROM employees.employees LIMIT 30;"

Verify that the results from the database are retrieved.

References

Previous step

5. Configure security

Next steps

7. Create and attach storage

Create and attach databases
Learning objectives
Before you begin
Create databases and query data
References
Previous step
Next steps

TOP