CarlosLongarela.percona
Ansible Role: Percona Server
Install Percona Server, basic security options and utils for database tuning and backups with cron tasks.
Requirements
None.
Changes
Deleted PhpMyAdmin installation, now PhpMyAdmin has it's own role in Galaxy: CarlosLongarela.phpmyadmin
Role Variables
percona_version: 5.7
percona_service_name: mysql
percona_secure_installation: True
percona_root_password: changeme
percona_server_path_utiles: /root/utiles
percona_path_backups: /home/db_backups/
percona_databases: []
# delete [] and define databases
# - database1
# - database2
percona_users: []
# delete [] and define databases
# user1:
# name: "usuario1"
# password: "clave1"
# priv: "*.*:ALL"
# user2:
# name: "usuario2"
# password: "clave2"
# priv: "db.table:priv1,priv2"
# user3:
# name: "usuario3"
# password: "clave3"
# priv: "bdpruebas.*:ALL"
percona_options:
bind_address: '127.0.0.1'
performance_schema: on
skip_name_resolve: 1
max_connections: 100
connect_timeout: 2
max_allowed_packet: 10M
innodb_buffer_pool_instances: 1
innodb_buffer_pool_size: 100M
innodb_log_file_size: 25M
table_open_cache: 500
tmp_table_size: 50M
max_heap_table_size: 50M
query_cache_limit: 256K
query_cache_type: 0
query_cache_size: 0
query_cache_min_res_unit: 2k
join_buffer_size: 2M
sort_buffer_size: 256K
read_buffer_size: 128K
read_rnd_buffer_size: 4M
key_buffer_size: 500M
slow_query_log: true
long_query_time: 5
log_slow_admin_statements: true
log_queries_not_using_indexes: true
percona_utiles_bd: false
percona_cron_backup: false
percona_cron_optimizacion: false
percona_cron_backup_db:
minute: "15"
hour: "3"
day: "*"
weekday: "*"
percona_cron_optimiza_db:
minute: "1"
hour: "3"
day: "*"
weekday: "0"
aptget_update_cache_valid_time: 3600
Dependencies
None.
Example Playbook
- hosts: servers
gather_facts: no
become: true
vars:
percona_root_password: cambiame
percona_databases:
- mydatabase
percona_users:
user1:
name: "usuario1"
password: "clave1"
priv: "mydatabase.*:ALL"
percona_utiles_bd: true
percona_cron_backup: true
percona_cron_optimizacion: true
roles:
- { role: CarlosLongarela.percona }
License
GPLv3
Author Information
This role was created in 2018, November by Carlos Longarela, from Taberna WordPress.
About
Installation, secure and configuration for Percona Server.
Install
ansible-galaxy install CarlosLongarela.perconaLicense
Unknown
Downloads
72
Owner
Husband, father, geek... Photography magazine @fotodng creator. Freelance WordPress developer and consultant at @codeablehq and https://tabernawp.com
