CarlosLongarela.mariadb

Rôle Ansible : MariaDB

Installez MariaDB, options de sécurité de base et outils pour l'optimisation de la base de données et les sauvegardes avec des tâches cron.

Exigences

Aucune.

Changements

Installation de PhpMyAdmin supprimée, PhpMyAdmin a maintenant son propre rôle dans Galaxy : CarlosLongarela.phpmyadmin

Variables du rôle

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: []
# supprimez [] et définissez les bases de données
# - database1
# - database2

mariadb_users: []
# supprimez [] et définissez les utilisateurs
# 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

Dépendances

Aucune.

Exemple de Playbook

- hosts: serveurs

  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 }