2-minute Comparison of Online Database and Self-built Databases

简介: Should you use Alibaba Cloud ApsaraDB for RDS or build your own database?

Galera_to_be_phased_out_MySQL_Group_Replication_officially_launched

Should you use Alibaba Cloud ApsaraDB for RDS or build your own database? Check out these two tables to learn more!

Performance Comparison

Feature ApsaraDB for RDS Independently Built Database Services from Purchased Servers
Service Availability 99.95% Requires you to implement and maintain your own data protection, master-slave replication, and RAID
Data Reliability 99.9999% Requires you to implement and maintain your own data protection, master-slave replication, and RAID
System Security •Anti-DDoS
•Traffic cleaning
•Timely repair of all kinds of database security vulnerabilities
•Dependent on system design and additional third-party security products
•Potentially more expensive
•Self-repair of all database security vulnerabilities
Database Backup Automatic backup Independent backups are possible, but the user has to find storage space and regularly validate the backup
Software and Hardware Investment Pay-as-you-go, no software and hardware investment Database servers are rather costly and the user must purchase their own SQL Server license
System Hosting No hosting fee More than RMB 5,000/year for each 2U server (more than RMB 10,000/year for two servers (master and slave servers))
Maintenance O&M is not needed Need to be maintained by DBA, greatly increasing OpEx
Deployment Resizing Instant activation, fast deployment, elastic resizing, activated as necessary Hardware procurement, data center hosting, and machine deployment are all required and can be time consuming
Rate of Resource Utilization 100% utilization rate, pay for what you use Low rate of resource utilization, resources must accommodate peak traffic requirements

Price comparison


Category ApsaraDB for RDS Independently Built Database Services from Purchased Servers
Hardware, Parts and Accessories •Memory 1200 MB: 50 GB database, 600 IOPS.
•Price: RMB 2,040/year
•The database cluster needs at least two servers with 600 IOPS, costing about RMB 6,000/set.
•One Intranet switch is used to connect the front-end web servers (the price of a cheap 1U non-NMS switch is about RMB 1,000)
•Additional 30% for replacing damaged hardware.
•Cost of hardware: (6000× 2+1000) x 130%= RMB 16,900
•Annual cost: RMB 16,900/3= RMB 5,633 (the cost of hardware is calculated according to a 3-year depreciation period)
Data Center Hosting There is no hosting fee as hosting is taken care of by a service provider. The hosting fee of a 1U cabinet is RMB 3,000/year, and the hosting fee of two 1U servers and a 1U Intranet switch will be charged.Data center hosting fees: 3,000 x 3 = RMB 9,000
Bandwidth and Traffic Communication between ECS and RDS in the same region is done through the Intranet at no costs. However, when the ECS and RDS are in different regions, communication is done over the Internet which will incur Internet traffic fees. For details on rates please see ApsaraDB for RDS pricing details.
Cost for 1 TB Internet traffic: 1000 x 1.052 = RMB 1052/year
Only uses Intranet, does not incur Internet traffic fees
Labor There is no labor cost as database maintenance is taken care of by a service provider. The monthly salary of a junior DBA engineer is at least RMB 5,000/month. If the current project occupies 30% of the workload of the engineer, then:Personnel cost: 5000×12×30%= RMB 18,000/year
Total Estimated Annual Cost (RMB) RMB 3092/year RMB 32,633/year

As shown in the table above, using Alibaba Cloud ApsaraDB for RDS could potentially cost 10 times less than building your own database. What's more, with ApsaraDB for RDS, you no longer need to worry about database maintenance and management. Try ApsaraDB for RDS at no costs for 60 days with our New User Free Credit!
目录
相关文章
|
2月前
|
SQL Java Maven
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
38 1
|
SQL 存储 Oracle
《Oracle Database In-Memory: A Dual Format In-Memory Database》
Oracle IMC是第一个商用的dual-format数据库。
《Oracle Database In-Memory: A Dual Format In-Memory Database》
|
关系型数据库 MySQL RDS
Implementing Effective MySQL Database Backup Mechanisms
Alibaba Cloud ApsaraDB for RDS for MySQL provides a variety of methods to synchronize data to a local self-built database.
1512 0
|
SQL 监控 Go
backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized.
昨天在检查YourSQLDba备份时,发现有台数据库做备份时出现了下面错误信息,如下所示:   yMaint.ShrinkLog   Log Shrink   --  ============================================================...
1096 0
|
机器学习/深度学习 Oracle 关系型数据库