cloud sql basics - amazon web services

1

Choosing a Managed Database The Data Dossier Choose a Lesson Cloud SQL Basics Return to Table of Contents Importing Data SQL Query Best Practices Text Cloud SQL Basics What is Cloud SQL? - Direct lift and shift of traditional MySQL/PostgreSQL workloads with the maintenance stack managed for you What is managed? - OS installation/management - Database installation/management - Backups - Scaling - disk space - Availability: - Failover - Read replicas - Monitoring - Authorize network connections/proxy/use SSL Limitations: - Read replicas limited to the same region as the master: - Limited global availability - Max disk size of 10 TB - If > 10 TB is needed, or global availability in RDBMS, use Spanner Scaling High Availability Database Backups Software Patches Database Installs OS Patches OS Installation Server Maintenance Physical Server Power-Network-Cooling Monitoring

Upload: others

Post on 26-May-2022

1 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

TRANSCRIPT

Page 1: Cloud SQL Basics - Amazon Web Services

Choosing a Managed Database

The Data Dossier

Choose a Lesson

Cloud SQL Basics

Return to Table of Contents

Importing Data

SQL Query Best Practices

Text

Cloud SQL Basics

What is Cloud SQL?- Direct lift and shift of traditional MySQL/PostgreSQL workloads

with the maintenance stack managed for you

What is managed?- OS installation/management- Database installation/management- Backups- Scaling - disk space- Availability:

- Failover- Read replicas

- Monitoring- Authorize network connections/proxy/use SSL

Limitations:- Read replicas limited to the same region as the master:

- Limited global availability- Max disk size of 10 TB- If > 10 TB is needed, or global availability in RDBMS, use SpannerScaling

High Availability

Database Backups

Software Patches

Database Installs

OS Patches

OS Installation

Server Maintenance

Physical Server

Power-Network-Cooling

Monitoring

SQL Injection Vulnerability - Basics

Advanced SQL and Functions - joeconway.com. SQL - Basics Adv. SQL ... JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions ... Simple

SQL Language Reference Basics

SQL Server Basics Notes

How to Hack a Database. What is SQL? Database Basics SQL Insert Basics SQL Select Basics SQL Where Basics SQL AND & OR Basics SQL Update

SQL Basics, Part 2

L02: SQL Basics

Sql Server Basics

SQL Azure - The Basics

Day02 01 SQL Basics

Database and SQL basics

SQL Basics Joins

SQL Syntax Reference - HUAWEI CLOUD...SQL Syntax Reference - HUAWEI CLOUD ... DLI

SQL Basics 1 Presentation

Basics of PL/SQL - J. Mack Robinson College of Business Basics of PL_SQL.pdf · Basics of PL/SQL Writing Your First ... SQL> set serveroutput on SQL> begin 2 dbms_output.put_line

Rdbms & SQL Basics

Day02 Lesson02 SQL Basics

Oracle SQL Basics

Sql Basics And Advanced

SQL Server 2005 Basics

PL / SQL Basics - Drexel University - Home | · PDF file2 PL / SQL Basics PL / SQL block Lexical units Variable declarations PL / SQL types Expressions and operators PL / SQL control

Advanced SQL and Functions - joeconway.com · Adv. SQL - Basics Adv. SQL ... JSONB and SP-GIST Functions - Overview Function Basics Functions - By Example Advanced SQL and Functions

SQL and SQL Plus Basics

SQL Basics and Normalization

Azure SQL Database Basics - files.meetup.com SQL Database.pdf · Azure SQL Database Basics Intro: Timothy P. McAliley ... Unit of Focus: SQL Server Managed Relational Database as

SQL Basics II.pdf

1. SQL Basics - Introduction