How to do it...

The steps involved are as follows:

  1. A sample two-table database has been exported using the mysqldump utility: https://github.com/legorie/gcpcookbook/blob/master/Chapter02/mysql2spanner/org_extract.sql. In the Google Console, let's create a Cloud Spanner instance for our database. In the following example, the instance created is geographically located in us-central1. Google replicates this instance in three availability zones within the region. With a node count of 1, our DB instance has 2 TB of storage and can provide 10,000 queries per sec (QPS) for read and 2000 QPS for write:
  1. Next, let's create the database org to host ...

Get Google Cloud Platform Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.