Microsoft SQL Server (DBaaS)

Easily Creates and Manages Microsoft SQL Server in a Web Environment

Microsoft SQL Server(MS-SQL) is one of the most popular relational database serving a wide range of applications. Samsung Cloud Platform provides an environment that automatically creates and configures MS-SQL, and to ensure the proper management of a single instance or critical data, features such as high availability capability, read/replication, backup/restoration, patch, parameter management, auditing, and monitoring were added, thereby automating DB lifecycle management.

Overview

01

04

Service Architecture

user → Request for creation → RDB Provisioning → System configuration → VPC RDB Provisioning
  1. Create Virtual Server
  2. Assign Storage & N/W
  3. Install MS-SQL
VPC
  • Web/WAS - Active-Standby Failover- Virtual Server1(MS-SQL(Primary)/windows)-Storage
  • Web/WAS - Active-Standby Failover- Virtual Server2(MS-SQL(Secondary)/windows)-Storage
  • Virtual Server1's iSCSI → Shared Disk(Public Quorum) → Replication(Asynchronous/Synchronous) → Virtual Server2's iSCSI

Key Features

  • Rapid and safe DB creation
    1. Auto provisioning : Automatically install standard version Samsung Cloud Platform database using Virtual Server with various spec
    2. HA architecture : Configure active-standby with disk synchronous replication based on Always On
  • Simple and convenient DB management
    1. Backup(Data & Archive) : Perform backup in File Storage by using differential backup feature in MS-SQL
    2. Recovery : Able to recover to a specific point in time or to a backup stored point of based on backup files stored in storage
    3. Patch : Provide patch function for minor version
    4. User parameter setting : Set parameters regarding better DB performance and security
    5. Read-only secondary : Configure read-only servers in the same region for purposes of load balancing for reading

※ Microsoft SQL Server(DBaaS) service provides SQL Server, a relational database of Microsoft. Microsoft SQL Server’s software licenses use Bring Your Own License(BYOL), and software licenses in the cloud must comply with the policies of Microsoft.

Let’s talk

Whether you’re looking for a specific business solution or just need some questions answered, we’re here to help