迁移数据库到aws云上的优势:
- 成本
- 灵活性
- 托管服务
- 性能和可扩展性
- 容错能力和可用性
迁移目标
Amazon RDS
- 六个数据库引擎
- 易于管理(托管服务)
- 可用性和持久性
- 安全性
- 价格低:EC2+10%
- 无法访问RDS实例的操作系统
六个服务器:
ORACLE、SQL Server、MySQL、PostgreSQL、MariaDB、Amazon Aurora
Amazon EC2
支持的服务器:
ORACLE、SQL Server、MySQL、PostgreSQL、MariaDB、SyBase、SAPHANA
RDS和EC2的比较(以SQL Server为例)
FUNCTION | RDS | EC2 |
---|---|---|
App Optimization | Customer managed | Customer managed |
Scaling | AWS managed | AWS managed |
High Availability | AWS managed | Customer managed |
Database Backups | AWS managed | Customer managed |
DB Software Patches | AWS managed | Customer managed |
DB Software Installs | AWS managed | Multiple options |
OS Patches | AWS managed | Customer managed |
OS Installation | AWS managed | AWS managed |
Server Maintenance | AWS managed | AWS managed |
Rack and Stack | AWS managed | AWS managed |
Power, HVAC, Net | AWS managed | AWS managed |
- 首先考虑RDS
- 要求超出了RDS、需要RDS无法支持的功能、需要完全控制操作系统及软件的访问和管理使用EC2
- EC2数据库服务器需要自己管理备份、自己解决复制和集群的问题