LogoLogo
  • Welcome to WorkSpaces Manager
  • Overview
    • Change Log
      • Stable
      • Beta
    • Portal Requirements
      • Software Requirements
      • Hardware Requirements
    • Installation Prerequisites
      • Active Directory Service Account
      • Amazon WorkSpaces Cost Optimizer
      • CloudWatch Log Group & Eventbridge Rule
      • Port Requirements
      • AWS Service Endpoints
    • Installation Procedure
      • Subscribe to WorkSpaces Manager License Key
      • Request a License Key
      • Subscribe to WorkSpaces Manager Appliance
      • Deploy WorkSpaces Manager Appliance via CloudFormation
      • Configure WorkSpaces Manager
    • Upgrade Procedures
      • From Version 5
      • WSM Update Tool
      • Latest Version Updates
    • Alternate deployment options
      • Install manually on EC2
      • Deployment from Shared AMI
        • Security Group
        • IAM Requirements: Custom Policies
        • IAM Requirements: Role and EC2 instance profile
        • Shared AMI (Amazon Machine Image)
      • Create AMI via Packer
      • Deploy an RDS Database via Terraform
    • WorkSpaces Performance Monitor Agent
    • High Availability (HA)
    • Appendices
      • Administrator Active Directory Permissions
      • SES Configuration
      • HTTPS/TLS Encryption
      • Friendly Portal URL Address
      • GPO and values for WorkSpaces Performance Monitor Agent
      • GPO and value for Disconnection after idle time
      • IAM Policies in JSON format
      • AWS CLI v2
      • LDAP (Active Directory) Troubleshooting for WSM
      • RDS Database Options
Powered by GitBook
On this page
  1. Overview
  2. Appendices

RDS Database Options

Amazon RDS for SQL Server is a managed relational database service that runs MS-SQL Server in the AWS cloud. It automates common tasks like provisioning, backups, patching, and high availability.

WorkSpaces Manager (WSM) requires a SQL Server-compatible database for backend data storage. While the system supports both on-premises and Amazon RDS deployments, using Amazon RDS for SQL Server is recommended for most AWS-native deployments due to its ease of setup, automated backups, and managed maintenance features.

Use Case
RDS Edition
vCPU/RAM
Storage
High Availability

Small/Medium Deployment

SQL Server Web

2 vCPU

4 GB RAM

20 GB

No

Large Deployment

SQL Server Standard

2 vCPU

4 GB RAM

20+ GB

Yes (Multi-AZ)

Enterprise Environments

SQL Server Enterprise

2 vCPU

4 GB RAM

20+ GB

Yes (Multi-AZ)

Guidance Based on Deployment Size

  • No HA Needed (Development/PoC or Small/Medium Deployments): For smaller environments or proof-of-concept deployments, the SQL Server Web Edition with 4 GB RAM and 20 GB of storage provides stable performance at a low cost (around $60/month). This setup does not offer high availability (HA), so it's not suitable for production-critical environments.

  • Recommended for Production on Large Deployments: For most production estates, especially those managing a large number of WorkSpaces, it is strongly recommended to use SQL Server Standard Edition with Multi-AZ (HA) enabled. This ensures database failover and availability in case of an instance or zone failure. The estimated cost is around $290/month per instance, totaling $580/month for an HA pair.

  • Enterprise Edition on Large Deployments: WorkSpaces Manager is compatible with SQL Server Enterprise Edition, though it is rarely necessary. The Enterprise tier provides features that typically go unused with WSM, making the cost unjustifiable for most customers unless they are already licensed or require Enterprise features for other integrated workloads.

Security & Networking Considerations

  • Ensure the RDS instance is in a private subnet, with appropriate security group rules to allow access only from the WorkSpaces Manager server.

  • Enable automatic backups, Multi-AZ, and encryption for production environments.

  • SQL authentication is supported; ensure credentials are securely stored and rotated as per your internal policy.

Multi-Region RDS Replication for WorkSpaces Manager

If an organization spans multiple AWS regions or needs a disaster recovery (DR) strategy, Amazon RDS Read Replicas can be used to replicate the WorkSpaces Manager database across regions.

Amazon RDS supports cross-region read replicas for SQL Server Standard and Enterprise editions only. This setup creates a read-only copy of the primary RDS instance in a different AWS region. Changes made to the primary database are asynchronously replicated to the replica using SQL Server transactional replication.

For WorkSpaces Manager, this configuration can support:

  • Disaster Recovery (DR) readiness

  • Cross-region reporting

  • Read-only dashboards in a secondary region

However, keep in mind that read replicas are not writable, and WorkSpaces Manager expects to connect to a writable database for core operations. This means replicas are primarily useful for DR and analytics, not for active-active regional usage.

PreviousLDAP (Active Directory) Troubleshooting for WSM

Last updated 2 days ago