Ansible playbook to install percona MySQL server in Debian/Ubuntu servers
None.
Available variables are listed below with its default values.
root_password: reallylongpassword
Define the MySQL root password, this password will be used to create a /root/.my.cnf to allow root mysql connections without password
port: 3306
bind_address: 0.0.0.0
Define port and bind address for MySQL connections
max_allowed_packet: 16M
key_buffer: 16M
thread_stack: 192K
thread_cache_size: 8
Define some values to tuning the database server
sqldebug: true
log_slow_queries: log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time: long_query_time = 2
log_queries_not_using_indexes: log-queries-not-using-indexes
If sqldebug is true this playbook will configure Percona MySQL with slow queries debug logs, if you want to disable this debug information you have to set sqldebug: false
create_app_db: true
db_name: mydatabase
db_collation: utf8_general_ci
db_user: myuser
db_user_password: anotherreallylongpassword
db_host: "%"
db_dump_file: ""
If create_app_db is true this playbook will configura an application database, you can set a path for a SQL dump file if you want to restore data in the new application database
None.
---
- hosts: all
user: vagrant
sudo: true
vars:
- db_name: mydb
- db_user: myuser
- db_host: localhost
- db_user_password: mypassword
- db_dump_file: /tmp/dump.sql.bz2
roles:
- overdrive3000.ansible-percona
MIT / BSD
This is my first playbook it is a beta version and can be improved, please help me to improve and fix bugs for this playbook.
Thanks.