6/23/2023 0 Comments Aws mysql vs sql server![]() ![]() What does it mean that RDS is a managed service? RDS takes care of hardware provisioning, database setup, patching, and backups-freeing you to focus on working with your database. In this post we'll focus on Amazon RDS for SQL Server. Of the supported RDS databases, SQL Server holds a special place in the heart of many. If you love C# but are new to AWS, or to this particular service, this should give you a jumpstart.Īmazon Relational Database Service (Amazon RDS) is a managed database service that supports these database engines: Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server. In this Hello, Cloud blog series, we're covering the basics of AWS cloud services for newcomers who are. Tl dr Azure SQL Managed Instance delivers a lot more throughput than Amazon RDS for SQL Server, so your workloads will run a lot faster on Azure.This episode: Amazon RDS for SQL Server. Sure you lose the minor benefits of having your servers patched and limited benefits of the backup feature, but you have more granular control over your IO performance and overall configuration. If you need to run SQL Server an AWS, what should you do? The answer is to use EC2 VMs. What Should You Do for SQL Server on AWS? I perfectly understand why this is the cost model-the storage is stored locally on the VM itself rather than remote-so Microsoft can’t put other VMs on that piece of physical hardware. If your volume is more than 2 terabytes, you need to scale to 32 cores, and if you need more than 8-16 TB, you will need to scale to 80 cores, which will cost close to $30,000/month. If you need high end storage performance (which means using the Business Critical service tier), on Managed Instance, and your data volume, is more than a terabyte, you have to scale your Managed Instance to 24 cores. While RDS has a lot of costs associated with it, and performance is limited, there is a price/performance/data volume curve that I feel I applies to both Azure and AWS platforms. ![]() ![]() These are the major concerns, with an additional licensing concern of not being able to use Developer edition for your workloads, means your overall costs to run an environment are going to be a lot higher of you use RDS. ![]() There is no instant file initialization which can make some restore and file growth operations extra painful.You can’t deploy cross-region, meaning, there is no near real-time option for disaster recovery.The native backup solution doesn’t support restoring a database to point in time.You can’t migrate a TDE encrypted database using backup and restore-you have to extract a BACPAC and import into a database in the service.While Managed Instance is by no means a perfect service, there are a number of reasons why I strongly recommend against running your database on RDS. Needless to say, in this benchmark comparing the price/performance ratio, Managed Instance crushes RDS before you even add in the hybrid licensing benefits that Microsoft supports for Azure SQL services. You’ll note that while Oracle RDS does get up to 256,000 IOPs (I guess those customers have more money), SQL Server has a max number of IOPs of 64,000. Obviously Azure is going to crush any database benchmark with that difference. I immediately saw that Azure MI had 320,000 IOPs while AWS only had 64,000. And then I realized it was a limitation of RDS. In fact, when I was reading this benchmark, I saw something when comparing the two services that made my eyes light up. I normally really dislike these benchmarks-it can be really hard to build proper comparisons and the services frequently don’t have perfect equivalent service tiers, making them really hard to ultimately compare their performance. Microsoft, in conjunction with Principle Technologies recently produced a benchmark, comparing the performance of Azure SQL Managed Instance, and Amazon RDS SQL Server. ![]()
0 Comments
Leave a Reply. |