Cloud Provider Comparisons: AWS vs Azure vs GCP – Databases

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!
  https://www.youtube.com/channel/UCp8lLM2JP_1pv6E0NQ38pqw/?sub_confirmation=1
• Sign up for a free ACG account: https://bit.ly/2R07VSz
• Like us on Facebook: https://www.facebook.com/acloudguru
• Follow us on Twitter: https://twitter.com/acloudguru
• Join the conversation on Discord: https://discord.com/invite/acloudguru
• Rob Moore’s website: https://robdmoore.id.au/

RESOURCES
IaaS SQL- AWS:

• Deploying Microsoft SQL Server on Amazon EC2: https://amz.run/4mD4
• Oracle on AWS: https://aws.amazon.com/oracle/resources/
• Install a LAMP web server on the Amazon Linux AMI: https://amz.run/4mD5
• AWS Marketplace: https://amz.run/4mD7

IaaS SQL – Azure:

• SQL Server on Azure Virtual Machines: https://azure.microsoft.com/en-au/services/virtual-machines/sql-server/
• Oracle VM images on Azure: https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-vm-solutions
• Integrating Microsoft Azure and Oracle Cloud Infrastructure: https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-oci-overview
• Azure Database for MySQL: https://docs.microsoft.com/en-us/azure/mysql/
• PostgreSQL for Azure: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options
• MariaDB for Azure: https://docs.microsoft.com/en-us/azure/mariadb/select-right-deployment-type
• Azure Marketplace: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/category/databases?page=1

IaaS SQL – GCP:

• SQL Server on Google Cloud: https://cloud.google.com/sql-server
• How to Set Up MySQL on Compute Engine: https://cloud.google.com/architecture/setup-mysql
• Set up PostgreSQL on Compute Engine: https://cloud.google.com/community/tutorials/setting-up-postgres
• Google Cloud Platform Marketplace: https://console.cloud.google.com/marketplace/browse?filter=category:database

PaaS SQL – AWS:

• Amazon Relational Database Service (RDS): https://aws.amazon.com/rds/
• Amazon RDS for SQL Server: https://aws.amazon.com/rds/sqlserver/
• Amazon RDS for Oracle: https://aws.amazon.com/rds/oracle/
• Amazon RDS for MySQL: https://aws.amazon.com/rds/mysql/
• Amazon RDS for PostgreSQL: https://aws.amazon.com/rds/postgresql/
• Amazon RDS for MariaDB: https://aws.amazon.com/rds/mariadb/

PaaS SQL – Azure:

• Azure SQL Managed Instance: https://azure.microsoft.com/en-au/products/azure-sql/managed-instance/
• Azure Database for MySQL: https://azure.microsoft.com/en-us/services/mysql/
• Azure Database for PostgreSQL: https://docs.microsoft.com/en-us/azure/postgresql/
• Azure Database for MariaDB: https://docs.microsoft.com/en-au/azure/mariadb/

PaaS SQL – GCP:

• Cloud SQL for PostgreSQL, MySQL, and SQL Server: https://cloud.google.com/sql

Cloud-native PaaS SQL – AWS:

• Amazon Aurora: https://aws.amazon.com/rds/aurora/
• Amazon Aurora Global Database: https://aws.amazon.com/rds/aurora/global-database/
• Amazon Aurora Serverless: https://aws.amazon.com/rds/aurora/serverless/

Cloud-native PaaS SQL – Azure:

• Azure SQL Database: https://azure.microsoft.com/en-au/products/azure-sql/database/
• Azure SQL Database Hyperscale: https://docs.microsoft.com/en-au/azure/azure-sql/database/service-tier-hyperscale
• Azure SQL Database elastic pools: https://docs.microsoft.com/en-au/azure/azure-sql/database/elastic-pool-overview
• Azure SQL Database serverless: https://docs.microsoft.com/en-au/azure/azure-sql/database/serverless-tier-overview

Cloud-native PaaS SQL – GCP:

• Cloud Spanner: https://cloud.google.com/spanner

NoSQL – AWS:

• Amazon SimpleDB: https://aws.amazon.com/simpledb/
• Amazon DocumentDB (with MongoDB compatibility): https://aws.amazon.com/documentdb/
• Amazon DynamoDB: https://aws.amazon.com/dynamodb/

NoSQL – Azure:

• Azure Table Storage: https://azure.microsoft.com/en-us/services/storage/tables/
• Azure Cosmos DB: https://azure.microsoft.com/en-us/services/cosmos-db/

NoSQL – GCP:

• Cloud Bigtable: https://cloud.google.com/bigtable
• Datastore: https://cloud.google.com/datastore/
• Firebase Realtime Database: https://firebase.google.com/products/realtime-database/
• Firestore: https://cloud.google.com/firestore

Series description

In Cloud Provider Comparisons, we explore and compare the same cloud service across the three major public cloud providers - Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP).