mysqlprovider

Overview ¶

pkg/provider/mysql/provider.go

MySQL provider for Orkestra.

Handles the "mysql" block in Katalog declarations. Uses database/sql with the go-sql-driver/mysql driver.

Supported resource kinds:

database — MySQL database / schema (create, drop)
user     — MySQL user (create, update password and privileges, drop)

Installation:

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

Registration:

p, err := mysqlprovider.NewFromAuth(ctx, auth)
registry.Register(p)

Auth keys (providers[].auth block):

host     — server hostname or IP (default: 127.0.0.1)
port     — server port (default: 3306)
user     — admin user (must have GRANT OPTION)
password — admin password
tls      — false | true | skip-verify | preferred (default: false)

Katalog:

providers:
  - name: mysql
    required: true
    auth:
      host: "$MYSQL_HOST"
      user: "$MYSQL_USER"
      password: "$MYSQL_PASSWORD"

operatorBox:
  providers:
    mysql:
      - database:
          name: "{{ .metadata.name }}"
          charset: utf8mb4
          collation: utf8mb4_unicode_ci

      - user:
          name: "{{ .spec.dbUser }}"
          host: "%"
          database: "{{ .metadata.name }}"
          privileges: "SELECT, INSERT, UPDATE, DELETE"
          credentials:
            secretName: "{{ .metadata.name }}-mysql-creds"   # MYSQL_PASSWORD key