Hands on Google Cloud SQL and Cloud Spanner deployment, administration and use cases with Python
Discover the methodologies and best practices for getting started with Google Cloud Platform relational services - CloudSQL and CloudSpanner. The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers fro...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
[Place of publication not identified]
Apress
2020
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Connect to the Spanner Instance
- Create Database
- Create Schema
- Reading and Writing Data
- Python Program
- Feast Out
- Database Schema
- Provision Compute Instance
- Set up Python Development Environment
- Install and Configure Cloud SDK
- Python Program
- Run and Verify
- Wrap Up
- Summary
- Chapter 8: Best Practices
- Cloud SQL Best Practices
- Plan Resources Efficiently
- Storage
- CPU
- RAM
- Maintenance Activities
- Use Read Replicas
- Instance Location
- Keep Tables to a Reasonable Number
- Sharding at Designing
- Connection Management
- Certificates
- Authorized Network
- Data in Transit
- Cloud Proxy
- Private IP Address
- Authorization
- Backups and Restores
- CloudSQL MySQL
- Binary Logging
- Maintenance
- Managing Resources
- High Availability
- Replication
- Read Replica
- Fault Tolerance Replica
- Enable High Availability
- Read Replicas
- Logging
- Summary
- Chapter 5: Cloud Spanner
- New in NewSQL
- Origins of Cloud Spanner
- Google Cloud Spanner
- Spanner and CAP Theorem
- Best Fit
- Development Support
- Summary
- Chapter 6: Cloud Spanner Explained
- Instance
- Data Modeling
- Databases and Tables
- Intro
- Table of Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: Getting Started with GCP
- Signing Up
- Accessing Google Cloud Platform
- Cloud Console
- Cloud Shell
- Cloud SDK
- Project
- Ownership: Projects and Billing
- Projects and Isolations
- Project as Namespace
- Create a Project
- Summary
- Chapter 2: Cloud SQL
- Relational Databases
- Primary Key
- Foreign Key
- Constraints
- Operations
- DDL
- DML
- Read Requests
- Transactions
- Getting Started with Cloud SQL
- Provision a MySQL Instance
- Provisioning a PostgreSQL Instance
- Summary
- Chapter 3: Working with CloudSQL
- Getting Started in Cloud Shell
- Connect to the Database
- Alternative Way to Connect to the Instance
- Create Database
- Create Table
- Insert and Select
- Load and Query Sample Dataset
- Python Program
- Feast Out
- Database Schema
- Provision Compute Instance
- Set Up Python Development Environment
- Enable APIs
- Create Service Account
- Install and Configure Cloud SDK
- Python Program
- Run and Verify
- Wrap Up
- Summary
- Chapter 4: Administering CloudSQL
- Authorization and Security
- Primary Keys
- Choose a Key to Avoid Hotspots
- Interleaving
- Splits
- Secondary Indexes
- Storing Clause
- Interleaved Indexes
- Replication
- Transactions
- Read/Write
- Read Only
- Handling Multiple Transactions
- Read/Write Transactions
- Sequential Occurrence
- Simultaneous Occurrence
- Data Invalidated
- Different Fields Updates
- Blind Writes
- Read/Write with Read Only
- Distributed Transactions Explained
- Writes
- Reads
- Summary
- Chapter 7: Getting Started with Spanner
- Provisioning CloudSpanner Instance
- Getting Started in Cloud Console
- Includes bibliographical references