Skip to content
This repository has been archived by the owner on Nov 16, 2019. It is now read-only.

Ansible playbook to install percona MySQL server

Notifications You must be signed in to change notification settings

npm/ansible-percona

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Ansible Role: Percona

Ansible playbook to install Percona MySQL server on Debian/Ubuntu servers

Requirements

None.

Role Variables

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

Dependencies

None.

Example Playbook

---
- 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

License

MIT / BSD

Notes

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.

About

Ansible playbook to install percona MySQL server

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published