Book Image

Google Cloud Platform Cookbook

By : Legorie Rajan PS
Book Image

Google Cloud Platform Cookbook

By: Legorie Rajan PS

Overview of this book

Google Cloud Platform is a cloud computing platform that offers products and services to host applications using state-of-the art infrastructure and technology. You can build and host applications and websites, store data, and analyze data on Google's scalable infrastructure. This book follows a recipe-based approach, giving you hands-on experience to make the most of Google Cloud services. This book starts with practical recipes that explain how to utilize Google Cloud's common services. Then, you'll see how to make full use of Google Cloud components such as networking, security, management, and developer tools. Next, we'll deep dive into implementing core Google Cloud services into your organization, with practical recipes on App Engine, Compute Engine, Cloud Functions, virtual networks, and Cloud Storage. Later, we'll provide recipes on implementing authentication and security, Cloud APIs, command-line management, deployment management, and the Cloud SDK. Finally, we'll cover administration and troubleshooting tasks on applications with Compute services and we'll show how to monitor your organization's efficiency with best practices. By the end of this book, you'll have an overall understanding and hands-on implementation of Google Cloud services in your organization with ease.
Table of Contents (14 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Migrating a MariaDB to Cloud Spanner


Google Cloud Spanner is a relational database service which is highly consistent, available and scalable horizontally. It is a fully managed service suitable for OLTP workloads and low-latency/high-throughput environments. In this recipe, we'll understand the features of Spanner in relation to a popular RDBMS, MariaDB. We'll take a simple MariaDB database and move the schema and the data to Cloud Spanner. At the time of writing, there is no automated import/export tool for Cloud Spanner, the manual method gives us a glimpse of the way Spanner is built and its strengths/weaknesses. Firstly, we'll export the data from our MariaDB database using the mysqldump utility. Then, we'll create the database and tables via the Google Console. Finally, we'll insert the data into the table via a Python script.

Getting ready

The following are the initial setup verification steps to be carried out before the recipe can be executed:

  1. Create or select a GCP project
  2. Enable billing...