Skip to content

mysql job from cf-mysql/26

Github source: b2ebb913 or master branch

Properties

cf_mysql

mysql

admin_password

Password for the MySQL server admin user

admin_username

Username for the MySQL server admin user

Default
root
bootstrap_endpoint
password

Password used by the bootstrap endpoints for Basic Auth

username

Username used by the bootstrap endpoints for Basic Auth

cluster_ips

List of nodes. Must have the same number of ips as there are nodes in the cluster

database_startup_timeout

How long the startup script waits for the database to come online (in seconds)

gcache_size

Cache size used by galera (maximum amount of data possible in an IST), in MB

Default
512
healthcheck_port

Port used by healthcheck process to listen on

Default
9200
ib_log_file_size

Size of the ib_log_file used by innodb, in MB

Default
1024
innodb_buffer_pool_size

Optional, the size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables

max_connections

Maximum total number of database connections for the node

Default
1500
max_heap_table_size

The maximum size (in rows) to which user-created MEMORY tables are permitted to grow

Default
1.6777216e+07
port

Port the mysql server should bind to

Default
3306
roadmin_enabled

Whether read only user is enabled

Default
false
roadmin_password

Password for the MySQL server read-only admin user

seeded_databases

Set of databases to seed

Default
{}
skip_name_resolve

Do not restrict connections to database based on hostname

Default
true
tmp_table_size

The maximum size (in bytes) of internal in-memory temporary tables

Default
3.3554432e+07
wsrep_max_ws_rows

Maximum permitted number of rows per writeset.

Default
131072
wsrep_max_ws_size

Maximum permitted size in bytes per writeset.

Default
1.073741824e+09

network_name

The name of the network (needed for the syslog aggregator)

syslog_aggregator

address

IP address for syslog aggregator

all

Define whether forwarders should also send non-mysql syslog activity to the aggregator.

Default
false

port

TCP port of syslog aggregator

transport

Transport to be used when forwarding logs (tcp|udp|relp).

Default
tcp

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/galera-healthcheck_ctl (from galera-healthcheck_ctl.erb)
  • bin/gra-log-purger.sh (from gra-log-purger.sh.erb)
  • bin/gra-log-purger_ctl (from gra-log-purger_ctl.erb)
  • bin/mariadb_ctl (from mariadb_ctl.erb)
  • config/galera_healthcheck_config.yaml (from galera_healthcheck_config.yaml.erb)
  • config/mariadb_ctl_config.yml (from mariadb_ctl_config.yml.erb)
  • config/mariadb_init (from mariadb_init.erb)
  • config/my.cnf (from my.cnf.erb)
  • config/syslog_forwarder.conf (from syslog_forwarder.conf.erb)

Packages

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