/home/travis/.ansible/roles/robertdebock.mysql/vars/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
---
# vars file for mysql

_mysql_packages:
  default:
    - mariadb-server
    - mariadb-devel
    - python2-mysql
  Alpine:
    - mariadb
    - py-mysqldb
  Amazon-2018:
    - mysql-server
    - mysql-devel
    - MySQL-python27
  Amazon:
    - mariadb-server
    - mariadb-devel
    - MySQL-python
  RedHat-7:
    - mariadb-devel
    - mariadb-server
    - MySQL-python
  CentOS-7:
    - mariadb-devel
    - mariadb-server
    - MySQL-python
  CentOS:
    - mysql-devel
    - mysql-server
    - python3-PyMySQL
  Debian:
    - mariadb-server
    - python3-mysqldb
  Fedora:
    - mariadb-server
    # /usr/include/mysql/mariadb_rpl.h conflicts between attempted installs of mariadb-devel-3:10.3.22-1.fc31.x86_64 and mariadb-connector-c-devel-3.1.9-5.fc31.x86_64
    # - mariadb-devel
    - mariadb-connector-c-devel
    - python3-PyMySQL
  Ubuntu:
    - mariadb-server
    - libssl-dev
    - python3-mysqldb
  openSUSE Leap:
    - libmysqlclient-devel
    - mariadb
    - python3-mysqlclient

mysql_packages: "{{ _mysql_packages[ansible_distribution ~ '-' ~ ansible_distribution_major_version] | default(_mysql_packages[ansible_distribution] | default(_mysql_packages['default'])) }}"

_mysql_initialize_command:
  Alpine: /etc/init.d/mariadb setup
  Archlinux: mysql_install_db --basedir=/usr --datadir=/var/lib/mysql

mysql_initialize_command: "{{ _mysql_initialize_command[ansible_os_family] }}"

_mysql_service:
  default: mysql
  Alpine: mariadb
  Amazon: mariadb
  Amazon-2018: mysqld
  Fedora: mariadb
  RedHat-7: mariadb
  RedHat: mysqld

mysql_service: "{{ _mysql_service[ansible_os_family ~ '-' ~ ansible_distribution_major_version] | default(_mysql_service[ansible_distribution ~ '-' ~ ansible_distribution_major_version] | default(_mysql_service[ansible_distribution] | default(_mysql_service[ansible_os_family] | default(_mysql_service['default'])))) }}"

_mysql_socket:
  default: /var/run/mysql/mysql.sock
  Debian: /var/run/mysqld/mysqld.sock
  RedHat: /var/lib/mysql/mysql.sock

mysql_socket: "{{ _mysql_socket[ansible_os_family] | default(_mysql_socket['default']) }}"

_mysql_pid:
  default: /var/run/mysql/mysql.pid
  Debian: /tmp/mysql.pid

mysql_pid: "{{ _mysql_pid[ansible_os_family] | default(_mysql_pid['default']) }}"

mysql_configuration_options:
  - option: bind-address
    section: mysqld
    value: "{{ mysql_bind_address }}"
  - option: socket
    section: mysqld
    value: "{{ mysql_socket }}"
  - option: pid-file
    section: mysqld
    value: "{{ mysql_pid }}"