Architecture

AWS RDS SQL Reference Architecture

  • 14 April 2023
  • 0 replies
  • 783 views
AWS RDS SQL Reference Architecture
Userlevel 3
Badge +5

To prepare your TimeXtender environment in AWS, here are the steps we recommend.

Create Application Server - AWS VM

To serve the TimeXtender application in AWS, we recommend using an AWS EC2 instance (Virtual Machine), sized according to your solution's requirements.

Guide:   Amazon EC2 Instance Types - Amazon Web Services

Considerations: 

Recommended EC2 (VM) specs for moderate workloads:

t2.xlarge | 4 vCPU | 54 CPU Credits / hour | 16 Mem (GiB) | EBS-Only Storage | Moderate Network Performance
OR

t2.2xlarge | 8 | 81 | 32 | EBS-Only | Moderate

  • This VM will host the below services, and must remain running for TimeXtender to function
    • ODX Server Service
    • Execution Server Configuration Service  

Create ODX Storage - Amazon RDS for SQL Server

AWS RDS SQL Database may be used for the data warehouse storage.

Guide:  Use Amazon RDS for SQL Server for Storage

Considerations: 

Recommended SQL server sizing:

  • RDS Custom SQL Server instance: m5.large | 2 vCPU | 8 Memory (GiB) | EBS-Only Instance Storage (GB) | Up to 10 Network Bandwidth (Gbps) | Up to 4,750 EBS Bandwidth (Mbps)
    This is sufficient for small size databases.

Create MDW Storage - Amazon RDS for SQL Server

AWS RDS SQL Database may be used for the data warehouse storage.

Guide:  Use Amazon RDS for SQL Server for Storage

Considerations: 

Recommended SQL server sizing:

  • RDS Custom SQL Server instance: m5.large | 2 vCPU | 8 Memory (GiB) | EBS-Only Instance Storage (GB) | Up to 10 Network Bandwidth (Gbps) | Up to 4,750 EBS Bandwidth (Mbps)
    This is sufficient for small size databases.

Estimate AWS Costs

Balancing cost and performance requires monitoring and forecasting of your services and needs.

Guide: AWS Pricing Calculator

Considerations: 

  • AWS provides a pricing calculator to help you estimate your costs for various configurations

Note: this AWS pricing calculator does not include the cost of TimeXtender instances and usage


0 replies

Be the first to reply!

Reply