-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql2.yml
100 lines (84 loc) · 2.49 KB
/
mysql2.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
---
- hosts: all
become: True
tasks:
- name: Include vars
include_vars:
file: 'vars/main.yml'
- name: Download Percona Repo
get_url:
url: "{{ percona_repo_url }}"
dest: "{{ percona_repo_dest }}"
- name: Install Percona Repo
apt:
deb: "{{ percona_repo_dest }}"
- name: update apt chache
apt:
update_cache: yes
- name: Add hosts inside /etc/hosts
lineinfile:
path: /etc/hosts
state: present
line: "{{ item }}"
with_items:
- "{{ mysql_server_1_ip }} {{ mysql_server_1_hostname }} {{ mysql_server_1_hostname }}"
- "{{ mysql_server_2_ip }} {{ mysql_server_2_hostname }} {{ mysql_server_2_hostname }}"
- "{{ mysql_server_3_ip }} {{ mysql_server_3_hostname }} {{ mysql_server_3_hostname }}"
- name: Install Percona Server
apt:
name: "{{ item }}"
state: present
force: yes
vars:
item:
- "{{ percona_server_common }}"
- "{{ percona_server_client }}"
- "{{ percona_server_server }}"
environment:
DEBIAN_FRONTEND: noninteractive
- name: configure my.cnf
template:
src: mysql2.my.cnf.j2
dest: /etc/mysql/my.cnf
- name: restart mysql
service:
name: mysql
state: restarted
enabled: yes
- name: Install Percona Toolkit
apt:
name: percona-toolkit
state: present
force: yes
- name: Install dependency
apt:
name: python2.7-mysqldb
state: present
- name: Stop replication
mysql_replication:
mode: stopslave
- name: Configure replication
mysql_replication:
mode: changemaster
master_host: "{{ mysql_server_1_ip }}"
master_user: "{{ ReplicationUser }}"
master_password: "{{ ReplicationPassword }}"
master_log_file: mysql1-bin.000001
master_log_pos: 4
- name: Start replication
mysql_replication:
mode: startslave
- name: Check slave status
mysql_replication:
mode: getslave
- name: Install PMM Client
apt:
name: pmm-client
state: present
force: yes
- name: Configure pmm-client
shell: "{{ item }}"
with_items:
- pmm-admin config --server {{ app_server_ip }}
- sleep 10
- pmm-admin add mysql