date: 2019-07-02 11:28:46
title: tech| aliyun - 为了无法计算的价值
架构师捷径: 了解云能做什么, 并且能用好云; 数据->价值
- aliyun 网站矩阵 -> SE: `site:*.aliyun.com`
- [阿里云大学](https://edu.aliyun.com)
- [aliyun mvp](https://mvp.aliyun.com)
- [云栖社区](https://yq.aliyun.com)
- [阿里云总监课](https://yq.aliyun.com/promotion/689)
[[toc]]
# elastic computing
## ecs, elastic compute service
- ecs 送的免费云盾有一层白名单
## cr, container registry
## cs, container service, k8s
- 专有版: 3master+worker; 托管版: worker; serverless: 控制台+命令控制
## eci, elastic container instance
## fc, function compute
- 支持 php
# apsaraDB
- [企业级数据库服务选型](https://promotion.aliyun.com/ntms/act/dbservice.html)
## rds, relationship database service
- 实例规格 https://help.aliyun.com/document_detail/26312.html
- 慢查: sql洞察(搜索) sql日志(汇总/详情)
- 读写分离: 事务 `/*force_master*/`
- dblink
## drds
- 多个 rds 的前置服务器
- 查询: 分区键>索引>常规查询
- 并发型vs分析型
- prepare协议支持: 主库支持, 从库不支持
show help;
SHOW PARTITIONS FROM tablename # 查看分区键
## redis, kvstore
- 规格性能: https://help.aliyun.com/document_detail/26350.html
## mongo
- 版本与存储引擎: https://help.aliyun.com/document_detail/61906.html
## ads
- mysql -> dts -> ads -> quickBI/DataV
## tsdb
- ts, influx, 时空(时序+时空)
## dts, data transfer service
## dbs, data backup service
## dms, db devops
## hdm, hybrid cloud database management
# analysis, 大数据
## E-MapReduce
## MaxCompute
## data integration
## data lake analytics
# DTplus, 数加
## aliyun elasticsearch
- 预置插件
# storage&CDN
## oss
## nas
- mount NFS https://help.aliyun.com/document_detail/90529.html
# networking
## vpc
- vpc®ion: http://static-aliyun-doc.oss-cn-hangzhou.aliyuncs.com/assets/img/80559/155324038634448_zh-CN.png
- vpc - 路由器 - 路由表 - 交换机 - ecs/rds
# monitor & management
## kms, key management service
## ActionTrail, 操作审计
# application service
## sls, log service
- logtail 采集原理: https://help.aliyun.com/document_detail/89928.html
- logtail 采集限制: 每次512kb->导致json截断->json解析失败 修改时间后需要重启
- search syntax: https://help.aliyun.com/document_detail/29060.html
- analyze syntax: https://help.aliyun.com/document_detail/53608.html
- grafana: https://help.aliyun.com/document_detail/60952.html
- 日志接入: 文件/容器stdout -> json -> logtail json 解析
- 配置索引: 索引配置后验证
- 查询 + 保存快查
- 面板: 根据 web 服务 SLA 制定数据指标
- 监控: 监控验证
```
* | select time_series(__time__, '1m', '%H:%i' ,'0') as time, count(1) as PV group by time order by time limit 100
host: mms.mengtuiapp.com
# status
select count(1) as pv ,status group by status
# pv/uv
select approx_distinct(remote_addr) as uv ,count(1) as pv , date_format(date_trunc('hour', __time__), '%m-%d %H:%i') as time group by date_format(date_trunc('hour', __time__), '%m-%d %H:%i') order by time limit 1000
# 访问前十地址
* | select count(1) as pv, split_part(request_uri,'?',1) as path group by split_part(request_uri,'?',1) order by pv desc limit 10
# 访问前十来源
* | select count(1) as pv , http_referer group by http_referer order by pv desc limit 10
# 访问时间
select avg(request_time) as response_time, avg(upstream_response_time) as upstream_response_time , date_format( from_unixtime(__time__ -__time__%3600),'%m-%d %H:%i' ) as time group by __time__ - __time__% 3600 limit 10000
# 访问时间前十地址
* | select request_uri as top_latency_request_uri ,request_time order by request_time desc limit 10
```
## pts, performance testing sevice
阿里云性能测试 PTS: https://help.aliyun.com/product/29260.html
apache jmeter: http://jmeter.apache.org/
## open search
# middleware
## arms, application real-time monitoring service
## acm, application config manager
- 
## tracing analysis, opentrace
zipkin
## ahas, application high availability service
## edas, enterprise distributed application service
## mq, amqp
# sercurity
## 安骑士
# devops
## cli
https://help.aliyun.com/product/29991.html
aliyun rds DescribeSlowLogs --DBInstanceId=rm-uf64x3v2l4m1eb753 --StartTime=2018-11-05Z --EndTime=2018-11-06Z --SortKey=TotalQueryTimes
aliyun rds DescribeSlowLogRecords --DBInstanceId=rm-uf64x3v2l4m1eb753 --StartTime=2018-11-05T00:00Z --EndTime=2018-11-06T00:00Z
## toolkit
https://help.aliyun.com/product/29966.html
## codeshell
https://help.aliyun.com/product/89853.html
## openapi explorer
https://api.aliyun.com
