Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Building Google Cloud Platform Solutions

You're reading from   Building Google Cloud Platform Solutions Develop scalable applications from scratch and make them globally available in almost any language

Arrow left icon
Product type Course
Published in Mar 2019
Publisher Packt
ISBN-13 9781838647438
Length 778 pages
Edition 1st Edition
Languages
Arrow right icon
Authors (3):
Arrow left icon
Steven Porter Steven Porter
Author Profile Icon Steven Porter
Steven Porter
Legorie Rajan PS Legorie Rajan PS
Author Profile Icon Legorie Rajan PS
Legorie Rajan PS
Ted Hunter Ted Hunter
Author Profile Icon Ted Hunter
Ted Hunter
Arrow right icon
View More author details
Toc

Table of Contents (29) Chapters Close

Title Page
Copyright and Credits
About Packt
Contributors
Preface
1. Why GCP? FREE CHAPTER 2. The Google Cloud Console 3. APIs, CLIs, IAM, and Billing 4. Google App Engine 5. Google Kubernetes Engine 6. Google Cloud Functions 7. Google Compute Engine 8. NoSQL with Datastore and Bigtable 9. Relational Data with Cloud SQL and Cloud Spanner 10. Google Cloud Storage 11. Stackdriver 12. Change Management 13. GCP Networking for Developers 14. Messaging with Pub/Sub and IoT Core 15. Integrating with Big Data Solutions on GCP 16. Compute 17. Storage and Databases 18. Networking 19. Security 20. Machine Learning and Big Data 21. Management Tools 22. Best Practices 1. Other Books You May Enjoy 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...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime