-
Cross-Region & In-Region Read Replicas for RDS SQL Server Standard, EE & Web
Enable RDS Multi-AR for a more resilient SQL Server cross-region DR strategy.
Safeguard SQL Server against ransomware attacks and human errors. Meet compliance goals.
SQL Standard Read Replicas | RDS to EC2 Replicas | Lower TCO | Downgrade to SQL Standard
AWS RDS Multi-AZ vs. CloudBasic SQL.Replica (MS SQL Server)
With CloudBasic SQL.Replica for SQL Server Web Edition, Standard and Enterprise, you can deploy a much more cost effective high-availability solution, which offers a lot more benefits than the classic RDS Multi-AZ for MS SQL Server Standard and Enterprise (Web Edition is not supported; no access to the replica). With CloudBasic, you can deploy a true Multi-Region (or even multi-cloud*) server replication scenario, even with MS SQL Server Web Edition, with full access to the Read-Replica, while still paying 1/2 less than the AWS Multi-AZ deployment (which comes without access to the replica end point; doesn’t not support cross-region replication).
Here are sample scenarios to compare cost and benefits:
1. RDS db.r3.2xlarge based comparison table:
| RDS SQL Server Mirroring / AlwaysOn |
AWS Multi AZ (Virginia-to-Virginia) |
CloudBasic SQL.Replica (Virginia-to-Oregon) |
|---|---|---|
| DB Size | RDS db.r3.2xlarge, MS SQL Server STANDARD (mirroring not supported for Web Edition) |
RDS db.r3.2xlarge, MS SQL Server WEB EDITION |
| Cost per hour – RDS SQL Server Multi-AZ | $6.04/hr (prepaid 1 yr $38076) | - |
| Cost per hour – source MS SQL Server | - | $1.800/hr (prepaid 1 yr $9156) |
| Cost per hour – destination RDS SQL Server Web Edition db.m4.large (CloudBasic replicates asynchronously, Read-Replica SQL Server can be a smaller instance size) |
- | $0.311 (prepaid 1 yr $1679) |
| CloudBasic AlwaysOn/Geo-Replicate for MS SQL Server Web Edition | - | $1.558 (CloudBasic $1.37+ EC2 C3.Large $0.188) Prepaid 1 yr: $10,782 (CloudBasic $9574 + EC2 C3.Large $1208) |
| Access to Replica End Point (for reporting, data locality, offloading of Read-Loads from Primary RDS) |
Not available | Available |
| Multi-Region Replication Option | Not available | Available |
| Support of MS SQL Web edition | Not available | Available |
| Multi-Cloud Replication (AWS -to-Azure, AWS-to-GoogleCloud, AWS-to-IBMCloud) |
Not available | Available (*priced separately) |
| TOTAL COST/HR | $6.10 | $3.669 |
| TOTAL COST/MO | $4,440 | $2,671 |
| TOTAL COST/YR | $53,290 (prepaid 1 yr $38,076) | $32,052 (prepaid 1 yr $21,617) |
2. RDS db.r3.xlarge based comparison table
| RDS SQL Server Mirroring / AlwaysOn |
AWS Multi AZ (Virginia-to-Virginia) |
CloudBasic SQL.Replica on AWS (Virginia-to-Oregon) |
|---|---|---|
| DB Size | RDS db.r3.xlarge, MS SQL Server STANDARD (mirroring not supported for Web Edition) |
RDS db.r3.xlarge, MS SQL Server WEB EDITION |
| Cost per hour – RDS SQL Server Multi-AZ | $3.40/hr (prepaid 1 yr $19143) | - |
| Cost per hour – source MS SQL Server | - | $0.460/hr (prepaid 1 yr $2353) |
| Cost per hour – destination RDS SQL Server Web Edition db.m3.medium (CloudBasic replicates asynchronously, Read-Replica MS SQL Server can be a smaller instance size) |
- | $0.210 (prepaid 1 yr $1065) |
| CloudBasic RDS AlwaysOn/Geo-Replicate for MS SQL Server Web Edition | - | $0.82 (CloudBasic $0.69+ EC2 m3.Medium $0.13) Prepaid 1 yr: $6,380 (CloudBasic $6027 + EC2 m3.Medium $353) |
| Access to Replica End Point (for reporting, data locality, offloading of Read-Loads from Primary RDS) |
Not available | Available |
| Multi-Region Replication Option | Not available | Available |
| Support of MS SQL Web edition | Not available | Available |
| Multi-Cloud Replication (AWS -to-Azure, AWS-to-GoogleCloud, AWS-to-IBMCloud) |
Not available | Available (*priced separately) |
| TOTAL COST/HR | $3.40 | $1.49 |
| TOTAL COST/MO | $2,475 | $1,084 |
| TOTAL COST/YR | $29,702 (prepaid 1 yr $19,143) | $13,016 (prepaid 1 yr $9,798) |
