Home avatar

Mulinux运维

乾坤未定,你我皆是黑马。

核心技术栈

Linux Docker Kubernetes Nginx MySQL Redis Python Golang ⚙️ Ansible 📊 Zabbix

MySQL 常用排障与救火速查 (Runbook)

🚨 使用指南: 这是一份专为生产环境数据库宕机、卡顿、爆满设计的救火急诊室指南。越致命的状况对应的代码越靠前,日常业务代码被折叠至附录。在此页面所抄写的每一行指令,都应该怀揣对生产环境的敬畏。

Nginx Logrotate日志回滚

logrotate配置

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
vi /etc/logrotate.d/nginx
/var/log/nginx/*.log {
    rotate 7
    size 5k
    dateext
    dateformat -%Y-%m-%d-%s
    missingok
#    compress
    sharedscripts
    postrotate
        test -r /run/nginx.pid && kill -USR1 `cat /run/nginx.pid`
    endscript
}

日志回滚命令

1
logrotate -v -f /etc/logrotate.d/nginx

定时任务

1
2
crontab -e
*/5 * * * * /usr/sbin/logrotate -v -f /etc/logrotate.d/nginx

CDH中Kafka实现多端口监听

节点分布

名称 集群IP 业务IP
AIOPS01CALC 192.168.1.1 10.10.1.1
AIOPS02CALC 192.168.1.2 10.10.1.2
AIOPS03CALC 192.168.1.3 10.10.1.3

需求描述

集群内部通过192.168.1.X网段通信,对外通过10.10.1.X网段通信,可使用如下参数配置实现多网段不同端口监听访问。

Logstash使用示例

es2csv

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
input {
 elasticsearch {
    hosts => "localhost:9200"
    index => "kibana_sample_data_ecommerce"
	user => "elastic"
	password => "password"
    query => '{  # query可不填写
    "query": {
      "match_all": {}
      }
    }'
  }
}
 
output {
  csv {
    fields => ["@message"]
    path => "/tmp/csv-export.csv"
  }
}

es2file

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
input {
 elasticsearch {
    hosts => "localhost:9200"
    index => "kibana_sample_data_ecommerce"
	user => "elastic"
	password => "password"
    query => '{  
    "query": {
      "match_all": {}
      }
    }'
  }
}
 
output {
  file {
    path => "/tmp/csv-export.txt"
	codec => line { format => "%{@message}" }
  }
}

启动命令

1
/app/logstash/bin/logstash -f /app/logstash/config/esTocsv.conf

Windows Find Software

查找windows是否安装某个软件

通过服务查找

powershell

1
Get-WmiObject -class Win32_Product |Select-Object -Property name,version

批处理

1
reg query HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\|find /i "sogou input"

通过路径名称匹配

1
2
3
Get-ChildItem C:\ProgramData\Microsoft\Windows\\'Start Menu\'\Programs\ -Filter *Premium*"
Get-ChildItem C:\\'Program Files\' -Filter *Premium*"
Get-ChildItem C:\\'Program Files (x86)\' -Filter *Premium*"

容器化部署Wordpress

Install docker and docker-compose

1
2
3
4
5
6
wget http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo -O /etc/yum.repos.d/docker-ce.repo
yum install docker-ce -y
systemctl start docker
systemctl enable docker
curl -L "https://github.com/docker/compose/releases/download/1.27.4/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose

Deploy wordpress using official examples

Create wordpress directory

1
2
mkdir wordpress
cd wordpress/

Create docker-compose file

vi docker-compose.yml

Kvm Windows时间异常问题

KVM xml配置

1
2
3
4
5
6
7
8
9
<clock offset='localtime'>
  <timer name='rtc' tickpolicy='catchup' track='guest'/>
  <timer name='pit' tickpolicy='delay'/>
  <timer name='hpet' present='no'/>
</clock>

or

<clock offset='timezone' timezone='Asia/Shanghai'/>

Windows服务器配置

1
2
3
bcdedit /set USEPLATFORMCLOCK on #设置
bcdedit /enum #查看是否生效
bcdedit / deletevalue useplatformclock #取消配置