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 VM
  2. Assign Storage & N/W
  3. Install MS-SQL
VPC
  • Web/WAS - Active-Standby Failover- VM1(MS-SQL(Primary)/windows)-Storage
  • Web/WAS - Active-Standby Failover- VM2(MariaDB(Secondary)/windows)-Storage
  • VM1's iSCSI → Shared Disk(Quorum) → Replication(Asynchronous/Synchronous) → VM2's iSCSI

Key Features

  • Rapid and safe DB creation

    - Auto provisioning : Automatically install standard version Samsung Cloud Platform database using VM with various spec
    - HA configuration : Configure active-standby with disk synchronous replication based on AlwaysOn. Enhance security features or configure DR when configuring additional AD (Active Directory) server.
    - Multi-AZ configuration : HA configuration for Microsoft SQL Server(DBaaS) across two availability zones

  • Simple and convenient DB management

    - Backup (Data & Archive) : Perform scheduled backup and instant backup in File Storage by using differential backup feature in MS-SQL
    - Recovery : Able to recover to a specific point in time or present time based on backup files stored in File Storage
    - Patch : Provide patch function for DB minor version
    - User parameter setting : Set parameters regarding better DB performance and security
    - Read Replica : Configure read-only servers for purposes of load balancing for reading or disaster recovery(DR), in the same or different region
    - Storage : Add storage in the data domain

Pricing

    • Billing
    • Provided in VM package, composed of VM & BM costs
       · Without contract : Hourly charge based on metering information of server(DB) status being ‘on’
       · Contracted : Fixed monthly charge according to contract terms
Let’s talk

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

Share