MetaRed.percona

Percona Ansible Role

![Ansible Role: version](https://img.shields.io/badge/Ansible Role-v0.0.3-blue.svg)

This Ansible role sets up Percona XtraDB, Percona Server, Percona Client, and Percona Toolkit.

Requirements: None

Dependencies: None

Role Variables

Common: Used by both Percona Server and Percona XtraDB tasks.

Common Variable	Description	Default Value
`{{ percona_version }}`	Version of Percona Server	`5.5`
`{{ percona_server_version_pin }}`	Specific version of Percona Server	`5.5.53-rel38.5-1.trusty`
`{{ percona_xtradb_version_pin }}`	Specific version of Percona XtraDB	`5.5.41-25.12-855.trusty`
`{{ percona_db_user }}`	System user for Percona	`mysql`
`{{ default_storage_engine }}`	Default database storage engine	`InnoDB`
`{{ percona_data_dir }}`	Directory for database data	`/data/mysql`
`{{ percona_log_dir }}`	Directory for info logs	`/var/log/mysql`
`{{ percona_error_log }}`	File for error logs	`/var/log/mysql/mysql-error.log`
`{{ percona_slow_log }}`	File for slow queries	`/var/log/mysql/mysql-slow.log`

Server: Used only by Percona Server tasks.

Server Variable	Description	Default Value
`{{ percona_innodb_buffer_pool_size }}`	Size of InnoDB buffer pool	`1G`
`{{ percona_mysql_read_only }}`	Slave mode for reading only	`FALSE`
`{{ percona_server_sync_binlog }}`	Sync binary logs	`1`
`{{ percona_mysql_server_id }}`	Unique database identifier	`1`
`{{ percona_bin_log_dir }}`	Directory for binary logs	`/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 only by Percona XtraDB tasks.

xtradb Variable	Description	Default Value
`{{ percona_wsrep_sst_auth }}`	Cluster node credentials	`test_user:test_pass`
`{{ percona_binlog_format }}`	Format for binary logs	`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 method	`xtrabackup`
`{{ percona_wsrep_cluster_name }}`	Name of Galera cluster	`Yo_Cluster_Rox`
`{{ percona_tmp_table_size }}`	Size of temporary tables	`32M`
`{{ percona_max_heap_table_size }}`	Limit for heap memory size	`32M`
`{{ percona_query_cache_type }}`	Use query caching	`OFF`
`{{ percona_query_cache_size }}`	Size of the query cache	`0`
`{{ percona_max_connections }}`	Maximum database connections	`2000`
`{{ percona_thread_cache_size }}`	Size of thread cache	`100`
`{{ percona_open_files_limit }}`	Limit for open database files	`65535`
`{{ percona_table_definition_cache }}`	Size of table cache	`4096`
`{{ percona_table_open_cache }}`	Open table count for threads	`4096`
`{{ percona_innodb_flush_method }}`	InnoDB flush method	`O_DIRECT`
`{{ percona_log_files_in_group }}`	xtradb log files group count	`2`
`{{ percona_flush_log_at_trx_commit }}`	Transaction log flush setting	`2`
`{{ percona_innodb_file_per_table }}`	File per table setting	`ON`
`{{ percona_buffer_pool_size }}`	Size of buffer pool	`128M`
`{{ percona_log_queries_not_using_indexes }}`	Log queries without indexes	`1`
`{{ percona_slow_query_log }}`	Slow query log setting	`1`
`{{ percona_transaction_isolation }}`	Transaction isolation level	`READ-COMMITTED`
`{{ percona_innodb_read_io_threads }}`	Count of read IO threads	`64`
`{{ percona_innodb_write_io_threads }}`	Count of write IO threads	`64`
`{{ percona_wsrep_slave_threads }}`	Count of Galera replication threads	`64`
`{{ percona_innodb_io_capacity }}`	Limit of IO operations	`2000`
`{{ percona_innodb_flush_neighbor_pages }}`	Sequential page flush setting	`cont`
`{{ percona_innodb_log_file_size }}`	Size of transaction log file	`4G`

Galaxy Playbook Usage

- hosts: servers
  roles:
     - { role: MetaRed.percona, variable: value }

Testing

ServerSpec: Directories for integration tests

test/integration/percona_server
test/integration/percona_xtradb

Authors

Author: Richard Lopez

Informazioni sul progetto

Installs percona xtradb, percona server, percona client, and percona toolkit.

role database linux mysql percona xtradb

Installa

ansible-galaxy install MetaRed.percona

GitHub repository

0 stelle

0 fork

0 problemi aperti

Licenza

other

Download

129

Proprietario

MetaRed