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 databases to Cloud SQL


While greenfield applications are easy to get started on with Cloud SQL, many teams will want to capitalize on the managed MySQL and PostgreSQL experience for existing databases hosted outside of Google Cloud. With first generation MySQL instances, it was possible to configure external masters. This provided a clear migration path as the new instance could simply replicate all data from the external master until eventually moving clients over to the new instance.

With second generation instances, external masters are currently not supported. Migration to a second generation MySQL instance will unfortunately require some level of downtime, as writes must be disabled for the original MySQL instance and data must be imported into the new instance. The total downtime can be drastically reduced by migrating historical data before disabling writes on the original database, and migrating any remaining data afterwards.

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