Hands on Google Cloud SQL and Cloud Spanner : deployment, administration and use cases with Python /: deployment, administration and use cases with Python. (2020)
- Record Type:
- Book
- Title:
- Hands on Google Cloud SQL and Cloud Spanner : deployment, administration and use cases with Python /: deployment, administration and use cases with Python. (2020)
- Main Title:
- Hands on Google Cloud SQL and Cloud Spanner : deployment, administration and use cases with Python
- Further Information:
- Note: Navin Sabharwal, Shakuntala Gupta Edward.
- Other Names:
- Sabharwal, Navin
Edward, Shakuntala Gupta - Contents:
- 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 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 -- ReadIntro -- 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 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 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 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 … (more)
- Publisher Details:
- Place of publication not identified : Apress
- Publication Date:
- 2020
- Extent:
- 1 online resource
- Subjects:
- 005.75/6
Relational databases
SQL (Computer program language)
Python (Computer program language)
Python (Computer program language)
Relational databases
SQL (Computer program language)
Electronic books - Languages:
- English
- ISBNs:
- 9781484255377
1484255372 - Related ISBNs:
- 1484255364
9781484255360 - Notes:
- Note: Includes bibliographical references.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.478906
- Ingest File:
- 03_029.xml