As the name suggests, Cloud SQL is an RDBMS offering on GCP.
But with several advantages that arise from its cloud-based nature, which are as follows:
- It is implemented on cloud, so we do not need to physically set up systems and VMs. This makes it far more attractive than running an RDBMS on a VM (that would be the IaaS approach, Cloud SQL is a PaaS approach).
- It is mostly managed by Google, so we do not have to bother about common database management tasks such as backups and archival.
- Even if we are already using another form of RDBMS, migrating to Cloud SQL is relatively simple and reliable.
- Like all the other services on the GCP, Cloud SQL instances are scalable and customizable.
- Cloud SQL currently supports two open source RDBMS: MySQL and PostgreSQL where the choice depends on our structure of data.
- It provides strong ACID support.
As we mentioned earlier...
