No move to the cloud is complete without considering what to do with your databases. Do you leave them in your data center or on-prem legacy server or do you migrate them to the cloud? Migrating databases isn’t as hard as you think.
In this latest edition of GCP 101, we’ll explore the Google Cloud SQL database as a valid and efficient migration option for your existing relational databases to keep your data pipeline strong and reliable.
What is Google Cloud SQL Database?
If you’re using MySQL, PostgreSQL and SQL Server relational database engines and want a cloud-based alternative for them, Google Cloud SQL is worth exploring.
Google Cloud SQL is a fully managed, relational database that is designed to help you set up, maintain, manage, and administer your MySQL, PostgreSQL and SQL Server relational databases on Google Cloud Platform.
This service ensures your relational databases are reliable, scalable and secure in the cloud. Cloud SQL delivers powerful services for performance-intensive workloads, delivering up to 60,000 input/output operations per second (IOPS) with no extra cost for IO.
When it comes to deployment, it sets up in minutes, using built-in migration tools and standard drivers. Users can create connected databases in the cloud in minutes. Once those databases are up and running, it easily scales your instances with a single API call.
This is the case both when you are looking to start with simple testing or want to run a full-blown, highly scalable database in a production environment. It’s important to know that this cloud-based, relational database service is:
Forget managing the day-to-day needs of your database. Because Cloud SQL is fully managed, it automatically backs, replicates and encrypts your data. It also applies patches when needed and manages capacity increases and drops. Oh, and according to Google, Cloud SQL is more than 99.95% available from anywhere in the world.
The fact that Cloud SQL is fully managed only enhances its reliability. It takes automatic backups and replication a step further by providing automatic failover. This means if the Google Cloud server housing your Cloud SQL database crashes, your data is automatically moved to a standby server so it remains highly available to you.