concept mysql in category cloud

appears as: MySQL
Google Cloud Platform in Action

This is an excerpt from Manning's book Google Cloud Platform in Action.

The first thing is to go back to that MySQL command-line prompt. As you learned, you can do this by running the mysql command. Next up is to create the database by running this code:

With these three files, you should be able to connect securely to your Cloud SQL instance from most client libraries, because the major ones know what to do with them. For example, if you use the mysql library for Node.js, you can pass in a ca, cert, and key, as shown in the following listing.

As I discussed in chapter 1, one of the primary motivations for shifting toward the cloud was to reduce your overall TCO (total cost of ownership). Cloud SQL does this not necessarily by reducing the cost of the hardware, but by reducing your maintenance and management costs. For example, if you were running your own VM running MySQL, you’d need to find the time to upgrade your operating system and MySQL version for any new security patches that happen to come out (or accept the risk of your data being compromised, but I’ll assume you’d never do that).