Deploying and Managing Cloud SQL
Cloud SQL is a managed relational database service. In this section, you will learn how to do the following:
- Create a database instance
- Connect to the instance
- Create a database
- Load data into the database
- Query the database
- Back up the database
We will use a MySQL instance in this section, but the following procedures are similar for PostgreSQL.
Creating and Connecting to a MySQL Instance
We described how to create and configure a MySQL instance in Chapter 11, but will review the steps here.
From the console, navigate to SQL and click Create Instance. Choose MySQL and then select Second Generation Instance type. This will lead to a form such as in Figure 12.1.
FIGURE 12.1 Creating a MySQL instance
After a few minutes, the instance is created; the MySQL list of instances will look similar to Figure 12.2.
FIGURE 12.2 A listing of MySQL instances
After the database is created, you can connect by starting Cloud Shell and using the gcloud sql...
