The page has been translated by Gen AI.

Add Secondary

The user can enter the required information for Secondary through the Samsung Cloud Platform Console and create the service using detailed options.

Add Secondary

Through secondary configuration, you can create replica servers for read‑only or disaster‑recovery purposes. To add a Secondary, it must be created with HA redundancy configuration and Enterprise Edition, and the backup feature must be enabled.

Information
To configure a disaster recovery Secondary, please create it through Secondary Configuration (Other Region).

To set up Secondary, follow these steps.

  1. Click the All Services > Database > Microsoft SQL Server(DBaaS) menu. 1. Navigate to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Go to the page.
  3. Microsoft SQL Server(DBaaS) List On the page, click the resource to configure Secondary. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the Add Secondary button. 4. Go to the Secondary Add page.
  5. After entering information in the Secondary configuration area, click the Create button.
    Category
    Required status
    Detailed description
    RegionRequiredRegion to configure Secondary (DR)
    • Secondary configuration (Other Region) shown only when selected
    Secondary numberRequiredNumber of Secondary to configure
    • Only one can be configured per cluster
    Secondary nameRequiredSecondary server name
    • must start with a lowercase English letter, and using lowercase letters, numbers, and special characters (-) be entered with 3 ~ 15 characters
    • The entered Secondary name is displayed as the cluster name in the list
    Service Type > Server TypeRequiredSecondary server type
    • Apply the same as the server type set in the source DB
    Service Type > Planned ComputeSelectionStatus of resources with Planned Compute configured
    • In Use: Number of resources with Planned Compute configured that are currently in use
    • Configured: Number of resources with Planned Compute configured
    • Coverage Preview: Amount applied by Planned Compute per resource
    Network > Common SettingsEssentialNetwork settings where the servers created by the service are installed
    • applied identically to the network settings configured in the original DB
    Network > Server SettingsRequiredNetwork settings for servers created in the service
    • Select when you want to apply different settings per installed server
    • Apply the same as the network settings configured in the original DB
    • When setting per server 10.10.10.0/24 enter an IP address within the range
    LicenseRequiredSQL Server License Key
    • Enter the issued license key.
    • If the entered license key is invalid, the service may not be created.
    AD(Active Directory)SelectionEnter AD information entered when creating the service
    • AD Server ID: AD User ID
    • AD Server Password: User Password
    Table. Microsoft SQL Server (DBaaS) Secondary configuration items

Promoting Secondary (DR) to Primary

You can promote a configured Secondary (DR) to Primary.

Caution
When promoted to Primary, synchronization with the existing Cluster is halted.

To promote Secondary(DR) to Primary, follow these steps.

  1. All Services > Database > Microsoft SQL Server (DBaaS) Click the menu. 1. Go to the Service Home page of Microsoft SQL Server (DBaaS).
  2. On the Service Home page, click the Microsoft SQL Server(DBaaS) menu. 2. Microsoft SQL Server(DBaaS) List Navigate to the page.
  3. Microsoft SQL Server(DBaaS) List On the page, click the resource to promote to Primary. 3. Microsoft SQL Server(DBaaS) Details Navigate to the page.
  4. Click the More button, then click the Primary Promotion button. 4. Primary Promotion Notification The popup window opens.
  5. Primary Promotion Notification In the popup window, click the Confirm button.
Backing up and restoring the DB
Microsoft SQL Server(DBaaS) server connection