1 passwd root
2 cd /home/mysql/log/
3 ll
4 vi error.log
5 tailf error.log
6 reboot
7 cd /home/
8 ll
9 gunzip all_data.gz
10 ll
11 more all_data
12 vi /root/.mysql.20293
13 vi /root/.my.cnf.20293
14 vi /root/.mysql_secret
15 vi /etc/my.cnf
16 vi /home/mysql/log/error.log
17 cd /home/
18 ll
19 cd mysql/
20 ll
21 cd log/
22 ll
23 cd ../
24 vi /home/mysql/log/error.log
25 tailf /home/mysql/log/error.log
26 :> /home/mysql/log/error.log
27 tailf /home/mysql/log/error.log
28 vi /etc/my.cnf
29 service mysqld restart
30 service mysql restart
31 vi /etc/my.cnf
32 top
33 service mysql retart
34 service mysql restart
35 cd /home/
36 ll
37 more all_data
38 ll
39 rm all_data.gz
40 ll
41 df
42 rpm -ivh http://repo.zabbix.com/zabbix/2.4/rhel/7/x86_64/zabbix-release-2.4-1.el7.noarch.rpm
43 yum install zabbix-agent -y
44 vi /etc/zabbix/zabbix_agentd.conf
45 timedatectl set-timezone Asia/Shanghai
46 yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
47 yum install percona-zabbix-templates
60 mkdir -p /etc/zabbix_agentd.conf.d/
61 cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix_agentd.conf.d/userparameter_percona_mysql.conf
62 vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
63 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
64 yum install php -y
65 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
66 vi /var/lib/zabbix/.my.cnf
67 zabbix -H /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
68 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
69 mysql -u root -p
70 vi /var/lib/zabbix/.my.cnf
71 vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
72 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
73 service zabbix-agent restart
74 /bin/systemctl enable zabbix-agent
75 systemctl stop firewalld
76 hostnamectl Vm610
77 hostnamectl
78 hostnamectl set-hostname Vm610
79 hostnamectl
80 vi /etc/my.cnf
81 more /home/all_data
82 service mysql restart
83 wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
84 yum install -y wget
85 wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
86 tar xvf MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
87 yum install -y *.rpm
88 df
89 mkdir /home/mysql
90 mkdir /home/mysql/data
91 mkdir /home/mysql/log
92 vi /etc/my.cnf
93 setenforce 0
94 vi /etc/sysconfig/selinux
95 systemctl disable fireword
96 systemctl disable firewalld.service
97 chown -R mysql:mysql /home/mysql
98 /usr/bin/mysql_install_db
99 yum install -y perl-Module-Install.noarch
100 /usr/bin/mysql_install_db
101 /usr/bin/mysql_secure_installation
102 mysql -u root -p
103 /usr/bin/mysqladmin -u root password 'LzvsU9jfdkDS4e0l'
104 service mysql start
105 cd /home/mysql/log/
106 ll
107 cd ../
108 chown -R mysql:mysql .
109 ll
110 cd log/
111 ll
112 cd ../
113 ll
114 service mysql start
115 mysql -u root -p
116 vi /etc/sysconfig/network-scripts/ifcfg-ens160
117 ping 192.168.1.1
118 serice network restart
119 service network restart
120 ping 192.168.1.1
121 vi /etc/resolv.conf
122 service network restart
123 history
2 cd /home/mysql/log/
3 ll
4 vi error.log
5 tailf error.log
6 reboot
7 cd /home/
8 ll
9 gunzip all_data.gz
10 ll
11 more all_data
12 vi /root/.mysql.20293
13 vi /root/.my.cnf.20293
14 vi /root/.mysql_secret
15 vi /etc/my.cnf
16 vi /home/mysql/log/error.log
17 cd /home/
18 ll
19 cd mysql/
20 ll
21 cd log/
22 ll
23 cd ../
24 vi /home/mysql/log/error.log
25 tailf /home/mysql/log/error.log
26 :> /home/mysql/log/error.log
27 tailf /home/mysql/log/error.log
28 vi /etc/my.cnf
29 service mysqld restart
30 service mysql restart
31 vi /etc/my.cnf
32 top
33 service mysql retart
34 service mysql restart
35 cd /home/
36 ll
37 more all_data
38 ll
39 rm all_data.gz
40 ll
41 df
42 rpm -ivh http://repo.zabbix.com/zabbix/2.4/rhel/7/x86_64/zabbix-release-2.4-1.el7.noarch.rpm
43 yum install zabbix-agent -y
44 vi /etc/zabbix/zabbix_agentd.conf
45 timedatectl set-timezone Asia/Shanghai
46 yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
47 yum install percona-zabbix-templates
60 mkdir -p /etc/zabbix_agentd.conf.d/
61 cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix_agentd.conf.d/userparameter_percona_mysql.conf
62 vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
63 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh
64 yum install php -y
65 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
66 vi /var/lib/zabbix/.my.cnf
67 zabbix -H /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
68 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
69 mysql -u root -p
70 vi /var/lib/zabbix/.my.cnf
71 vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
72 /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh running-slave
73 service zabbix-agent restart
74 /bin/systemctl enable zabbix-agent
75 systemctl stop firewalld
76 hostnamectl Vm610
77 hostnamectl
78 hostnamectl set-hostname Vm610
79 hostnamectl
80 vi /etc/my.cnf
81 more /home/all_data
82 service mysql restart
83 wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
84 yum install -y wget
85 wget http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
86 tar xvf MySQL-5.6.30-1.el7.x86_64.rpm-bundle.tar
87 yum install -y *.rpm
88 df
89 mkdir /home/mysql
90 mkdir /home/mysql/data
91 mkdir /home/mysql/log
92 vi /etc/my.cnf
93 setenforce 0
94 vi /etc/sysconfig/selinux
95 systemctl disable fireword
96 systemctl disable firewalld.service
97 chown -R mysql:mysql /home/mysql
98 /usr/bin/mysql_install_db
99 yum install -y perl-Module-Install.noarch
100 /usr/bin/mysql_install_db
101 /usr/bin/mysql_secure_installation
102 mysql -u root -p
103 /usr/bin/mysqladmin -u root password 'LzvsU9jfdkDS4e0l'
104 service mysql start
105 cd /home/mysql/log/
106 ll
107 cd ../
108 chown -R mysql:mysql .
109 ll
110 cd log/
111 ll
112 cd ../
113 ll
114 service mysql start
115 mysql -u root -p
116 vi /etc/sysconfig/network-scripts/ifcfg-ens160
117 ping 192.168.1.1
118 serice network restart
119 service network restart
120 ping 192.168.1.1
121 vi /etc/resolv.conf
122 service network restart
123 history