-
Notifications
You must be signed in to change notification settings - Fork 20
/
main.yml
121 lines (106 loc) · 3.56 KB
/
main.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
---
# Python interpreter needs to be specified (pb on Fedora 37 that has python
# 3.11) see: https://github.com/ansible/containmint/issues/9
ansible_python_interpreter: /usr/bin/python3
# Configure the following to use official MariaDB repository
# see: https://downloads.mariadb.org/mariadb/repositories
mariadb_use_official_repo: false
mariadb_use_official_repo_url: https://deb.mariadb.org
mariadb_use_official_repo_version: 10.6
# see: https://manpages.debian.org/stable/apt/sources.list.5.en.html#DEB822-STYLE_FORMAT
mariadb_use_official_repo_format_deb822: false
mariadb_enabled_on_startup: true
# The following is set to true by default but you may consider setting it to
# false on production servers to prevent ansible from restarting mariadb server.
mariadb_can_restart: true
# Whether global conf file should be updated on every run
mariadb_overwrite_global_config_file: true
# MariaDB configuration file
mariadb_user: "default value depends on OS"
mariadb_config_file: "default value depends on OS"
# Basic settings
mariadb_data_dir: "default value depends on OS"
mariadb_port: 3306
mariadb_bind_address: 127.0.0.1
mariadb_pid_file: "default value depends on OS"
mariadb_unix_socket: "default value depends on OS"
mariadb_log_error_file: "default value depends on OS"
mariadb_basic_settings_raw: |
user = {{ mariadb_user }}
pid-file = {{ mariadb_pid_file }}
socket = {{ mariadb_unix_socket }}
basedir = /usr
datadir = {{ mariadb_data_dir }}
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
lc_messages = en_US
skip-external-locking
port = {{ mariadb_port }}
bind-address = {{ mariadb_bind_address }}
# Fine tuning
mariadb_fine_tuning_raw: |
max_connections = 100
connect_timeout = 5
wait_timeout = 600
max_allowed_packet = 16M
thread_cache_size = 128
sort_buffer_size = 4M
bulk_insert_buffer_size = 16M
tmp_table_size = 32M
max_heap_table_size = 32M
skip-name-resolve = 1
# Query cache
mariadb_query_cache_raw: |
query_cache_size = 16M
# Logging
mariadb_logging_raw: |
log_error = {{ mariadb_log_error_file }}
# Character sets
mariadb_character_sets_raw: |
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
# InnoDB
mariadb_innodb_raw: |
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# mariadbdump
mariadb_mysqldump_raw: |
quick
quote-names
max_allowed_packet = 16M
# Databases
mariadb_databases: []
# - name: db1
# collation: utf8_general_ci
# encoding: utf8
# replicate: true|false
# Users
mariadb_users: []
# - name: user
# host: 100.64.200.10
# password: password
# priv: "*.*:USAGE/db1.*:ALL"
# state: present|absent
# Replication
# replication is only enabled if mariadb_replication_role has values
mariadb_replication_role: ""
mariadb_replication_primary_ip: ""
mariadb_max_binlog_size: 100M
mariadb_binlog_format: MIXED
mariadb_expire_logs_days: 10
# Replication users
# same keys as mariadb_users above
# priv is set to "*.*:REPLICATION SLAVE" by default
mariadb_replication_user: []
# Backups
mariadb_backup_db: false
mariadb_backup_db_cron_min: 50
mariadb_backup_db_cron_hour: 00
mariadb_backup_db_dir: /opt/backup
mariadb_backup_db_rotation: 15
# set to "1>" to get only STDERR on cron
mariadb_backup_cron_std_output: "2>&1 | tee"
# DB to backup
mariadb_backup_db_name: []
# - db1
# - db2