DB instance addition and management
    • PDF

    DB instance addition and management

    • PDF

    Article Summary

    Available in Classic and VPC

    DB instance addition and management describes how to add, edit, and delete DB instances.

    Add DB instance

    To add DB instances, follow these steps:

    Note
    • To add DB instances, there must be policies that have not been applied to other DB instances or other works. If a new policy has not been created or all the policies have been in use, create a policy first.
    • The addition of DB instance is possible only when the resource is in completion of creation.
    1. Click the environment you are using in the Region menu and the Platform menu on the NAVER Cloud Platform console.
    2. Click Services > Storage > Backup, in order.
    3. Click Backup > Resource in order.
    4. From the resource list, click the resource where you want to add a DB instance.
    5. Click the [DB instance addition] button for the type of DB instance you want to add.
    6. If the DB instance addition popup window comes up, enter the information as follows on the DB instance type and click the [Save] button:
    7. After you view the popup window, click the [View] button.
      • The DB instance displays the status of creating, and after the creation, the status changes to creation completed.

    MSSQL

    To add MSSQL DB instances, enter the following information:

    Note

    The ID and password are only used for the addition of DB instances.

    • DB instance name: enter the server name of SQL Server Manager Studio
      • The name should consist of lowercase letters, numbers, and hyphens (-); must start with an English letter. The total length must be from 3-30 characters.
    • Policy: select the policy you want to apply for the DB instance
      • By clicking the [Create policy] button, you can create a new policy.
    • ID: enter the server ID to add DB instances
      • The ID should consist of lowercase letters, numbers, hyphens (-), and underscores (_); must start with an English letter. The total length must be from 4-16 characters.
      • Enter the ID that belongs to Administrator group with the sysadmin authority. 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 to hold the sysadmin authority. When the sysadmin check box unchecked, click the check box and the [OK] button.
    • To view Data Directory, follow these steps:
      1. Access the SQL server by operating SQL Server Management Studio.
      2. Click the server name on Object Explorer with the right button on the mouse, and click the Properties button.
      3. When the popup window of Server Properties comes up, click the 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 the addition of DB instances.
    • DB instance name: enter the original name that works as the standard for DB instance management
      • The name should consist of lowercase letters, numbers, and hyphens (-); must start with an English letter. The total length must be from 3-30 characters.
    • Policy: select the policy you want to apply for the DB instance
      • By clicking the [Create policy] button, you can create a new policy.
    • ID: enter the server ID to add DB instances
      • The ID should consist of lowercase letters, numbers, hyphens (-), and underscores (_); must start with an English letter. The total length must be from 4-16 characters.
      • Enter the account ID with the OS admin authority.
    • Password: enter the server password to add DB instances
    • Binary directory: enter the binary executable file of MySQL
      • <example> /usr/bin/
    • Log directory: enter the route to the Binary log file of MySQL
      • <example> /var/lib/mysql
    • Config file: enter the route to the file where the setup of MySQL server has been defined
      • <example> /etc/my.cnf, /etc/mysql/my.cnf
    • Socket file: enter the route 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 log of PostgreSQL server, Activate the binary logging.
    • The ID and password are only used for the addition of DB instances.
    • DB instance name: enter the original name that works as the standard for DB instance management
      • The name should consist of lowercase letters, numbers, and hyphens (-); must start with an English letter. The total length must be from 3-30 characters.
    • Policy: select the policy you want to apply for the DB instance
      • By clicking the [Create policy] button, you can create a new policy.
    • ID: enter the server ID to add DB instances
      • The ID should consist of lowercase letters, numbers, hyphens (-), and underscores (_); must start with an English letter. The total length must be from 4-16 characters.
      • When adding PostgreSQL DB instances, enter the postrgres account ID with the admin authority.
    • Password: enter the server password to add DB instances
    • Maintenance DB: enter postgres
    • Binary directory: enter the route to Binary executable file of PostgreSQL
      • <example> /usr/bin/
    • Library directory: enter the route to the library file used by PostgreSQL server
      • <example> /usr/pgsql-13/lib
    • Archive log directory: enter the route 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, follow these steps:

    1. Click the environment you are using in the Region menu and the Platform menu on the NAVER Cloud Platform console.
    2. Click Services > Storage > Backup, in order.
    3. Click Backup > Resource in order.
    4. From the resource list, click the resource with the added DB instance that needs information edition.
    5. Click the [Edit] button of the DB instance whose information you want to edit.
    6. After editing the information of the DB instance, click the [Save] button.

    Delete DB instance

    To delete DB instances, follow these steps:

    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 considerations and delete them.

    1. Click the environment you are using in the Region menu and the Platform menu on the NAVER Cloud Platform console.
    2. Click Services > Storage > Backup, in order.
    3. Click Backup > Resource in order.
    4. From the resource list, click the resource with the added DB instance you want to delete.
    5. Click the [Delete] button of the DB instance you want to delete.
    6. View the popup window of the DB instance deletion. Click the check box, and click the [Delete] button.
      • The DB instance is in the status of deleting, and after the deletion, the information of the DB instance disappears from the agent list.

    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.