Skip to content

mysql job from pxc/0.5.0

Github source: 8b80628 or master branch

Properties

admin_password

Password for the MySQL server admin user

audit_log

enabled

If the Audit Log should be enabled

Default
false

broker_admin_password

Password for broker-admin user

cf-mysql-backup

backup-server

port

Port number used for sending backup requests

Default
8081

endpoint_credentials

password

Password used by backup client to stream a backup from the mysql node

username

Username used by backup client to stream a backup from the mysql node

default_char_set

The character set configuration for the MySQL server

Default
utf8

default_collation

The collation configuration for the MySQL server

default_schema

A default schema to create

enable_lower_case_table_names

Enable or disable the “lower_case_table_names” MySQL server variable via a boolean of true/false.

enforce_client_tls

Require a secure transport for all client connections to the MySQL database server

Default
false

leader_follower

enabled

Indicate that the VM is spun up with the intention of replication

Default
false

replication_mode

Which replication mode to use of asynchronous (async) or semi-synchronous (semi-sync)

Default
async

semi_sync_ack_timeout_in_ms

The acknowledgment timeout before the replication mode will fall back to asynchronous

Default
9.223372036854776e+18

local_infile

Enable the ability to send files from the client host

Default
false

mysql_backup_password

Password for mysql-backup user

mysql_metrics_password

Password for the MySQL metrics user

mysql_tls

MySQL Server TLS configuration

Example
properties:
  mysql_tls: ((my_generated_certificate))
variables:
- name: my_generated_certificate
  options:
    ca: /services/tls_ca
    common_name: some-common-name
    extended_key_usage:
    - server_auth
  type: certificate

read_only_admin_password

Password for the MySQL server read-only admin user

replication_admin_password

Password for the MySQL replication-admin user

replication_password

Password for the MySQL replication user

userstat

enabled

Enables collection of user statistics

Default
false

workload

Workload configuration. Can be one of “mixed,read-heavy”

Default
mixed

Templates

Templates are rendered and placed onto corresponding instances during the deployment process. This job's templates will be placed into /var/vcap/jobs/mysql/ directory (learn more).

  • bin/drain (from drain.erb)
  • bin/mysql_ctl (from mysql_ctl.erb)
  • bin/post-start (from post-start.erb)
  • bin/pre-start (from pre-start.erb)
  • bin/restore (from restore.erb)
  • config/my.cnf (from my.cnf.erb)
  • config/mylogin.cnf (from mylogin.cnf.erb)
  • config/thermostat.yml (from thermostat.yml.erb)
  • certificates/ca.pem (from mysql_tls_ca.pem.erb)
  • certificates/server-cert.pem (from mysql_tls_certificate.pem.erb)
  • certificates/server-key.pem (from mysql_tls_private_key.pem.erb)
  • scripts/init.sql (from init.sql.erb)

Packages

Packages are compiled and placed onto corresponding instances during the deployment process. Packages will be placed into /var/vcap/packages/ directory.