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
• 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 -- 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
• 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.