############################################################################## # Copyright (c) 2016 HUAWEI TECHNOLOGIES CO.,LTD and others. # # All rights reserved. This program and the accompanying materials # are made available under the terms of the Apache License, Version 2.0 # which accompanies this distribution, and is available at # http://www.apache.org/licenses/LICENSE-2.0 ############################################################################## --- - name: disable auto start copy: content: "#!/bin/sh\nexit 101" dest: "/usr/sbin/policy-rc.d" mode: 0755 when: ansible_os_family == "Debian" - name: install python-mysqldb action: "{{ ansible_pkg_mgr }} name={{ item }} state=present" with_items: maridb_packages | union(packages_noarch) - name: change open file limit copy: content: "* - nofile 65536 }}" dest: "/etc/security/limits.conf" mode: 0755 - name: update mariadb config file template: src: '{{ item.src }}' dest: '{{ item.dest }}' backup: yes mode: 0644 with_items: mysql_config - name: bugfix for rsync version 3.1 lineinfile: dest: /usr/bin/wsrep_sst_rsync state: absent regexp: '{{ item }}' with_items: - "\\s*uid = \\$MYUID$" - "\\s*gid = \\$MYGID$" - stat: path=/opt/mysql_init_complete register: mysql_init_complete - name: enable auto start file: path=/usr/sbin/policy-rc.d state=absent when: ansible_os_family == "Debian" - name: rm old datafiles shell: rm -rf /var/lib/mysql/ib_logfile* - name: set owner file: path=/var/lib/mysql owner=mysql group=mysql recurse=yes state=directory