diff options
Diffstat (limited to 'deploy/adapters/ansible/roles/database/tasks')
3 files changed, 73 insertions, 0 deletions
diff --git a/deploy/adapters/ansible/roles/database/tasks/main.yml b/deploy/adapters/ansible/roles/database/tasks/main.yml new file mode 100644 index 00000000..05697730 --- /dev/null +++ b/deploy/adapters/ansible/roles/database/tasks/main.yml @@ -0,0 +1,14 @@ +--- +- include_vars: "{{ ansible_os_family }}.yml" + +- name: copy data.sh + template: src=data.j2 dest=/opt/data.sh mode=777 + tags: + - mysql_user + +- include: mysql.yml + when: HA_CLUSTER is not defined + +- include: mariadb.yml + when: HA_CLUSTER is defined + diff --git a/deploy/adapters/ansible/roles/database/tasks/mariadb.yml b/deploy/adapters/ansible/roles/database/tasks/mariadb.yml new file mode 100644 index 00000000..50618bfc --- /dev/null +++ b/deploy/adapters/ansible/roles/database/tasks/mariadb.yml @@ -0,0 +1,39 @@ +--- +- name: install python-mysqldb + action: "{{ ansible_pkg_mgr }} name={{ item }} state=present force=yes" + with_items: maridb_packages + +- name: create mysql log directy + file: path=/var/log/mysql state=directory owner=mysql group=mysql mode=0755 + +- name: update mariadb my.cnf + template: src=my.cnf dest=/etc/mysql/my.cnf backup=yes + +- name: update galera wsrep.cnf + template: src=wsrep.cnf dest=/etc/mysql/conf.d/wsrep.cnf backup=yes + +- name: update wsrep_sst_rsync uid + lineinfile: dest=/usr/bin/wsrep_sst_rsync state=absent regexp="\s*uid = \$MYUID$" backup=yes + +- name: update wsrep_sst_rsync gid + lineinfile: dest=/usr/bin/wsrep_sst_rsync state=absent regexp="\s*gid = \$MYGID$" backup=yes + +- name: manually restart mysql server + service: name=mysql state=restarted enabled=yes + register: result + until: result|success + retries: 5 + delay: 5 + tags: + - mysql_restart + +- name: generate mysql service list + shell: echo {{ item }} >> /opt/service + with_items: + - mysql + +- name: create database/user + shell: /opt/data.sh + when: HA_CLUSTER[inventory_hostname] == '' + tags: + - mysql_user diff --git a/deploy/adapters/ansible/roles/database/tasks/mysql.yml b/deploy/adapters/ansible/roles/database/tasks/mysql.yml new file mode 100644 index 00000000..8005292e --- /dev/null +++ b/deploy/adapters/ansible/roles/database/tasks/mysql.yml @@ -0,0 +1,20 @@ +--- +- name: install mysql client and server packages + apt: name={{ item }} state=present + with_items: mysql_packages + +- name: create mysql log directy + file: path=/var/log/mysql state=directory owner=mysql group=mysql mode=0755 + +- name: update mysql my.cnf + copy: src=my.cnf + dest=/etc/mysql/my.cnf + backup=yes + +- name: manually restart mysql server + shell: service mysql restart + +- name: create database/user + shell: /opt/data.sh + tags: + - mysql_user |