APP Engine Laravel fast step-by-step Connect to Private IP Cloud SQL with Serverless VPC Access Google Cloud Platforms (GCP)

Hai, kali ini saya akan sedikit sharing mengenai cara konek ke IP Private SQL Cloud pada Google Cloud Platforms (GCP), berikut skenario yang akan dibuat:

[1] Pada app.yaml rubah dan sesuaikan seperti dibawah ini:

runtime: php73
env_variables:  
## Put production environment variables here.  
  APP_KEY: gantidenganappkey
  APP_STORAGE: /tmp  
  VIEW_COMPILED_PATH: /tmp  
  SESSION_DRIVER: cookie
  CLOUD_SQL_USERNAME: userilmuprogram
  CLOUD_SQL_PASSWORD: passwordilmuprogram
  CLOUD_SQL_DATABASE_NAME: dbilmuprogram
  CLOUD_SQL_CONNECTION_NAME: connectionnamepadacloudsql

vpc_access_connector:
  name: projects/gantidenganidproject/locations/gantidenganregion/connectors/gantidengannamavpcconnectornya

[2] Pada .env rubah dan sesuaikan seperti dibawah ini:

DB_CONNECTION=mysql
DB_HOST=IP_PRIVATE_ANDA
DB_PORT=3306
DB_DATABASE=dbilmuprogram
DB_USERNAME=userilmuprogram
DB_PASSWORD=passwordilmuprogram

[3] Masuk ke Cloud SQL dan centang IP Private

[4] Masuk ke VPC Network, pilih Serverless VPC Access lalu buat Koneksi Serverless VPC Connector

[5] Lalu masukkan data yang dibutuhkan

[6] klik tombol Create
[7] Deploy Apps Engine Anda
[9] Done

Leave a Comment Cancel reply