mysql-clustered job from pxc/0.3.0

Github source: e8d2732 or master branch

Properties¶

`admin_password`¶

Password for the MySQL server admin user

`admin_username`¶

Username for the MySQL server admin user

Default

root

`advertise_host`¶

Optional. IP address used to reach mysql from other cluster members If not provided, the IP is automatically determined.

`binlog_enabled`¶

Enable binlogs across all nodes

Default

true

`binlog_expire_days`¶

Time in days to store binlogs before purging

Default

`character_set_server`¶

Default character set. Note that while the MySQL default is latin1, we default to utf8.

Default

utf8

`cli_history`¶

When set to false, disables cli history on the mysql vms.

Default

true

`cluster_health`¶

log_interval¶

Time in seconds between log entries for cluster health
Default
30
password¶

Password for the cluster logger health user

`cluster_name`¶

A unique name for this cluster. ONLY set before first deployment. DO NOT attempt to change an existing multi-node cluster.

Default

galera-cluster

`cluster_probe_timeout`¶

The maximum time, in seconds, that a new node will search for an existing cluster.

Default

`collation_server`¶

Default collation. Use SHOW COLLATION to view the valid collations for your character set.

Default

utf8_unicode_ci

`enable_local_file`¶

Allow or disallow clients to access local files

Default

true

`event_scheduler`¶

Events are named database objects containing SQL statements that are to be executed at a later stage, either once off, or at regular intervals.

Default

"OFF"

`galera_agent`¶

db_password¶

Password used by the sidecar to connect to the database

endpoint_password¶

Password used by the sidecar endpoints for Basic Auth

endpoint_username¶

Username used by the sidecar endpoints for Basic Auth
Default
galera-agent
port¶

Port used by sidecar process to listen on
Default
9200

`galera_port`¶

Port which Galera Cluster uses for communication across nodes

Default

`gcache_size`¶

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

Default

`ib_log_file_size`¶

Size of the ib_log_file used by innodb, in MB

Default

`innodb_buffer_pool_instances`¶

Optional, number of buffer pool instances for InnoDB used if innodb_buffer_pool_size > 1GB

`innodb_buffer_pool_size`¶

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

`innodb_buffer_pool_size_percent`¶

Set this to an integer which represents the percentage of system RAM to reserve for InnoDB’s buffer pool

Default

`innodb_flush_log_at_trx_commit`¶

Optional, control balance between performance and full ACID compliance. Valid values are: 0, 1, 2

Default

`innodb_flush_method`¶

Advanced configuration variable, consult the documentation before changing. Controls how MySQL opens data files; by default uses fsync(). Set to O_DIRECT if innodb_buffer_pool is sufficiently large that you can use O_DIRECT thus avoiding double-buffering.

`innodb_large_prefix_enabled`¶

Whether innodb_large_prefix is enabled

Default

true

`innodb_lock_wait_timeout`¶

Optional, time in seconds that an InnoDB transaction waits for an InnoDB row lock

`innodb_log_buffer_size`¶

Size in bytes of the buffer for writing log files to disk. Increasing this means larger transactions can run without needing to perform disk I/O before committing.

Default

32M

`innodb_strict_mode`¶

Whether innodb_strict_mode is enabled

Default

false

`log_conflicts`¶

Defines whether the node logs additional information about conflicts. The values that were in conflict are logged, so it is possible for user data to end up in the logs.

Default

true

`log_queries_not_using_indexes`¶

Queries that don’t use an index, or that perform a full index scan where the index doesn’t limit the number of rows, will be logged to the slow query log.

Default

false

`long_query_time`¶

Threshold in seconds above which SQL queries get logged in the slow query log file

Default

`max_allowed_packet`¶

The maximum size in bytes of a packet or a generated/intermediate string

Default

256M

`max_connections`¶

Maximum total number of database connections for the node

Default

`max_heap_table_size`¶

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

Default

1.6777216e+07

`max_open_files`¶

Configure this number to be comfortably larger than the maximum number of tables you expect the database to support.

Default

`port`¶

Port the mysql server should bind to

Default

`previous_admin_username`¶

Optional. Previous username of the MySQL server admin user to be removed. Use this when changing the admin_username to avoid leaving around an unused user with root access.

`pxc_enabled`¶

Default

true

`remote_admin_access`¶

When enabled, admin and roadmin will be able to connect from any remote host.

Default

false

`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

{}

Example

|+
  - name: db1
    username: user1
    password: pw1
  - name: db2
    username: user2
    password: pw2

`server_audit_excluded_users`¶

Database users to exclude from audit logging

Default

[]

Example

|+
  - monitoring_user
  - other_excluded_user
  - bot_user

`server_audit_excluded_users_csv`¶

Additional database users to exclude from audit logging, will be combined with uses specified in server_audit_excluded_users

`server_audit_file_rotate_size_in_mb`¶

Size in MB of each audit log file

Default

`server_audit_file_rotations`¶

Number of audit file rotations to keep

Default

`server_audit_logs_enabled`¶

Enable audit logging

Default

false

`skip_name_resolve`¶

Do not restrict connections to database based on hostname

Default

true

`startup_timeout`¶

Number of seconds that monit should wait for mysql to start before giving up

Default

`table_definition_cache_size`¶

Set this to a number relative to the number of tables the server will manage.

Default

`table_open_cache`¶

Configure the number of table handles to keep open

Default

`tls`¶

galera¶

ca¶

CA Certificate which signed the galera server certificate

certificate¶

Server certificate for galera cluster encryption

private_key¶

Private key for galera cluster encryption

server¶

ca¶

CA Certificate which signed the server certificate

certificate¶

Server certificate for mysql server encryption

private_key¶

Private key for mysql server encryption

`tmp_table_size`¶

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

Default

3.3554432e+07

`userstat`¶

Enables user statistics, adding several new information schema tables and new FLUSH and SHOW commands.

Default

false

`wsrep_debug`¶

When set to on, enables additional debugging output for the database server error log.

Default

"OFF"

`wsrep_max_ws_rows`¶

Maximum permitted number of rows per writeset.

Default

`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-clustered/ directory (learn more).

