AWS MySQL Aurora Vs RDS - What one should I chose?

00:12 - What We Will Cover
00:50 - Architecture And Infra RDS
01:40 - Architecture And Infra Aurora
02:07 - Architecture Advantages
03:22 - Price Comparison
04:12 - Aurora MySQL Versions
04:47 - Automatic Failover
05:57 - Change In Patterns

In this video we take a look at the differences between Amazon Aurora MySQL-Compatible DB and MySQL RDS. What one should you chose for your projects? What are the differences? How much to they cost?

😎 About me
I have spent the last decade being immersed in the world of big data working as a consultant for some the globe's biggest companies.My journey into the world of data was not the most conventional. I started my career working as performance analyst in professional sport at the top level's of both rugby and football. I then transitioned into a career in data and computing. This journey culminated in the study of a Masters degree in Software development. Alongside many a professional certification in AWS and MS SQL Server.

[Talamel]

Nicely done, easy to understand, well laid out, very articulate. Thank you!

[kat]

Just came across your vid, great explanation man, thanks a lot!

[GrantAustinPeace]

You're a boss.
Perfect delivery of two services that sit side-by-side.
I've recently built my architecture on AWS RDS and am now switching to Aurora.
Liked and Subscribed.
Thanks.

[sgblaxican]

Bless you. This is the easiest to follow comparison video for rds mysql vs. aurora that i've seen!

[affrancov]

bro!! Thanks for you time, it's cool you video.

[KieranDesmond]

Excellent video. What is the connectivity in Aurora like with Redshift vs RDS?

[STTEBID]

Good job with this video. Please give more screen time to the slides. We already see your handsome face.😜 It was shit hard to grab concepts from the slide since you switch abit too fast

[nebolos]

Thanks @Johnny Chivers. This video unlocked a lot of confusions I had with RDS and Aurora. But doesn't Aurora global databases provide fault tolerance against Region outage?

[Xaero]

Interesting your price estimator in this video says Aurora will be cheaper. Almost every other video I've seen states that the cost is higher than using non Aurora version.

[andynelson]

Cost savings definitely make it attractive 🙂

[seanm]

Now I'm more confused. I thought they did completely different things. I thought Aurora was compatible with RDS. But you're saying they're alternatives to one another? I don't understand the function of each service.

[taab]

INOA Aurora Global Databases came out in 2018

[cantimploromanolencio]

When talking about prices you are comparing a multi-az MySQL with a single-az Aurora, is that fair? Aurora replicates the storage layer across all AZ, but not the server instance; in the other side, MySQL multi-az means you have a replica of the server running in other AZ. In that scenario MySQL has HA, but Aurora doesn't. To achieve HA with Aurora you need to configure a replica in other AZ, so the price will be the double (340.50 USD). In case of failover the replica is promoted as primary, but it also implies a change in the endpoint; to avoid it you also need to configure a RDS Proxy that costs another 43.20 USD for that configuration (primary and replica with 2 vcpus each). So, in total, to achieve HA in Aurora, you have to pay 383.70 USD/month (70.14 USD more expensive than MySQL configuration).

[mikebrown]

Very good video, thank you! God bless - Matthew 11:28

[smoocher]

Thank you for this, and you have a most delightful accent.