如何仅在需要时运行 Google Cloud SQL? [英] How to run Google Cloud SQL only when I need it?

问题描述

Google Cloud SQL 宣称，对于最小的机器类型，每小时只需 0.0150 美元，而且我要按每小时收费，而不仅仅是我连接的小时数.这是因为我在使用游泳池吗?如何设置我的后端，使其仅在需要时查询云数据库，这样我就不会按一天中的每个小时收费?

Google Cloud SQL advertises that it's only $0.0150 per hour for the smallest machine type, and I'm being charged for every hour, not just hours that I'm connected. Is this because I'm using a pool? How do I setup my backend so that it queries the cloud db only when needed so I don't get charged for every hour of the day?

const mysql      = require('mysql');
const pool = mysql.createPool({
    host : process.env.SQL_IP,
    user     : 'root',
    password : process.env.SQL_PASS,
    database : 'mydb',
    ssl      : {
          [redacted]
    }
});

function query(queryStatement, cB){
  pool.getConnection(function(err, connection) {
    // Use the connection
    connection.query(queryStatement, function (error, results, fields) {
      // And done with the connection.
      connection.destroy();
      // Callback
      cB(error,results,fields);

    });
  });
}

推荐答案

这与其说是关于池，不如说是关于 Cloud SQL 的性质.与 App Engine 不同，Cloud SQL 实例始终启动.在我离开项目一周后的一个星期六早上，我艰难地了解到了这一点.:)

This is not so much about the pool as it is about the nature of Cloud SQL. Unlike App Engine, Cloud SQL instances are always up. I learned this the hard way one Saturday morning when I'd been away from the project for a week. :)

除非您明确停止服务，否则无法在不使用它们时停止它们.

There's no way to spin them down when they're not being used, unless you explicitly go stop the service.

无法安排服务停止，至少在 GCP SDK 中是这样.您总是可以编写一个 cron 作业，或类似的东西，在例如当地时间下午 6 点，M-F 运行一些 gcloud sql instances patch [INSTANCE_NAME] --activation-policy NEVER 命令.我懒得这样做，所以我只是为自己设置了一个日历提醒，在我的工作日结束时关闭我的实例.

There's no way to schedule a service stop, at least within the GCP SDK. You could alway write a cron job, or something like that, that runs a little gcloud sql instances patch [INSTANCE_NAME] --activation-policy NEVER command at, for example, 6pm local time, M-F. I was too lazy to do that, so I just set a calendar reminder for myself to shut down my instance at the end of my workday.

这是当前 SDK 文档的 MySQL 实例启动/停止/重启页面:https://cloud.google.com/sql/docs/mysql/start-stop-restart-instance

Here's the MySQL Instance start/stop/restart page for the current SDK's docs: https://cloud.google.com/sql/docs/mysql/start-stop-restart-instance

另外请注意，GCP 平台中有一个正在进行的功能请求"以启动/也根据流量停止 Cloud SQL(第 2 代).您还可以访问链接并在那里提供您宝贵的建议/意见.

On an additional note, there is an ongoing 'Feature Request' in the GCP Platform to start/stop the Cloud SQL (2nd Gen), according to the traffic as well. You can also visit the link and provide your valuable suggestions/comments there as well.

这篇关于如何仅在需要时运行 Google Cloud SQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！