将Google Cloud app Engine上的Node.js app连接到Google Cloud SQL实例

包括 beta_settings 到 app.yaml socketPath 在里面 config ,以便您的flex应用程序可以通过代理连接到实例。

短道 应该在里面 配置 仅当应用程序正在应用程序引擎上的生产环境中运行时。对于本地开发,TCP套接字用于代理客户端,您需要安装该客户端并从以下命令开始:

wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy

chmod +x cloud_sql_proxy

./cloud_sql_proxy -instances=<INSTANCE_CONNECTION_NAME>=tcp:3306

if 语句允许应用程序自动切换配置dev local/prod appengine, using environment variables .

应用程序yaml

runtime: nodejs
env: flex
env_variables:
  SQL_USER: [SQL_USER]
  SQL_PASSWORD: [SQL_PASSWORD]
  SQL_DATABASE: [DATABASE_NAME]
  INSTANCE_CONNECTION_NAME: [INSTANCE_CONNECTION_NAME]
beta_settings:
  cloud_sql_instances: [INSTANCE_CONNECTION_NAME]

{
  "engines": {
    "node": "8.x.x"
  },
  "dependencies": {
    "express": "4.16.3",
    "mysql": "^2.15.0"
  },
  "scripts": {
    "start": "node server.js"
  }
}

服务器.js

const express = require('express');
const mysql = require('mysql');

const app = express();

var config = {
    user: process.env.SQL_USER,
    database: process.env.SQL_DATABASE,
    password: process.env.SQL_PASSWORD
}

if (process.env.INSTANCE_CONNECTION_NAME && process.env.NODE_ENV === 'production') {
    config.socketPath = `/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}`;
  }

var connection = mysql.createConnection(config);

connection.connect();

app.get('/', (req, res) => {
    connection.query(
        'SELECT * FROM entries', function(err, result, fields){
            if (err) throw err;
            res.send(result);
        }
    );
});

const PORT = process.env.PORT || 8080;
app.listen(PORT, () => {
  console.log(`App listening on port ${PORT}`);
  console.log('Press Ctrl+C to quit.');
});

有两种连接方式 Cloud SQL

例如 postgresql

1. 使用公共IP和 psql https://cloud.google.com/sql/docs/postgres/connect-admin-ip

   a、 将外部IP添加到 云SQL CONNECTIONS - Authorized networks

   connection.host 到 云SQL 实例公用IP

2. cloud_sql_proxy 工具和 INSTANCE_CONNECTION_NAME https://cloud.google.com/sql/docs/postgres/connect-admin-proxy