summaryrefslogtreecommitdiff
path: root/test/integration/targets/setup_mariadb
diff options
context:
space:
mode:
authorAnsible Core Team <info@ansible.com>2020-03-09 09:40:43 +0000
committerAnsible Core Team <info@ansible.com>2020-03-09 09:40:43 +0000
commit96125d46a395af50197839602febf451960ae824 (patch)
tree45bf37708a3857108f7003e274c8ca5b5df2b94f /test/integration/targets/setup_mariadb
parent4068eb7a4bc444ec6234e33e97569914125859be (diff)
downloadansible-96125d46a395af50197839602febf451960ae824.tar.gz
migration final cleanup
Diffstat (limited to 'test/integration/targets/setup_mariadb')
-rw-r--r--test/integration/targets/setup_mariadb/defaults/main.yml37
-rw-r--r--test/integration/targets/setup_mariadb/handlers/main.yml27
-rw-r--r--test/integration/targets/setup_mariadb/tasks/main.yml7
-rw-r--r--test/integration/targets/setup_mariadb/tasks/setup_mariadb.yml107
-rw-r--r--test/integration/targets/setup_mariadb/templates/my.cnf.j231
-rw-r--r--test/integration/targets/setup_mariadb/templates/myprimary.j210
-rw-r--r--test/integration/targets/setup_mariadb/templates/myreplica01.j211
-rw-r--r--test/integration/targets/setup_mariadb/vars/RedHat-7.yml4
-rw-r--r--test/integration/targets/setup_mariadb/vars/RedHat-8.yml3
-rw-r--r--test/integration/targets/setup_mariadb/vars/default.yml0
10 files changed, 0 insertions, 237 deletions
diff --git a/test/integration/targets/setup_mariadb/defaults/main.yml b/test/integration/targets/setup_mariadb/defaults/main.yml
deleted file mode 100644
index 04bce1803f..0000000000
--- a/test/integration/targets/setup_mariadb/defaults/main.yml
+++ /dev/null
@@ -1,37 +0,0 @@
-repo_link: http://yum.mariadb.org/10.1/centos7-amd64
-repo_gpgkey: https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
-
-mariadb_packages:
- - MariaDB-server
- - MariaDB-client
-
-packages_to_cleanup:
- - MariaDB-common
- - boost-program-options
- - galera
- - jemalloc
-
-primary_db:
- name: primary
- port: 3306
- datadir: /var/lib/mysql_primary
- logdir: /var/log/mysql_primary
-
-replica_db:
- name: replica01
- port: 3307
- datadir: /var/lib/mysql_replica01
- logdir: /var/log/mysql_replica01
-
-default_datadir: /var/lib/mysql
-default_logdir: /var/log/mariadb
-mysql_safe_err_log: /var/log/mariadb/mysql_safe-err.log
-
-fs_objects_to_clean_up:
- - "{{ primary_db.datadir }}"
- - "{{ primary_db.logdir }}"
- - "{{ replica_db.datadir }}"
- - "{{ replica_db.logdir }}"
- - "{{ default_datadir }}"
- - "{{ default_logdir }}"
- - "{{ mysql_safe_err_log }}"
diff --git a/test/integration/targets/setup_mariadb/handlers/main.yml b/test/integration/targets/setup_mariadb/handlers/main.yml
deleted file mode 100644
index 9d84dddf6c..0000000000
--- a/test/integration/targets/setup_mariadb/handlers/main.yml
+++ /dev/null
@@ -1,27 +0,0 @@
-- name: Stop MariaDB services
- service:
- name: mariadb@{{ item }}
- state: stopped
- loop:
- - "{{ primary_db.name }}"
- - "{{ replica_db.name }}"
- listen: cleanup mariadb
-
-- name: Remove MariaDB repo
- yum_repository:
- name: MariaDB
- state: absent
- listen: cleanup mariadb
-
-- name: Remove MariaDB related packages
- yum:
- name: "{{ packages_to_cleanup | union(mariadb_packages) }}"
- state: absent
- listen: cleanup mariadb
-
-- name: Remove related FS objects
- file:
- state: absent
- path: "{{ item }}"
- loop: "{{ fs_objects_to_clean_up }}"
- listen: cleanup mariadb
diff --git a/test/integration/targets/setup_mariadb/tasks/main.yml b/test/integration/targets/setup_mariadb/tasks/main.yml
deleted file mode 100644
index 4be1e45d9f..0000000000
--- a/test/integration/targets/setup_mariadb/tasks/main.yml
+++ /dev/null
@@ -1,7 +0,0 @@
-# Copyright: (c) 2019, Andrew Klychkov (@Andersson007) <aaklychkov@mail.ru>
-# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)
-
-- import_tasks: setup_mariadb.yml
- when:
- - ansible_distribution == 'CentOS'
- - ansible_distribution_major_version is version('7', '>=')
diff --git a/test/integration/targets/setup_mariadb/tasks/setup_mariadb.yml b/test/integration/targets/setup_mariadb/tasks/setup_mariadb.yml
deleted file mode 100644
index 7c3a1c3483..0000000000
--- a/test/integration/targets/setup_mariadb/tasks/setup_mariadb.yml
+++ /dev/null
@@ -1,107 +0,0 @@
-# We run two servers listening different ports
-# to be able to check replication (one server for primary, another for replica).
-
-- name: Include distribution specific variables
- include_vars: "{{ lookup('first_found', params) }}"
- vars:
- params:
- files:
- - "{{ ansible_facts.distribution }}-{{ ansible_facts.distribution_version }}.yml"
- - "{{ ansible_facts.os_family }}-{{ ansible_facts.distribution_major_version }}.yml"
- - "{{ ansible_facts.distribution }}.yml"
- - "{{ ansible_facts.os_family }}.yml"
- - default.yml
- paths:
- - vars
-
-- name: Install MariaDB repo
- yum_repository:
- name: MariaDB
- description: MariaDB official repo
- baseurl: "{{ repo_link }}"
- gpgkey: "{{ repo_gpgkey }}"
- gpgcheck: yes
- notify: cleanup mariadb
-
-- name: Install MariaDB packages
- yum:
- name: "{{ mariadb_packages }}"
- enablerepo: "{{ mariadb_enable_repo | default(omit) }}"
- notify: cleanup mariadb
-
-- name: Create directories for instances
- file:
- state: directory
- path: "{{ item }}"
- owner: mysql
- group: mysql
- loop:
- - "{{ primary_db.datadir }}"
- - "{{ primary_db.logdir }}"
- - "{{ replica_db.datadir }}"
- - "{{ replica_db.logdir }}"
- notify: cleanup mariadb
-
-- name: Copy configuration templates
- template:
- src: "{{ 'my' ~ item ~ '.j2' }}"
- dest: /etc/my.cnf.d/my{{ item }}.cnf
- owner: mysql
- group: mysql
- force: yes
- when: ansible_facts.distribution_major_version is version('7', '==')
- loop:
- - '{{ primary_db.name }}'
- - '{{ replica_db.name }}'
-
-- name: Copy configuration template
- template:
- src: my.cnf.j2
- dest: /etc/my.cnf
- owner: mysql
- group: mysql
- force: yes
- when: ansible_facts.distribution_major_version is version('8', '==')
-
-- name: Initialize DBs
- shell: 'mysql_install_db --user=mysql --datadir={{ item }}'
- loop:
- - '{{ primary_db.datadir }}'
- - '{{ replica_db.datadir }}'
-
-- name: Start services
- service:
- name: mariadb@{{ item }}
- state: started
- loop:
- - "{{ primary_db.name }}"
- - "{{ replica_db.name }}"
-
-- pause:
- seconds: 3
-
-########### For painful debug uncomment the lines below ##
-#- name: DEBUG Check stratup log
-# shell: cat /var/log/mariadb/mariadb.log
-
-#- name: DEBUG Check mysql_safe err log
-# shell: cat '{{ mysql_safe_err_log }}'
-
-#- name: DEBUG Check processes
-# shell: 'ps aux | grep mysqld | grep -v "grep\|root"'
-
-#- name: DEBUG
-# yum: name=net-tools
-
-#- name: DEBUG
-# shell: "netstat -ntpl"
-
-#- name: DEBUG
-# shell: cat /etc/my.cnf
-##########################################################
-
-- name: Check connection to the primary
- shell: 'echo "SHOW DATABASES;" | mysql -P {{ primary_db.port }} -h 127.0.0.1'
-
-- name: Check connection to the replica
- shell: "echo \"SHOW VARIABLES LIKE 'datadir';\" | mysql -P {{ replica_db.port }} -h 127.0.0.1"
diff --git a/test/integration/targets/setup_mariadb/templates/my.cnf.j2 b/test/integration/targets/setup_mariadb/templates/my.cnf.j2
deleted file mode 100644
index 21b5fe7f09..0000000000
--- a/test/integration/targets/setup_mariadb/templates/my.cnf.j2
+++ /dev/null
@@ -1,31 +0,0 @@
-[mysqld.{{ primary_db.name }}]
-server_id = 1
-port = {{ primary_db.port }}
-datadir = {{ primary_db.datadir }}
-socket = {{ primary_db.datadir }}/mysql.sock
-pid-file = {{ primary_db.datadir }}/mysql.pid
-log_bin = {{ primary_db.logdir }}/mysql-bin.log
-sync_binlog = 1
-binlog-format = ROW
-innodb_flush_log_at_trx_commit = 1
-
-[mysqld.{{ replica_db.name }}]
-server_id = 2
-port = {{ replica_db.port }}
-datadir = {{ replica_db.datadir }}
-socket = {{ replica_db.datadir }}/mysqld_replica.sock
-pid-file = {{ replica_db.datadir }}/mysqld_replica.pid
-log_bin = {{ replica_db.logdir }}/mysql-bin.log
-relay-log = {{ replica_db.logdir }}/relay-bin
-relay-log-index = {{ replica_db.logdir }}/relay-bin.index
-master-info-file = {{ replica_db.logdir }}/master.info
-relay-log-info-file = {{ replica_db.logdir }}/relay-log.info
-
-[mysqld_multi]
-mysqld = /usr/bin/mysqld_safe
-user = multi_admin
-password = multipass
-
-[mysqld_safe]
-log-error={{ mysql_safe_err_log }}
-pid-file=/var/run/mariadb/mariadb.pid
diff --git a/test/integration/targets/setup_mariadb/templates/myprimary.j2 b/test/integration/targets/setup_mariadb/templates/myprimary.j2
deleted file mode 100644
index 6ff612a880..0000000000
--- a/test/integration/targets/setup_mariadb/templates/myprimary.j2
+++ /dev/null
@@ -1,10 +0,0 @@
-[mysqld]
-server_id = 1
-port = {{ primary_db.port }}
-datadir = {{ primary_db.datadir }}
-socket = {{ primary_db.datadir }}/mysql.sock
-pid-file = {{ primary_db.datadir }}/mysql.pid
-log_bin = {{ primary_db.logdir }}/mysql-bin.log
-sync_binlog = 1
-binlog-format = ROW
-innodb_flush_log_at_trx_commit = 1
diff --git a/test/integration/targets/setup_mariadb/templates/myreplica01.j2 b/test/integration/targets/setup_mariadb/templates/myreplica01.j2
deleted file mode 100644
index d26ddaef69..0000000000
--- a/test/integration/targets/setup_mariadb/templates/myreplica01.j2
+++ /dev/null
@@ -1,11 +0,0 @@
-[mysqld]
-server_id = 2
-port = {{ replica_db.port }}
-datadir = {{ replica_db.datadir }}
-socket = {{ replica_db.datadir }}/mysqld_replica.sock
-pid-file = {{ replica_db.datadir }}/mysqld_replica.pid
-log_bin = {{ replica_db.logdir }}/mysql-bin.log
-relay-log = {{ replica_db.logdir }}/relay-bin
-relay-log-index = {{ replica_db.logdir }}/relay-bin.index
-master-info-file = {{ replica_db.logdir }}/master.info
-relay-log-info-file = {{ replica_db.logdir }}/relay-log.info
diff --git a/test/integration/targets/setup_mariadb/vars/RedHat-7.yml b/test/integration/targets/setup_mariadb/vars/RedHat-7.yml
deleted file mode 100644
index da73d98b47..0000000000
--- a/test/integration/targets/setup_mariadb/vars/RedHat-7.yml
+++ /dev/null
@@ -1,4 +0,0 @@
-mariadb_enable_repo: epel
-mariadb_packages:
- - MariaDB-server
- - MySQL-python
diff --git a/test/integration/targets/setup_mariadb/vars/RedHat-8.yml b/test/integration/targets/setup_mariadb/vars/RedHat-8.yml
deleted file mode 100644
index c68a6b1c68..0000000000
--- a/test/integration/targets/setup_mariadb/vars/RedHat-8.yml
+++ /dev/null
@@ -1,3 +0,0 @@
-mariadb_packages:
- - mariadb-server
- - python3-PyMySQL
diff --git a/test/integration/targets/setup_mariadb/vars/default.yml b/test/integration/targets/setup_mariadb/vars/default.yml
deleted file mode 100644
index e69de29bb2..0000000000
--- a/test/integration/targets/setup_mariadb/vars/default.yml
+++ /dev/null