19. Google Cloud SQL

Google becomes your DBA
Google handles:
- patch management
- updates
- replication
- etc.
allows developers to focus on the logical side, and creating data structures

Cloud SQL

Google-managed MySQL databases
pay-per-use model without lock-in
highly-available, reliable, secure
supports standard MySQL connections
seamless integration with GAE and GCE
REST API for management

Cloud SQL Features

familiar
flexible charging
managed backups
- retains 7 backups, included in initial cost
connect from anywhere
automatic replication
fast connection from GCE and GAE
Google security

Interacting with Cloud SQL

standard tools, such as MySQL client

$ mysql --host=<instance-ip> --user=<user-name> --password

using Google Cloud SDK

$ gcloud sql instances create <instance-name>

Comparing Storage Options

Cloud Datastore

capacity: terabytes+
unit size: 1MB / entity
storage type: NoSQL
primary user case: use with App Engine

Cloud Storage

capacity: petabytes+
unit size: 5TB / object
storage type: Object storage
primary user case: unstructured data

Cloud SQL

capacity: terabytes+
unit size: 10TB
storage type: Relational SQL
primary user case: managed MySQL

Via Google Stoarge options: