Skip to content

mysql job from cf-mysql/23

Github source: c1e834fb or master branch

Properties

admin_password

Password for the MySQL server admin user

admin_username

Username for the MySQL server admin user

Default
root

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

ib_log_file_size

Size of the ib_log_file used by innodb, in MB

Default
1024

innodb_buffer_pool_size

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

network_name

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

port

Port the mysql server should bind to

Default
3306

seeded_databases

Set of databases to seed

Default
{}

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

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

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.