Loading Data into Google Cloud SQL

Cloud SQL

• Cloud SQL manages your database instance.
• Cloud SQL provides a cloud-based alternative to local MySQL, PostgreSQL, and SQL Server databases.
• Many applications running on Compute Engine, App Engine, and other services in Google Cloud use Cloud SQL for database storage.

Cloud SQL instance

• Each Cloud SQL instance is powered by a virtual machine (VM) running on a host Google Cloud server.
• Each VM operates the database program, such as MySQL Server, PostgreSQL, or SQL Server, and service agents that provide supporting services, such as logging and monitoring. The high availability option also provides a standby VM in another zone with a configuration that’s identical to the primary VM.
• The database is stored on a scalable, durable network storage device called a persistent disk that attaches to the VM. A static IP address sits in front of each VM to ensure that the IP address an application connects to persists throughout the lifetime of the Cloud SQL instance.

Cloud SQL instance overview:

In the below video you will learn how to:

• Create a Cloud SQL instance
• Create a Cloud SQL database
• Import text data into Cloud SQL