That’s 47% less.Īdditionally, hosting a database on Amazon EC2 will also bring more flexibility regarding the types of EC2 instances you can choose. But hosting the database on an EC2 with Linux AMI costs $181.44. In the last row, the price of Amazon RDS MySQL-compatible is $345.6 per month. And if we use it on an EC2 with “Linux with SQL Enterprise” the cost will be 30% less. If we host the in an EC2 instance with Windows Server 2019 with SQL Server 2019 Enterprise AMI, the price is $1393.92 per month. Windows Server 2019 with SQL Server 2019 Webįor example in the first row, the price of Amazon RDS with SQL Server is $1800.72 per month (in Ohio). Windows Server 2019 with SQL Server 2019 Standard Windows Server 2019 with SQL Server 2019 Enterprise It uses the same hardware as the db.r5.xlarge database. We will use an on-demand EC2 r5.xlarge instance which has 4 vCPUs with 32 GiB of memory. Let’s compare the cost of a database in EC2 and RDS. As we mentioned before, Amazon RDS has lots of benefits and makes the database administration much easier. This strategy is probably an option that no cloud specialist will mention. And it’s free (you only pay for the EC2 instance to run it). This is a tool that allows you to migrate your database (and schema) to a new engine. In case you decide to migrate your database, you can use AWS Database Migration Service. For example, if you change from RDS for Oracle SE2 to Aurora PostgresSQL, you will save 44% monthly. If you can change the technology of your database, that could avoid the licensing fees. And your team has to know how to use it.īut having that said, it’s important to note that the type of database technology will have a big impact on your costs. You have to make sure the code using it could also be changed. Not only the database data has to change. For this reason, these are more expensive than the rest.Ĭhanging the database engine is not a simple task. The cost of Microsoft (or Oracle) database licenses is already included in the RDS service price. So it’s not necessary to bring your license (BYOL) for this service. And Amazon Aurora is a bit more expensive than them.Īmazon RDS engine pricing includes the licensing for the corresponding database engine. Note that the 3 open source databases (MySQL, PostgreSQL, MariaDB) almost have the same price. But the price has a huge variation based on the DB engine type. These 10 DB instances all use the same HW (a db.r5.xlarge instance). The following picture compares the monthly price of a db.r5.xlarge OnDemand DB engine in us-east-2 (Ohio) region using Single-AZ configuration. But it’s compatible with my MySQL and PostgreSQL. And the last one, Amazon Aurora, is an AWS proprietary database. Oracle and Microsoft SQL Server are proprietary database technologies. The first 3 ones are open source database technologies. These are all relational database technologies. Changing the DB engineĪmazon RDS supports 6 different types of relational database engines: MySQL, PostgreSQL, MariaDB, Oracle, Microsoft SQL Server, and Amazon Aurora. And you should use the strategies that work best for you. Note that each strategy has to be analyzed with the requirements of your workload. That makes database costs to increase fast.įor this reason, our objective is to describe some strategies to reduce your Amazon RDS costs. Thus Amazon RDS will simplify the operation and maintenance of your DB.īut one of the main problems with relational databases is that they scale vertically. And AWS takes care of hardware provisioning, database setup, patching, and backups. Instead, Amazon RDS provides a Database-as-a-Service. The standard approach to deploy a database is by installing it on your OS. This article is part of our How to reduce AWS Costs article series.Īmazon RDS is a relational database service. In this article, we will give describe some strategies to reduce Amazon RDS costs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |