mariadb

Ansible Role: MariaDB

Install MariaDB, 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

mariadb_version: 10.1.22

mariadb_service_name: mysql
mariadb_secure_installation: True

mariadb_root_password: changeme

mariadb_server_path_utiles: /root/utiles

mariadb_path_backups: /home/db_backups/

mariadb_databases: []
# delete [] and define databases
# - database1
# - database2

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

mariadb_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_cache: 1000
  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: 500M
  slow_query_log: true
  long_query_time: 5
  log_slow_admin_statements: true
  log_queries_not_using_indexes: true

  mariadb_utiles_bd: false
  mariadb_cron_backup: false
  mariadb_cron_optimizacion: false

mariadb_cron_backup_db:
  minute: "15"
  hour: "3"
  day: "*"
  weekday: "*"

mariadb_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:
    mariadb_root_password: cambiame

    mariadb_databases:
      - mydatabase

    mariadb_users:
      user1:
        name: "usuario1"
        password: "clave1"
        priv: "mydatabase.*:ALL"

    mariadb_utiles_bd: true
    mariadb_cron_backup: true
    mariadb_cron_optimizacion: true

   roles:
     - { role: CarlosLongarela.mariadb }