Cloud Provider Comparisons: AWS vs Azure vs GCP - Databases
HTML-код
- Опубликовано: 27 май 2024
- In Cloud Provider Comparisons, we take a look at the same cloud services across the three major public cloud providers - Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). In this video we focus on databases. Join Rob Moore as he dives into comparing Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and cloud-native PaaS SQL databases, and NoSQL databases, with a focus on key-value and document databases. If you’re curious about how the database services of AWS, Azure and GCP match up, watch on to find out!
Links to everything covered in the episode are provided below.
Timestamps:
0:00 Introduction
0:43 Databases fundamentals
3:58 SQL (Relational) databases
7:40 PaaS SQL databases
10:36 Cloud-native PaaS SQL databases
14:34 NoSQL Databases
---
- Subscribe to stay updated!
/ @acloudguru
- Sign up for a free ACG account: bit.ly/2R07VSz
- Like us on Facebook: / acloudguru
- Follow us on Twitter: / acloudguru
- Join the conversation on Discord: / discord
- Rob Moore’s website: robdmoore.id.au/
---
RESOURCES
IaaS SQL- AWS:
- Deploying Microsoft SQL Server on Amazon EC2: amz.run/4mD4
- Oracle on AWS: aws.amazon.com/oracle/resources/
- Install a LAMP web server on the Amazon Linux AMI: amz.run/4mD5
- AWS Marketplace: amz.run/4mD7
IaaS SQL - Azure:
- SQL Server on Azure Virtual Machines: azure.microsoft.com/en-au/ser...
- Oracle VM images on Azure: docs.microsoft.com/en-us/azur...
- Integrating Microsoft Azure and Oracle Cloud Infrastructure: docs.microsoft.com/en-us/azur...
- Azure Database for MySQL: docs.microsoft.com/en-us/azur...
- PostgreSQL for Azure: docs.microsoft.com/en-us/azur...
- MariaDB for Azure: docs.microsoft.com/en-us/azur...
- Azure Marketplace: azuremarketplace.microsoft.co...
IaaS SQL - GCP:
- SQL Server on Google Cloud: cloud.google.com/sql-server
- How to Set Up MySQL on Compute Engine: cloud.google.com/architecture...
- Set up PostgreSQL on Compute Engine: cloud.google.com/community/tu...
- Google Cloud Platform Marketplace: console.cloud.google.com/mark...
PaaS SQL - AWS:
- Amazon Relational Database Service (RDS): aws.amazon.com/rds/
- Amazon RDS for SQL Server: aws.amazon.com/rds/sqlserver/
- Amazon RDS for Oracle: aws.amazon.com/rds/oracle/
- Amazon RDS for MySQL: aws.amazon.com/rds/mysql/
- Amazon RDS for PostgreSQL: aws.amazon.com/rds/postgresql/
- Amazon RDS for MariaDB: aws.amazon.com/rds/mariadb/
PaaS SQL - Azure:
- Azure SQL Managed Instance: azure.microsoft.com/en-au/pro...
- Azure Database for MySQL: azure.microsoft.com/en-us/ser...
- Azure Database for PostgreSQL: docs.microsoft.com/en-us/azur...
- Azure Database for MariaDB: docs.microsoft.com/en-au/azur...
PaaS SQL - GCP:
- Cloud SQL for PostgreSQL, MySQL, and SQL Server: cloud.google.com/sql
Cloud-native PaaS SQL - AWS:
- Amazon Aurora: aws.amazon.com/rds/aurora/
- Amazon Aurora Global Database: aws.amazon.com/rds/aurora/glo...
- Amazon Aurora Serverless: aws.amazon.com/rds/aurora/ser...
Cloud-native PaaS SQL - Azure:
- Azure SQL Database: azure.microsoft.com/en-au/pro...
- Azure SQL Database Hyperscale: docs.microsoft.com/en-au/azur...
- Azure SQL Database elastic pools: docs.microsoft.com/en-au/azur...
- Azure SQL Database serverless: docs.microsoft.com/en-au/azur...
Cloud-native PaaS SQL - GCP:
- Cloud Spanner: cloud.google.com/spanner
NoSQL - AWS:
- Amazon SimpleDB: aws.amazon.com/simpledb/
- Amazon DocumentDB (with MongoDB compatibility): aws.amazon.com/documentdb/
- Amazon DynamoDB: aws.amazon.com/dynamodb/
NoSQL - Azure:
- Azure Table Storage: azure.microsoft.com/en-us/ser...
- Azure Cosmos DB: azure.microsoft.com/en-us/ser...
NoSQL - GCP:
- Cloud Bigtable: cloud.google.com/bigtable
- Datastore: cloud.google.com/datastore/
- Firebase Realtime Database: firebase.google.com/products/...
- Firestore: cloud.google.com/firestore
#aws #microsoftazure #googlecloudplatform
Wow! Those are pretty deep level of comparisons! Thanks Rob!
Awesome comparison, thanks Rob
This is pretty informative and must to know if you are working with multi cloud environment.
So much useful info jam packed into this short video. Thank you so much!
Great explanation of the differences - thanks!
are there free versions/alternatives available of these?
This is a #Rob THAT I CAN TRUST more. 😁
However, this topic of databases is extensive. And to think there is more?! 😅
GCP > AWS > Azure for databases. GCP's BigQuery and BigTable are the best for SQL & NoSQL on a large scale. AWS DynamoDB is the 2nd best for NoSQL. Also Aurora from AWS is very good too for Postgress SQL in specific situations, but many people claim it isn't needed over Mariah DB.
I forgot to add AWS Redshift. Also a great choice, but 2nd to Google BigQuery.
Thanks
So no Google BigQuery, dose AWS or Azure have alternative to it?
@@acloudguru so I can put eg 20TB data in day and make simple query to make report? Or they are (from my memory) requiring putting cluster, balance data etc.?
I think video about unique solution in each cloud would be great. Bigquery as server less solution which can process petabytes of data using simple SQL is for some big thing, data analytics would love, but not only. But others may have some gems in they portfolio too.
I was thinking the same thing. BigQuery is one of the most commonly used services by GCP customers. Far more compatability and scaleable for large warehouse data analysis. Think of national elections or high stock market trading days.
Could you please Oracle to the comparison?
I'm new to the environment and even I agree:)
Irritating that you have to get almost 5min before the subject of the video STARTS to be addressed.