bin/cluster_health_logger_ctl (from cluster_health_logger_ctl.sh.erb)
bin/galera-agent-ctl (from galera-agent-ctl.erb)
bin/pre-start (from pre-start.sh.erb)
bin/pre-start-execution (from pre-start-execution.sh.erb)
bin/pxc-ctl (from pxc-ctl.erb)
config/cluster_health_logger_config.yml (from cluster_health_logger_config.yml.erb)
config/cluster_health_logger_setup.sql (from cluster_health_logger_setup.sql.erb)
config/db_init (from db_init.erb)
config/disable_mysql_cli_history.sh (from disable_mysql_cli_history.sh.erb)
config/galera-agent-config.yaml (from galera-agent-config.yaml.erb)
config/galera-agent-setup.sql (from galera-agent-setup.sql.erb)
config/galera-init-config.yml (from galera-init-config.yml.erb)
config/my.cnf (from my.cnf.erb)
config/mylogin.cnf (from mylogin.cnf.erb)
config/mysql_clustered_audit_logs.logrotate (from audit_logs.logrotate.erb)
certificates/galera-ca.pem (from galera-ca.pem.erb)
certificates/galera-cert.pem (from galera-cert.pem.erb)
certificates/galera-key.pem (from galera-key.pem.erb)
certificates/server-ca.pem (from server-ca.pem.erb)
certificates/server-cert.pem (from server-cert.pem.erb)
certificates/server-key.pem (from server-key.pem.erb)

Packages¶

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

mysql-clustered job from pxc/0.3.0

Properties¶

admin_password¶

admin_username¶

advertise_host¶

binlog_enabled¶

binlog_expire_days¶

character_set_server¶

cli_history¶

cluster_health¶

log_interval¶

password¶

cluster_name¶

cluster_probe_timeout¶

collation_server¶

enable_local_file¶

event_scheduler¶

galera_agent¶

db_password¶

endpoint_password¶

endpoint_username¶

port¶

galera_port¶

gcache_size¶

ib_log_file_size¶

innodb_buffer_pool_instances¶

innodb_buffer_pool_size¶

innodb_buffer_pool_size_percent¶

innodb_flush_log_at_trx_commit¶

innodb_flush_method¶

innodb_large_prefix_enabled¶

innodb_lock_wait_timeout¶

innodb_log_buffer_size¶

innodb_strict_mode¶

log_conflicts¶

log_queries_not_using_indexes¶

long_query_time¶

max_allowed_packet¶

max_connections¶

max_heap_table_size¶

max_open_files¶

port¶

previous_admin_username¶

pxc_enabled¶

remote_admin_access¶

roadmin_enabled¶

roadmin_password¶

seeded_databases¶

server_audit_excluded_users¶

server_audit_excluded_users_csv¶

server_audit_file_rotate_size_in_mb¶

server_audit_file_rotations¶

server_audit_logs_enabled¶

skip_name_resolve¶

startup_timeout¶

table_definition_cache_size¶

table_open_cache¶

tls¶

galera¶

ca¶

certificate¶

private_key¶

server¶

ca¶

certificate¶

private_key¶

tmp_table_size¶

userstat¶

wsrep_debug¶

wsrep_max_ws_rows¶

wsrep_max_ws_size¶

Templates¶

Packages¶

`admin_password`¶

`admin_username`¶

`advertise_host`¶

`binlog_enabled`¶

`binlog_expire_days`¶

`character_set_server`¶

`cli_history`¶

`cluster_health`¶

`log_interval`¶

`password`¶

`cluster_name`¶

`cluster_probe_timeout`¶

`collation_server`¶

`enable_local_file`¶

`event_scheduler`¶

`galera_agent`¶

`db_password`¶

`endpoint_password`¶

`endpoint_username`¶

`port`¶

`galera_port`¶

`gcache_size`¶

`ib_log_file_size`¶

`innodb_buffer_pool_instances`¶

`innodb_buffer_pool_size`¶

`innodb_buffer_pool_size_percent`¶

`innodb_flush_log_at_trx_commit`¶

`innodb_flush_method`¶

`innodb_large_prefix_enabled`¶

`innodb_lock_wait_timeout`¶

`innodb_log_buffer_size`¶

`innodb_strict_mode`¶

`log_conflicts`¶

`log_queries_not_using_indexes`¶

`long_query_time`¶

`max_allowed_packet`¶

`max_connections`¶

`max_heap_table_size`¶

`max_open_files`¶

`port`¶

`previous_admin_username`¶

`pxc_enabled`¶

`remote_admin_access`¶

`roadmin_enabled`¶

`roadmin_password`¶

`seeded_databases`¶

`server_audit_excluded_users`¶

`server_audit_excluded_users_csv`¶

`server_audit_file_rotate_size_in_mb`¶

`server_audit_file_rotations`¶

`server_audit_logs_enabled`¶

`skip_name_resolve`¶

`startup_timeout`¶

`table_definition_cache_size`¶

`table_open_cache`¶

`tls`¶

`galera`¶

`ca`¶

`certificate`¶

`private_key`¶

`server`¶

`ca`¶

`certificate`¶

`private_key`¶

`tmp_table_size`¶

`userstat`¶

`wsrep_debug`¶

`wsrep_max_ws_rows`¶

`wsrep_max_ws_size`¶