source .envrc
go get github.com/go-sql-driver/mysql

[Postgres] _ "github.com/lib/pq"
[MySQL] _ "github.com/go-sql-driver/mysql"

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.36</version>
</dependency>

[Postgres] const PostgresDriverName = "postgres"
[MySQL] const DatasourceDriverName = "mysql"

[Postgres] value: json
[MySQL] value: text

[Postgres] type: varchar
[MySQL] type: varchar(255) 

[Postgres] INSERT INTO table(col1, col2, col3, col4, col5) values($1, $2, $3, $4, $5)
[MySQL] INSERT INTO table(col1, col2, col3, col4, col5) values(?, ?, ?, ?, ?)

npm install mysql

---
default_db: 
  databases:
    - {name: autoscaler, tag: default}
  db_scheme: mysql
  port: 3306
  roles:
    - {name: root, password: password, tag: default}

  - name: cf-mysql
    url: https://bosh.io/d/github.com/cloudfoundry/cf-mysql-release?v=32
    version: '32'
    sha1: a41bb2cadd4311bc9977ccc2c1fca07ba41ccef2

jobs:
  - name: mysql 
    instances: (( instance_count_overrides.mysql.instances || 1 ))
    update:
      serial: true
    resource_pool: default
    networks:
      - name: default
    templates:
      - name: consul_agent
        release: cf
        consumes: {consul_client: nil, consul_server: nil, consul_common: nil}
      - name: mysql
        release: cf-mysql
    properties:
      cf_mysql:
        mysql:
          admin_password: password
          port: 3306
          binlog_enabled: false
          cluster_health:
            password: password
          galera_healthcheck:
            db_password: password
            endpoint_username: galera_healthcheck
            endpoint_password: password
          seeded_databases:
          - name: autoscaler
            username: root
            password: password
      consul:
        agent:
          mode: client
          services:
            mysql:
              check:
                tcp: 127.0.0.1:3306
                interval: 30s
                timeout: 10s

- app-autoscaler/src/github.com/go-sql-driver/mysql/*.go

[Postgres] java -cp "/var/vcap/packages/db/target/lib/*" liquibase.integration.commandline.Main --url jdbc:postgresql://$HOST:$PORT/$DBNAME --username=$USER --password=$PASSWORD \
--driver=org.postgresql.Driver --changeLogFile=/var/vcap/packages/eventgenerator/dataaggregator.db.changelog.yml update

[MySQL] java -cp "/var/vcap/packages/db/target/lib/*" liquibase.integration.commandline.Main --url jdbc:mysql://$HOST:$PORT/$DBNAME --username=$USER --password=$PASSWORD \
--driver=com.mysql.jdbc.Driver --changeLogFile=/var/vcap/packages/eventgenerator/dataaggregator.db.changelog.yml update

[Postgres] postgres.service.cf.internal
[MySQL] mysql.service.cf.internal

[Postgres] db_url = db_scheme://db_role['name']:db_role['password']@db_address:db_port.to_s/db_database['name']?sslmode=disable
[MySQL] db_url = db_role['name'] :db_role['password']@tcp(db_address:db_port.to_s)/db_database['name']