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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.