阿里云操作

1
2
3
4

# 普通查询
level: ERROR
# 统计查询
* and level: ERROR | select sum(1) as "err_count","__tag__:app_name" GROUP by "__tag__:app_name"

1

* | select count(1) , host group by host order by count(1) desc

1

* and host: www.kentxxq.com | select count(1) , client_ip group by client_ip order by count(1) desc

1

* | select approx_distinct(client_ip)

 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

* not client_ip: "10.*"
and host: gateway.kentxxq.com |
select
  url2,
  proxy_upstream_name,
  diff [1] as today_total,
  diff [2] as yesterday_total,
  diff [1]-diff [2] as inc,
  round(diff [1] / diff [2],2) as inc2
FROM  (
    select
	  url2,
      proxy_upstream_name,
      compare(count, 86400) as diff
    FROM  (
        select
          regexp_extract(split_part(url, '?', 1),'(.*\D)\d*?')    as url2,
          proxy_upstream_name,
          COUNT(*) as count
        FROM          log
        GROUP by
          regexp_extract(split_part(url, '?', 1),'(.*\D)\d*?')  ,
          proxy_upstream_name
      )
    group by
	  url2,
      proxy_upstream_name
)
where diff [1]-diff [2] > 2000 
and round(diff [1] / diff [2],2) > 1.5
order by inc desc

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

# 告警模板

- 告警严重度：${severity}
- 告警内容：${{ alert.annotations.desc }}
- 告警首次触发时间：${fire_time}
- 此次评估的触发时间：${alert_time}
- 告警规则所在Project：${project}

对比前一天同时段1小时内
{%- for item  in alert.results[0].raw_results %}
  - 服务名 : {{ item.proxy_upstream_name }} ,请求地址: {{ item.url2 }}   ,   新增请求 : {{ item.inc }} 

{%- endfor %}

[[详情](${query_url})]

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

{
    "Version": "1",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": "oss:PutObject",
            "Resource": [
                "acs:oss:*:*:xxx-prod/",
                "acs:oss:*:*:xxx-prod/*",
                "acs:oss:*:*:xxx-test/",
                "acs:oss:*:*:xxxtest/*"
            ]
        }
    ]
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

{
  "Statement": [
    {
      "Action": "sts:AssumeRole",
      "Effect": "Allow",
      "Principal": {
        "RAM": [
          "acs:ram::1784459943823235:root"
        ]
      }
    }
  ],
  "Version": "1"
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

# 查看磁盘
# Disk label type值为dos表示MBR分区，值为gpt表示GPT分区
fdisk -lu

# 确保工具安装完成
apt update -y
type growpart || apt install -y cloud-guest-utils
# 扩容
LC_ALL=en_US.UTF-8 growpart /dev/vdb 1

# 查看文件系统,一般是ext4
df -Th
# 扩容
resize2fs /dev/vdb1
# 验证效果
df -Th

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

# 看到/dev/vdb /dev/vdc等等硬盘
fdisk -lu

# 推荐使用 gpt 分区
apt install parted -y
parted /dev/vdb
mklabel gpt
mkpart primary 1 100%
align-check optimal 1
# 退出交互
quit
# 验证
partprobe
fdisk -lu /dev/vdb # 显示gpt

# 文件系统
apt install e2fsprogs -y
mkfs -t ext4 /dev/vdb1

# 挂载
cp /etc/fstab /etc/fstab.bak
mkdir /mnt/vdb1
# /dev/vdb1 /mnt/vdb1
echo `blkid /dev/vdb1 | awk '{print $2}' | sed 's/\"//g'` /mnt/vdb1 ext4 defaults 0 0 >> /etc/fstab