Rôle Ansible MariaDB

Ce rôle installe et configure MariaDB.

Exigences

Ce rôle nécessite Ansible 1.6 ou supérieur et les exigences de la plateforme sont listées dans le fichier de métadonnées.

Variables du Rôle

Les variables qui peuvent être passées à ce rôle :

# Dépôt MariaDB
mariadb_set_repository: True
mariadb_version: 10.4
mariadb_repo: 'deb https://ftp.harukasan.org/mariadb/repo/{{mariadb_version}}/debian {{ansible_distribution_release}} main'
mariadb_repo_key_url: https://mariadb.org/mariadb_release_signing_key.asc

# Paquets MariaDB
mariadb_package_client: mariadb-client
mariadb_package_server: mariadb-server

# Service MariaDB
mariadb_manage_service: True
mariadb_service_name: mysql

# Outils MariaDB/MySQL
mariadb_install_tools: False

# Utilisateurs MariaDB
mariadb_user_home: /root
mariadb_root_username: root
mariadb_root_password: root
mariadb_client_port: 3306

# Configuration MariaDB
mariadb_configuration: /etc/mysql/my.cnf
mariadb_includedir: /etc/mysql/conf.d/

# Variables de configuration
mariadb_datadir: /var/lib/mysql

mariadb_default_config:
  - name: 'client'
    config:
      - port = {{mariadb_client_port}}
      - socket = /var/run/mysqld/mysqld.sock
  - name: 'mysqld_safe'
    config:
      - safe_socket = /var/run/mysqld/mysqld.sock
      - safe_nice = 0
  - name: 'mysqld'
    config:
      - user = mysql
      - pid_file = /var/run/mysqld/mysqld.pid
      - socket = /var/run/mysqld/mysqld.sock
      - port = 3306
      - basedir = /usr
      - datadir = "{{mariadb_datadir}}"
      - tmpdir = /tmp
      - skip_external_locking = True
      - bind_address = 127.0.0.1
      - key_buffer = 16M
      - max_allowed_packet = 16M
      - thread_stack = 192K
      - thread_cache_size = 8
      - myisam_recover = BACKUP
      - max_connections = 1000
      - query_cache_limit = 1M
      - query_cache_size = 16M
      - general_log_file = /var/log/mysql/mysql.log
      - general_log = 0
      - slow_query_log = 0
      - slow_query_log_file = /var/log/mysql/mysql-slow.log
      - long_query_time = 1
      - log_queries_not_using_indexes = False
      - default_storage_engine = InnoDB
      - innodb_buffer_pool_size = 128M
      - innodb_log_file_size = 128M
      - innodb_log_buffer_size = 8M
      - innodb_thread_concurrency = 64
      - innodb_read_io_threads = 16
      - innodb_write_io_threads = 16
      - innodb_file_per_table = 1
      - innodb_open_files = 400
      - innodb_io_capacity = 600
      - innodb_lock_wait_timeout = 60
      - innodb_flush_method = O_DIRECT
      - innodb_doublewrite = 0
      - innodb_use_native_aio = 0
      - server_id = 1
      - log_bin = /var/log/mysql/mysql-bin.log
      - expire_logs_days = 10
      - max_binlog_size = 100M
  - name: 'mysqldump'
    config:
      - quick
      - quote-names
      - max_allowed_packet = 16M
  - name: 'isamchk'
    config:
      - key_buffer = 16M

# Bases de données
# mariadb_databases:
#   - { name: example, collation: utf8_general_ci, encoding: utf8, replicate: 1 }
mariadb_databases: []

# Utilisateurs
# mariadb_users:
#   - { name: example, host: 127.0.0.1, password: secret, priv: *.*:USAGE }
mariadb_users: []

Exemples

# Rôles
- name: mariadb
  hosts: mariadb
  user: root
  roles:
    - deimosfr.mariadb

Dépendances

Licence

GPL2

Informations sur l'auteur

Pierre Mavro / deimosfr