Add and manage DB instances

Prev Next

Available in Classic and VPC

Add and manage DB instances describes how to add, edit, and delete DB instances.

Add DB instance

To add DB instances:

Note
  • To add DB instances, there must be policies that have not been applied to other DB instances or other works. Create a new policy if you haven't created one or if all existing policies are in use.
  • You can add a DB instance only when the resource status is in Created.
  1. From the NAVER Cloud Platform console, navigate to i_menu > Services > Storage > Backup.
  2. Click the Resource menu.
  3. From the resource list, click the resource where you want to add a DB instance.
  4. Click [Add DB instance] for the type of DB instance you want to add.
  5. If the Add DB instance popup window appears, enter the information as follows on the DB instance type and click [Save]:
  6. Check the information on the popup window, click [OK].
    • The DB instance displays the status of Creating, and after the creation, the status changes to Created.

MSSQL

To add MSSQL DB instances, enter the following information:

Note

The ID and password are only used for adding DB instances.

  • DB instance name: Enter the server name of SQL Server Manager Studio.
    • The name should start with an English letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
  • Policy: Select the policy you want to apply for the DB instance.
    • By clicking [Create policy], you can create a new policy.
  • ID: Enter the server ID to add DB instances.
    • The name should start with an English letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
    • Enter the ID that belongs to Administrator group with the sysadmin permission. Use the Windows authentication mode to access MSSQL servers.
  • Password: Enter the server password to add DB instances.
  • Data Directory: Enter the data route of MSSQL Database Default Location.
Note
  • Click Security > Logins > Properties > Server Roles on SQL Server Management Studio in order to view whether the sysadmin permission is set. When the sysadmin check box is unchecked, click the check box and [OK].
  • To view Data Directory:
    1. Access the SQL server by starting SQL Server Management Studio.
    2. Right-click the server name on Object Explorer, and click the Properties button.
    3. When the Server Properties popup window appears, click Database Settings.
      • Enter the Data value of Database default locations into Data Directory.
        backup-db_mssql2

MySQL

To add MySQL DB instances, enter the following information:

Note
  • To backup a log of MySQL server, activate the binary logging.
  • The ID and password are only used for adding DB instances.
  • DB instance name: Enter a unique name for managing the remote DB.
    • The name should start with an English letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
  • Policy: Select the policy you want to apply for the DB instance.
    • By clicking [Create policy], you can create a new policy.
  • ID: Enter the DB account to add DB instances.
    • The name should start with an English letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
    • Enter the account ID with the sys permission.
  • Password: Enter the password of the DB account to add DB instances.
  • Binary directory: Enter the path to binary execution file of MySQL.
    • Example: /usr/bin/
  • Log directory: Enter the path to the binary log file of MySQL.
    • Example: var/lib/mysql
  • Config file: Enter the path to the file where the MySQL server configuration has been defined.
    • Example: /etc/my.cnf and /etc/mysql/my.cnf
  • Socket file: Enter the path to the socket file used for the communication between MySQL server and the client when the server OS is Linux.
    • Example: /var/run/mysqld/mysqld.sock
  • Port: Enter the server access port number when the server OS is Windows.

PostgreSQL

To add PostgreSQL DB instances, enter the following information:

Note
  • To backup the logs of PostgreSQL server, activate the binary logging.
  • The ID and password are only used for adding DB instances.
  • DB instance name: Enter a unique name for managing the remote DB.
    • The name should start with an English letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
  • Policy: Select the policy you want to apply for the DB instance.
    • By clicking [Create policy], you can create a new policy.
  • ID: Enter the server ID to add DB instances.
    • The name should start with an English letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
    • When adding PostgreSQL DB instances, enter the postgres account ID with the admin permission.
  • Password: Enter the server password to add DB instances.
  • Maintenance DB: Enter postgres.
  • Binary directory: Enter the path to binary execution file of PostgreSQL.
    • Example: /usr/bin/
  • Library directory: Enter the path to the library file used by PostgreSQL server.
    • Example: /usr/pgsql-13/lib
  • Archive log directory: Enter the path to the archive log file created on PostgreSQL.
    • Example: /var/lib/pgsql/13/data/pg_wal
  • Port: Enter the server access port number.

Edit DB instance

To edit the information of DB instances:

  1. In the NAVER Cloud Platform console, navigate to i_menu > Services > Storage > Backup.
  2. Navigate to Backup > Resource.
  3. From the resource list, click the resource with the added DB instance where you want to edit the information.
  4. Click the [Edit] button of the DB instance where you want to edit the information.
  5. After editing the information of the DB instance, click [Save].

Delete DB instance

To delete DB instances:

Caution

Once a DB instance is deleted, all the data and records related to the DB instance disappear. As deleted data cannot be recovered, take careful consideration before deleting them.

  1. In the NAVER Cloud Platform console, navigate to i_menu > Services > Storage > Backup.
  2. Navigate to Resource.
  3. From the resource list, click the resource with the added DB instance you want to delete.
  4. Click the [Delete] button of the DB instance you want to delete.
  5. Check the DB instance deletion popup window. Click the check box, and click the [Delete] button.
    • The DB instance is displayed as Deleting, and after the deletion is completed, the information of the DB instance disappears from the agent list.