-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathansible
122 lines (84 loc) · 3.54 KB
/
ansible
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
1:
test.yml
- hosts: dbhost
gather_facts: false
tasks:
- name: token
debug: msg="{{sitetoken}}"
- name: 批量加索引任务1
shell: echo "{{ item }}"
with_sequence: start=0 end=19 stride=1
- name: 批量加索引任务2
shell: echo "{{ item }}"
with_sequence: start=10 end=19 stride=1
2:
ansible-playbook -i ~/allhost.ini test.yml --limit dbhost --list-host
ansible-playbook -i ./allhost.ini test.yml --limit x.x.x.x -u username -vvvv
设置参数 set global
ansible-playbook -i ../../inventery/aaa.ini ./change_var.yml --limit all-db --list-host
ansible-playbook -i ../../inventery/aaa.ini ./change_var.yml --limit 185.121.170.251 -u user | tee /tmp/11.log
ansible-playbook -i ../../inventery/aaa.ini ./change_var.yml --limit all-db -u user -f 10 | tee /tmp/11.log
3:
allhost.ini
[dbhost]
x.x.x.x sitetoken=xxxname
[linuxhost]
x.x.x.x sitetoken=xxxname
[live_collect_db:vars]
ansible_become_password=xxxx
copy file
- hosts: all
gather_facts: false
#become: yes
#become_user: root
#become_method: su
tasks:
- name: copy file到服务器
copy:
#template:
src: "/home/ansible/database/roles/db_audit/template/server_audit.so"
dest: "/opt/apps/mysql/lib/plugin/server_audit.so"
force: no
- name: chmod属性
shell: /usr/bin/chmod a+x /opt/apps/mysql/lib/plugin/server_audit.so
- name: db_install_audit
register: result
- name: 打印result
debug: msg={{ result.stdout_lines}}
- name: 禁止开启audit写入配置文件
shell: /usr/bin/echo "server_audit_logging = OFF" >>/opt/conf/xx.cnf
wget https://downloads.mariadb.org/interstitial/mariadb-10.2.38/bintar-linux-x86_64/mariadb-10.2.38-linux-x86_64.tar.gz
strings /lib64/libc.so.6 |grep GLIBC_ |grep 2.14
mv /tmp/server_audit.so /opt/apps/mysql/lib/plugin/
chmod a+x /opt/apps/mysql/lib/plugin/server_audit.so
show variables like 'server_audit%';
install plugin server_audit SONAME 'server_audit.so';
show variables like 'server_audit%';
set global server_audit_file_rotations=70;
set global server_audit_file_rotate_size=1000000000;
set global server_audit_query_log_limit=2048;
set global server_audit_logging=ON;
停止审计：
set global server_audit_logging=OFF;
show variables like 'server_audit_logging';
git fetch --all && git reset --hard origin/master && git clean -fd && git pull
恢复
innobackupex --defaults-file=/opt/conf/xx.cnf --decompress --parallel=8 ./
find ./ -name "*.qp" -maxdepth 2| xargs rm
innobackupex --defaults-file=/opt/conf/xx.cnf --apply-log --use-memory=4G ./
*****flash******
gcc -w `pkg-config --cflags --libs glib-2.0` source/binlogParseGlib.c -o binary/flashback
zsh: command not found: pkg-config
source/binlogParseGlib.c:5:10: fatal error: 'endian.h' file not found
编译myflash
wget https://github.com/Meituan-Dianping/MyFlash/archive/master.zip
yum -y install libgnomeui-devel
gcc -w `pkg-config --cflags --libs glib-2.0` source/binlogParseGlib.c -o binary/flashback
产生binlog_output_base.flashback文件:
./binary/flashback --binlogFileNames=/opt/data/data2/mysql-bin.000007 --start-position=4635 --stop-position=5158
./flashback --sqlTypes='INSERT' --binlogFileNames=/opt/data/data2/mysql-bin.000007 #回滚该文件中的所有insert语句
切割大文件
./flashback --maxSplitSize=100 --binlogFileNames=binlog_output_base.flashback
查询回滚SQL：mysqlbinlog -vv binlog_output_base.flashback
执行回滚:
mysqlbinlog --skip-gtids binlog_output_base.flashback | mysql -uroot -p --socket=/opt/data/data_16303/mysql.sock monitor