Ansible MariaDB Rolle

Diese Rolle installiert und konfiguriert MariaDB.

Anforderungen

Diese Rolle erfordert Ansible 1.6 oder höher, die Plattformanforderungen sind in der Metadatei aufgeführt.

Rollenvariablen

Die Variablen, die an diese Rolle übergeben werden können:

# MariaDB Repository
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

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

# MariaDB Dienst
mariadb_manage_service: True
mariadb_service_name: mysql

# MariaDB/MySQL Werkzeuge
mariadb_install_tools: False

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

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

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

# Datenbanken
# mariadb_databases:
#   - { name: example, collation: utf8_general_ci, encoding: utf8, replicate: 1 }
mariadb_databases: []

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

Beispiele

# Rollen
- name: mariadb
  hosts: mariadb
  user: root
  roles:
    - deimosfr.mariadb

Abhängigkeiten

Lizenz

GPL2

Autoreninformation

Pierre Mavro / deimosfr