Skip to content

mysql job from cf-mysql/16

Github source: 245cedc0 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

gcache_size

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

Default
512

haproxy_mysql_user

A user for HAProxy health check

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

network_name

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

port

Port the mysql server should bind to

Default
3306

proxy_ips

List of proxy node ip addresses

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

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)
  • bin/mysql_database_seed.sh (from mysql_database_seed.sh.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.