percona
Percona Ansible Role
Ansible role installs percona xtradb, percona server, percona client, and percona toolkit.
Requirements: None
Dependencies: None
Role Variables
Common: used by percona server and percona xtradb task lists.
| Common | Description | Default |
|---|---|---|
| {{ percona_version }} | percona server version | 5.5 |
| {{ percona_server_version_pin }} | percona server version pin | 5.5.53-rel38.5-1.trusty |
| {{ percona_xtradb_version_pin }} | percona xtradb version pin | 5.5.41-25.12-855.trusty |
| {{ percona_db_user }} | percona system user | mysql |
| {{ default_storage_engine }} | database storage engine | InnoDB |
| {{ percona_data_dir }} | database data directory | /data/mysql |
| {{ percona_log_dir }} | info log directory | /var/log/mysql |
| {{ percona_error_log }} | error log file | /var/log/mysql/mysql-error.log |
| {{ percona_slow_log }} | slow log file | /var/log/mysql/mysql-slow.log |
Server: used exclusively by percona server tasks.
| Server | Description | Default |
|---|---|---|
| {{ percona_innodb_buffer_pool_size }} | innodb buffer pool size | 1G |
| {{ percona_mysql_read_only }} | slave read only mode | FALSE |
| {{ percona_server_sync_binlog }} | whether to sync binary logs | 1 |
| {{ percona_mysql_server_id }} | unique db identifier | 1 |
| {{ percona_bin_log_dir }} | binary log directory | /log/data/mysql |
| {{ percona_bin_log }} | binary log file | /log/data/mysql/mysql-bin |
| {{ percona_relay_log }} | relay log file | /log/data/mysql/mysql-relay-log |
xtradb: used exclusively by percona xtradb tasks.
| xtradb | Description | Default |
|---|---|---|
| {{ percona_wsrep_sst_auth }} | cluster node credentials | test_user:test_pass |
| {{ percona_binlog_format }} | binary log format | ROW |
| {{ percona_innodb_locks_unsafe_for_binlog }} | disable gap locking | 1 |
| {{ percona_autoinc_lock_mode }} | innodb increment lock mode | 2 |
| {{ percona_wsrep_sst_method }} | galera state transfer type | xtrabackup |
| {{ percona_wsrep_cluster_name }} | galera cluster name | Yo_Cluster_Rox |
| {{ percona_tmp_table_size }} | temporary table size | 32M |
| {{ percona_max_heap_table_size }} | heap memory size limit | 32M |
| {{ percona_query_cache_type }} | use query caching | OFF |
| {{ percona_query_cache_size }} | query cache size | 0 |
| {{ percona_max_connections }} | database connection limit | 2000 |
| {{ percona_thread_cache_size }} | thread cache size | 100 |
| {{ percona_open_files_limit }} | database open file limit | 65535 |
| {{ percona_table_definition_cache }} | table cache size | 4096 |
| {{ percona_table_open_cache }} | open table number for all database threads | 4096 |
| {{ percona_innodb_flush_method }} | innodb flush method | O_DIRECT |
| {{ percona_log_files_in_group }} | xtradb log files in group | 2 |
| {{ percona_flush_log_at_trx_commit }} | transaction log flush setting | 2 |
| {{ percona_innodb_file_per_table }} | db file per table setting | ON |
| {{ percona_buffer_pool_size }} | buffer pool size | 128M |
| {{ percona_log_queries_not_using_indexes }} | log queries not using indexes | 1 |
| {{ percona_slow_query_log }} | slow query log setting | 1 |
| {{ percona_transaction_isolation }} | transaction isolation level | READ-COMMITTED |
| {{ percona_innodb_read_io_threads }} | read io thread count | 64 |
| {{ percona_innodb_write_io_threads }} | write io thread count | 64 |
| {{ percona_wsrep_slave_threads }} | galera replication thread count | 64 |
| {{ percona_innodb_io_capacity }} | io operations limit | 2000 |
| {{ percona_innodb_flush_neighbor_pages }} | sequential page flush setting | cont |
| {{ percona_innodb_log_file_size }} | transaction log file size | 4G |
Galaxy Playbook Usage
- hosts: servers
roles:
- { role: MetaRed.percona, variable: value }
Tags
percona: Run both percona server and percona xtradb task lists.
percona-server: Run only percona server tasks.
percona-xtradb: Run only percona xtradb tasks.
ansible-playbook site.yml --tags=percona
Testing
ServerSpec: Integration test directories
test/integration/percona_server
test/integration/percona_xtradb
Authors
Authors: Richard Lopez