â
Rust ááŹááŹá ááŹá¸ááźááˇáş ááąá¸ááŹá¸ááŹá¸ááźááşá¸ááźá áşááźáŽá¸ áááşá¸áááş áááşá¸á analogues ááťáŹá¸áážááˇáş áážááŻááşá¸áážááşááŤá ááźááˇáşááŹá¸ááąáŹá á˝ááşá¸ááąáŹááşáááşáážááˇáş RAM ááŻáśá¸á á˝á˛áážáŻáááşá¸ááŤá¸ááźááşá¸áááŻáˇááźáąáŹááˇáş áááşáážáŹá¸áááşá áááŻáˇáĄááźááşá áĄáá°á¸áááźááˇáşá áá áşááşááąáŤáşáážá ááźáŹá¸ááśáá áşááŻáááŻáˇ ááááŻáˇáááąá¸ááąáŹááźá áşáááşááťáŹá¸ááᯠááááşá¸áááşá¸áááşáážááˇáş áááŻááşááťáŹá¸ááᯠáážááˇáşááźááşá¸áááŻááşáᏠáážááşáááşáážáŻáážááˇáşáááşáááşáááˇáş ááŻááşááąáŹááşááťááşááťáŹá¸ááᯠááťáŹá¸á á˝áŹáĄáŹááŻáśá ááŻááşááŹá¸áááşá
ááááŻááŹáĄáá Vector áááş áá áşáᯠáááŻáˇáááŻááş áá áşááŻáááşáááŻááąáŹ áááşááąáˇááťáşááťáŹá¸ááᯠáááşááśáááˇáş event router áá áşááŻááźá áşáááşá áĄáááşá¸áĄááźá áşááťáŹá¸á¤á áŹááťáŹá¸ááąáŤáşáá˝ááş á áááşááźááŻááşáá˝áąá¸ááťááşáááŻááşáááşá áĄáá˝ááşááźáąáŹááşá¸áážáŻááťáŹá¸á áá áşáᯠáááŻáˇáááŻááş áá áşááŻáááşáááŻááąáŹááśáááŻáˇ ááąá¸áááŻáˇááŤá ááźáąáŹááşá¸ááťáŹá¸.
Vector áááş filebeat áážááˇáş logstash áááŻáˇáĄáá˝ááş áĄá
áŹá¸áááŻá¸áá
áşááŻááźá
áşááźáŽá¸ áááşá¸áááş áĄáááşá¸ááášááážá
áşááŻááŻáśá¸áá˝ááş ááŻááşááąáŹááşáááŻááşáááş (áážááşáááşá¸ááťáŹá¸áááşááśááźááşá¸áážááˇáş ááąá¸áááŻáˇááźááşá¸)á áááşá¸áááŻáˇáá˝ááşáĄááąá¸á
áááşáĄááťááşááťáŹá¸
Logstash áá˝ááş áá˝ááşá¸áááşáĄáŹá¸ input â filter â output áĄááźá
áş áááşááąáŹááşááŹá¸ááťážááş Vector áá˝ááş áááşá¸áááş áááşá¸ááźá
áşáááşá
áĽáááŹááťáŹá¸ááᯠá áŹáá˝ááşá áŹáááşá¸ááťáŹá¸áá˝ááş áá˝áąáˇáááŻááşáááşá
á¤áá˝ážááşááźáŹá¸ááťááşáááş ááźááşáááşááźááşáááşááŹá¸ááąáŹ áá˝ážááşááźáŹá¸ááťááşááźá
áşáááşá
Aug 05 06:25:31.889 DEBUG transform{name=nginx_parse_rename_fields type=rename_fields}: vector::transforms::rename_fields: Field did not exist field=ÂŤgeoip.country_nameÂť rate_limit_secs=30
áááşáá°áááᯠgeoip áááŻááŻááşááąáŹááşáááş áááŻáĄááşááŤáá áááŻáˇááąáŹááş áá°áááşá¸áá˝ážááşááźáŹá¸ááťááşááťáŹá¸ááᯠáááŻá¸ááŹá¸ááŤá
ááťá˝ááşáŻááşáááŻáˇáááş Nginx (áááşááąáŹááşáá˝ááˇáşáážááşáááşá¸ááťáŹá¸) â Vector (Client | Filebeat) â Vector (Server | Logstash) â Clickhouse áá˝ááş ááŽá¸ááźáŹá¸á áŽáážááˇáş Elasticsearch áá˝ááş ááŽá¸ááźáŹá¸á ᎠááąáŤááşá¸á ááşáááşáážááşááąá¸ááŤáááşá ááŹáᏠ4 áᯠáááşáááşááŤáááşá áááşá¸ááᯠááŹáᏠá ááŻááźááˇáş ááťáąáŹáşááźááşáááŻááşááąáŹáşáááşá¸á
áĄá áŽáĄá áĽáşá ááŽáááŻááťááŻá¸ááŤá
áááşáááŹááŹááťáŹá¸áĄáŹá¸ááŻáśá¸áá˝ááş Selinux áááŻááááşááŤá
sed -i 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
reboot
ááťá˝ááşáŻááşáááŻáˇáááş ááŹááŹáĄáŹá¸ááŻáśá¸áá˝ááş HTTP ááŹáᏠemulator + áĄááŻáśá¸áĄááąáŹááşáá ášá ááşá¸ááťáŹá¸ááᯠáááˇáşáá˝ááşá¸ááŤáááşá
HTTP server emulator áĄááźá
áşááťá˝ááşáŻááşáááŻáˇáĄááŻáśá¸ááźáŻááŤáááşá
Nodejs-stub-server áá˝ááş rpm ááážáááŤá
antonpatsev/nodejs-stub-server repository áááŻáááˇáşááŤá
yum -y install yum-plugin-copr epel-release
yes | yum copr enable antonpatsev/nodejs-stub-server
ááŹááŹáĄáŹá¸ááŻáśá¸áá˝ááş nodejs-stub-serverá Apache á áśáá˝ážááşá¸áážááˇáş ááťááşáážáŹááźááş terminal multiplexer ááᯠáááˇáşáá˝ááşá¸ááŤ
yum -y install stub_http_server screen mc httpd-tools screen
ááťá˝ááşáŻááşáááş /var/lib/stub_http_server/stub_http_server.js áááŻááşáážá stub_http_server ááŻáśáˇááźááşáážáŻáĄááťáááşááᯠááźááşááąá¸áá˛áˇááŤáááşá
var max_sleep = 10;
stub_http_server áááŻáá˝ááˇáşáááŻááşááĄáąáŹááşá
systemctl start stub_http_server
systemctl enable stub_http_server
Clickhouse áááşáááşááźááşá¸á ááŹáᏠá áá˝ááş
ClickHouse áááş SSE 4.2 áá˝ážááşááźáŹá¸ááťááşáĄá áŻáśáááŻáĄááŻáśá¸ááźáŻáááşá áááŻáˇááźáąáŹááˇáş áĄááźáŹá¸áááşáážááşááŹá¸ááźááşá¸ááážáááŤáá áĄááŻáśá¸ááźáŻááŹá¸áááˇáşááááŻáááşááŹáĄáá˝ááş ááśáˇáááŻá¸áážáŻáááş áĄáááŻá áá áşáááŻáĄááşááťááşáá áşááŻááźá áşááŹáááşá á¤áááşáážáŹ áááşáážá ááááŻáááşááŹáááş SSE 4.2 ááᯠááśáˇáááŻá¸ááźááşá¸ áážáá ááážá á á áşááąá¸áááş áá˝ážááşááźáŹá¸ááťááşááźá áşáááşá
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
áááááŻáśá¸ áááŹá¸áááş repository ááᯠááťáááşáááşáááş áááŻáĄááşáááş á
sudo yum install -y yum-utils
sudo rpm --import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.tech/rpm/stable/x86_64
áááşááąáˇááťáşááťáŹá¸ áááˇáşáá˝ááşá¸áááş áĄáąáŹááşá፠command ááťáŹá¸ááᯠááŻááşááąáŹááşáááş áááŻáĄááşáááş-
sudo yum install -y clickhouse-server clickhouse-client
áááŻááş /etc/clickhouse-server/config.xml áážá áá˝ááşáááşáááşááᯠááŹá¸ááąáŹááşáááş clickhouse-ááŹááŹáĄáŹá¸ áá˝ááˇáşááźáŻááŤá
<listen_host>0.0.0.0</listen_host>
áážááşáááşá¸áááşááźááşá¸áĄáááˇáşááž ááźáąááŹááśááźááşá¸ááž áĄáážáŹá¸áážáŹááźááşááźááşá¸áááŻáˇ ááźáąáŹááşá¸áá˛ááźááşá¸á
ááŽááŹááş
ááŻáśáážááşááťáŻáśáˇááťáááşáááşáááşááťáŹá¸-
min_compress_block_size 65536
max_compress_block_size 1048576
Zstd compression áááŻáĄáááşáá˝ááşá¸áááşá config áááŻááááᲠDDL áááŻáĄááŻáśá¸ááźáŻáááş áĄááźáśááźáŻááŹá¸áááşá
Google áá˝ááş DDL áážáá áşáááˇáş zstd ááťáŻáśáˇáááşá¸ááᯠáĄááŻáśá¸ááźáŻáááááŤá ááŤáá˛áˇ ááťá˝ááşááąáŹáşáááşá¸ ááŽáĄáááŻááşá¸ááŹá¸áá˛áˇáááŻááşáááşá
Clickhouse áá˝ááş zstd compression áááŻáĄááŻáśá¸ááźáŻááąáŹ ááŻááşááąáŹáşáááŻááşáááşááťáŹá¸á ááťáąá¸áá°á¸ááźáŻá áá˝ážááşááźáŹá¸ááťááşááťáŹá¸ááᯠááťážááąááŤá
ááŹááŹááᯠdaemon áĄááźá áşá áááşáááşá run ááŤá
service clickhouse-server start
áĄáᯠClickhouse ááᯠá áá˝ááˇáşááźááĄáąáŹááş
Clickhouse áááŻáˇáá˝áŹá¸ááŤá
clickhouse-client -h 172.26.10.109 -m
172.26.10.109 â Clickhouse áááˇáşáá˝ááşá¸áááˇáş ááŹááŹá IPá
vector database áá áşááŻáááşááŽá¸ááźááˇáşááĄáąáŹááş
CREATE DATABASE vector;
ááąááŹááąáˇá áşáážáááážá á á áşááąá¸ááźááˇáşááĄáąáŹááşá
show databases;
vector.logs áááŹá¸áá áşááŻáááşááŽá¸ááŤá
/* ĐŃĐž ŃайНиŃĐ° гдо Ń
ŃĐ°Đ˝ŃŃŃŃ ĐťĐžĐłĐ¸ как ĐľŃŃŃ */
CREATE TABLE vector.logs
(
`node_name` String,
`timestamp` DateTime,
`server_name` String,
`user_id` String,
`request_full` String,
`request_user_agent` String,
`request_http_host` String,
`request_uri` String,
`request_scheme` String,
`request_method` String,
`request_length` UInt64,
`request_time` Float32,
`request_referrer` String,
`response_status` UInt16,
`response_body_bytes_sent` UInt64,
`response_content_type` String,
`remote_addr` IPv4,
`remote_port` UInt32,
`remote_user` String,
`upstream_addr` IPv4,
`upstream_port` UInt32,
`upstream_bytes_received` UInt64,
`upstream_bytes_sent` UInt64,
`upstream_cache_status` String,
`upstream_connect_time` Float32,
`upstream_header_time` Float32,
`upstream_response_length` UInt64,
`upstream_response_time` Float32,
`upstream_status` UInt16,
`upstream_content_type` String,
INDEX idx_http_host request_http_host TYPE set(0) GRANULARITY 1
)
ENGINE = MergeTree()
PARTITION BY toYYYYMMDD(timestamp)
ORDER BY timestamp
TTL timestamp + toIntervalMonth(1)
SETTINGS index_granularity = 8192;
áááŹá¸ááťáŹá¸ááᯠáááşááŽá¸ááŹá¸ááźáąáŹááşá¸ ááťá˝ááşáŻááşáááŻáˇ á
á
áşááąá¸ááŤáááşá á
áááşáááŻááşááĄáąáŹááş clickhouse-client
ááąáŹááşá¸áááŻááťááşáá
áşááŻááźáŻááŻááşááŤá
vector database áááŻáá˝áŹá¸ááźááˇáşááĄáąáŹááşá
use vector;
Ok.
0 rows in set. Elapsed: 0.001 sec.
á áŹá¸áá˝á˛áá˝áąááᯠááźááˇáşááĄáąáŹááşá
show tables;
âânameâââââââââââââââââ
â logs â
âââââââââââââââââââââââ
Clickhouse áážááˇáş áážááŻááşá¸áážááşáááşáĄáá˝ááş Elasticsearch áááŻáˇ áĄááŹá¸áá°ááąááŹááąá¸áááŻáˇáááş 4th ááŹááŹáá˝ááş elasticsearch áááŻáááˇáşáá˝ááşá¸ááźááşá¸
áĄááťáŹá¸áá°áážáŹ rpm ááŽá¸ááᯠáááˇáşááŤá
rpm --import https://artifacts.elastic.co/GPG-KEY-elasticsearch
Repo 2 áᯠáááşááŽá¸ááźááˇáşááĄáąáŹááşá
/etc/yum.repos.d/elasticsearch.repo
[elasticsearch]
name=Elasticsearch repository for 7.x packages
baseurl=https://artifacts.elastic.co/packages/7.x/yum
gpgcheck=1
gpgkey=https://artifacts.elastic.co/GPG-KEY-elasticsearch
enabled=0
autorefresh=1
type=rpm-md
/etc/yum.repos.d/kibana.repo
[kibana-7.x]
name=Kibana repository for 7.x packages
baseurl=https://artifacts.elastic.co/packages/7.x/yum
gpgcheck=1
gpgkey=https://artifacts.elastic.co/GPG-KEY-elasticsearch
enabled=1
autorefresh=1
type=rpm-md
elasticsearch áážááˇáş kibana áááŻáááˇáşáá˝ááşá¸ááŤá
yum install -y kibana elasticsearch
áááşá¸áááş áááášáá° 1 ááŻáá˝ááş ááŤáážááááşááźá áşááąáŹááźáąáŹááˇáşá áááşáááş áĄáąáŹááşááŤáááŻáˇááᯠ/etc/elasticsearch/elasticsearch.yml áááŻááşáááŻáˇ áááˇáşáááş áááŻáĄááşáááş-
discovery.type: single-node
vector.host áááŻáĄááźáŹá¸ááŹááŹááž elasticsearch áááŻáˇááąááŹááąá¸áááŻáˇáááŻááşáááşá áááŻáˇáážáᏠnetwork.host áááŻááźáąáŹááşá¸ááźááŤá ááŻáˇá
network.host: 0.0.0.0
kibana áááŻáˇ ááťáááşáááşáááş /etc/kibana/kibana.yml áááŻááşáážá server.host ááŤááŹááŽááŹááᯠááźáąáŹááşá¸ááŤ
server.host: "0.0.0.0"
áĄááąáŹááşá¸áážááˇáş autostart áá˝ááş elasticsearch ááŤáááşáááşá
systemctl enable elasticsearch
systemctl start elasticsearch
áážááˇáş kibana
systemctl enable kibana
systemctl start kibana
single-node ááŻááş 1 shardá 0 ááŻáśá áśáá°áĄáá˝ááş Elasticsearch ááᯠááźááşáááşááźááşá¸á ááźá áşáááŻááşááťáąááťáŹá¸ááąáŹáĄáŹá¸ááźááˇáş áááˇáşáá˝ááş ááŹááŹáĄááťáŹá¸áĄááźáŹá¸ááĄá áŻáĄááąá¸áá áşááŻáážááááşááźá áşááźáŽá¸ áááşá¸áááŻáááşááŻááşááąáŹááşáááşááááŻáĄááşááŤá
áĄááŹáááşáĄáá˝ážááşá¸ááťáŹá¸áĄáá˝ááşá áá°áááşá¸ááŻáśá áśááŻáśá áśááᯠáĄááşááááşááŻááşááŤ-
curl -X PUT http://localhost:9200/_template/default -H 'Content-Type: application/json' -d '{"index_patterns": ["*"],"order": -1,"settings": {"number_of_shards": "1","number_of_replicas": "0"}}'
ustanovka áĄááťáŻáśá¸áááşáááşá ááŹáᏠ2 áážá Logstash áĄáá˝ááş áĄá
áŹá¸áááŻá¸áĄááźá
áş
yum install -y https://packages.timber.io/vector/0.9.X/vector-x86_64.rpm mc httpd-tools screen
Logstash áĄáá˝ááş áĄá áŹá¸áááŻá¸áĄááźá áş Vector ááᯠáááşáážááşááźááŤá ááŻáˇá /etc/vector/vector.toml áááŻááşááᯠáááşá¸ááźááşááźááşá¸á
# /etc/vector/vector.toml
data_dir = "/var/lib/vector"
[sources.nginx_input_vector]
# General
type = "vector"
address = "0.0.0.0:9876"
shutdown_timeout_secs = 30
[transforms.nginx_parse_json]
inputs = [ "nginx_input_vector" ]
type = "json_parser"
[transforms.nginx_parse_add_defaults]
inputs = [ "nginx_parse_json" ]
type = "lua"
version = "2"
hooks.process = """
function (event, emit)
function split_first(s, delimiter)
result = {};
for match in (s..delimiter):gmatch("(.-)"..delimiter) do
table.insert(result, match);
end
return result[1];
end
function split_last(s, delimiter)
result = {};
for match in (s..delimiter):gmatch("(.-)"..delimiter) do
table.insert(result, match);
end
return result[#result];
end
event.log.upstream_addr = split_first(split_last(event.log.upstream_addr, ', '), ':')
event.log.upstream_bytes_received = split_last(event.log.upstream_bytes_received, ', ')
event.log.upstream_bytes_sent = split_last(event.log.upstream_bytes_sent, ', ')
event.log.upstream_connect_time = split_last(event.log.upstream_connect_time, ', ')
event.log.upstream_header_time = split_last(event.log.upstream_header_time, ', ')
event.log.upstream_response_length = split_last(event.log.upstream_response_length, ', ')
event.log.upstream_response_time = split_last(event.log.upstream_response_time, ', ')
event.log.upstream_status = split_last(event.log.upstream_status, ', ')
if event.log.upstream_addr == "" then
event.log.upstream_addr = "127.0.0.1"
end
if (event.log.upstream_bytes_received == "-" or event.log.upstream_bytes_received == "") then
event.log.upstream_bytes_received = "0"
end
if (event.log.upstream_bytes_sent == "-" or event.log.upstream_bytes_sent == "") then
event.log.upstream_bytes_sent = "0"
end
if event.log.upstream_cache_status == "" then
event.log.upstream_cache_status = "DISABLED"
end
if (event.log.upstream_connect_time == "-" or event.log.upstream_connect_time == "") then
event.log.upstream_connect_time = "0"
end
if (event.log.upstream_header_time == "-" or event.log.upstream_header_time == "") then
event.log.upstream_header_time = "0"
end
if (event.log.upstream_response_length == "-" or event.log.upstream_response_length == "") then
event.log.upstream_response_length = "0"
end
if (event.log.upstream_response_time == "-" or event.log.upstream_response_time == "") then
event.log.upstream_response_time = "0"
end
if (event.log.upstream_status == "-" or event.log.upstream_status == "") then
event.log.upstream_status = "0"
end
emit(event)
end
"""
[transforms.nginx_parse_remove_fields]
inputs = [ "nginx_parse_add_defaults" ]
type = "remove_fields"
fields = ["data", "file", "host", "source_type"]
[transforms.nginx_parse_coercer]
type = "coercer"
inputs = ["nginx_parse_remove_fields"]
types.request_length = "int"
types.request_time = "float"
types.response_status = "int"
types.response_body_bytes_sent = "int"
types.remote_port = "int"
types.upstream_bytes_received = "int"
types.upstream_bytes_send = "int"
types.upstream_connect_time = "float"
types.upstream_header_time = "float"
types.upstream_response_length = "int"
types.upstream_response_time = "float"
types.upstream_status = "int"
types.timestamp = "timestamp"
[sinks.nginx_output_clickhouse]
inputs = ["nginx_parse_coercer"]
type = "clickhouse"
database = "vector"
healthcheck = true
host = "http://172.26.10.109:8123" # ĐĐ´ŃĐľŃ Clickhouse
table = "logs"
encoding.timestamp_format = "unix"
buffer.type = "disk"
buffer.max_size = 104900000
buffer.when_full = "block"
request.in_flight_limit = 20
[sinks.elasticsearch]
type = "elasticsearch"
inputs = ["nginx_parse_coercer"]
compression = "none"
healthcheck = true
# 172.26.10.116 - ŃĐľŃĐ˛ĐľŃ ĐłĐ´Đľ ŃŃŃанОвон elasticsearch
host = "http://172.26.10.116:9200"
index = "vector-%Y-%m-%d"
transforms.nginx_parse_add_defaults ááášáááᯠáááş ááťáááşáážááááŻááşáááşá
áážá
.
áĽáááŹ:
"upstream_addr": "128.66.0.10:443, 128.66.0.11:443, 128.66.0.12:443"
"upstream_bytes_received": "-, -, 123"
"upstream_status": "502, 502, 200"
ááŤá áááˇáşáĄááźáąáĄááąáááŻááşáááş ááŽáĄáááŻááşá¸ááᯠáááŻá¸áážááşá¸áĄáąáŹááş ááŻááşáááŻááşááŤáááşá
systemd /etc/systemd/system/vector.service áĄáá˝ááş áááşááąáŹááşáážáŻáááşáááşááťáŹá¸ááᯠáááşááŽá¸ááźááŤá ááŻáˇ
# /etc/systemd/system/vector.service
[Unit]
Description=Vector
After=network-online.target
Requires=network-online.target
[Service]
User=vector
Group=vector
ExecStart=/usr/bin/vector
ExecReload=/bin/kill -HUP $MAINPID
Restart=no
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=vector
[Install]
WantedBy=multi-user.target
áááŹá¸ááťáŹá¸áááŻáááşááŽá¸ááźáŽá¸ááąáŹááşá áááşáááş Vector áááŻáá˝ááˇáşáááŻááşáááşá
systemctl enable vector
systemctl start vector
Vector áážááşáááşá¸ááťáŹá¸ááᯠá¤áá˛áˇáááŻáˇááźááˇáşáážáŻáááŻááşáááş-
journalctl -f -u vector
áážááşáááşá¸ááťáŹá¸áá˝ááş á¤áá˛áˇáááŻáˇ áááˇáşáá˝ááşá¸áážáŻááťáŹá¸ áážááááˇáşáááşá
INFO vector::topology::builder: Healthcheck: Passed.
INFO vector::topology::builder: Healthcheck: Passed.
ááááŻááşá¸áááˇáş (áááşááŹááŹ) áá˝ááş - 1st ááŹááŹ
clickhouse áážá áážááşáááşá¸áááŹá¸áááş áĄáá˝ááşááᯠáĄááŻáśá¸ááźáŻááŹá¸ááąáŹááźáąáŹááˇáş nginx ááźááˇáş ááŹááŹáá˝ááş ipv6 ááᯠááááşáááş áááŻáĄááşááŤáááşá upstream_addr
IPv4á áá˝ááşáááşáá˛áážáŹ ipv6 ááᯠáĄááŻáśá¸áááźáŻáá˛áˇáĄáá˝ááşá ipv6 ááᯠáááááşááŤá errors ááťáŹá¸ áážáááááˇáşáááş á
DB::Exception: Invalid IPv4 value.: (while read the value of key upstream_addr)
á áŹáááşáá°ááťáŹá¸á ipv6 ááśáˇáááŻá¸áážáŻáááˇáşááŤá
/etc/sysctl.d/98-disable-ipv6.conf áááŻááşááᯠáááşááŽá¸ááŤá
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
áááşáááşááťáŹá¸ááᯠáĄááŻáśá¸ááźáŻááźááşá¸á
sysctl --system
nginx ááᯠinstall ááŻááşááĄáąáŹááşá
nginx repository áááŻááş /etc/yum.repos.d/nginx.repo ááᯠáááˇáşááŹá¸áááş
[nginx-stable]
name=nginx stable repo
baseurl=http://nginx.org/packages/centos/$releasever/$basearch/
gpgcheck=1
enabled=1
gpgkey=https://nginx.org/keys/nginx_signing.key
module_hotfixes=true
nginx áĄááŻááşááᯠinstall ááŻááşááŤá
yum install -y nginx
áŚá¸á á˝áŹá ááťá˝ááşáŻááşáááŻáˇáááş /etc/nginx/nginx.conf áááŻááşáá˝ááş Nginx áážá áážááşáááşá¸ááąáŹáşáááşááᯠáááşáážááşáááş áááŻáĄááşáááşá
user nginx;
# you must set worker processes based on your CPU cores, nginx does not benefit from setting more than that
worker_processes auto; #some last versions calculate it automatically
# number of file descriptors used for nginx
# the limit for the maximum FDs on the server is usually set by the OS.
# if you don't set FD's then OS settings will be used which is by default 2000
worker_rlimit_nofile 100000;
error_log /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;
# provides the configuration file context in which the directives that affect connection processing are specified.
events {
# determines how much clients will be served per worker
# max clients = worker_connections * worker_processes
# max clients is also limited by the number of socket connections available on the system (~64k)
worker_connections 4000;
# optimized to serve many clients with each thread, essential for linux -- for testing environment
use epoll;
# accept as many connections as possible, may flood worker connections if set too low -- for testing environment
multi_accept on;
}
http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
log_format vector escape=json
'{'
'"node_name":"nginx-vector",'
'"timestamp":"$time_iso8601",'
'"server_name":"$server_name",'
'"request_full": "$request",'
'"request_user_agent":"$http_user_agent",'
'"request_http_host":"$http_host",'
'"request_uri":"$request_uri",'
'"request_scheme": "$scheme",'
'"request_method":"$request_method",'
'"request_length":"$request_length",'
'"request_time": "$request_time",'
'"request_referrer":"$http_referer",'
'"response_status": "$status",'
'"response_body_bytes_sent":"$body_bytes_sent",'
'"response_content_type":"$sent_http_content_type",'
'"remote_addr": "$remote_addr",'
'"remote_port": "$remote_port",'
'"remote_user": "$remote_user",'
'"upstream_addr": "$upstream_addr",'
'"upstream_bytes_received": "$upstream_bytes_received",'
'"upstream_bytes_sent": "$upstream_bytes_sent",'
'"upstream_cache_status":"$upstream_cache_status",'
'"upstream_connect_time":"$upstream_connect_time",'
'"upstream_header_time":"$upstream_header_time",'
'"upstream_response_length":"$upstream_response_length",'
'"upstream_response_time":"$upstream_response_time",'
'"upstream_status": "$upstream_status",'
'"upstream_content_type":"$upstream_http_content_type"'
'}';
access_log /var/log/nginx/access.log main;
access_log /var/log/nginx/access.json.log vector; # ĐОвŃĐš НОг в ŃĐžŃПаŃĐľ json
sendfile on;
#tcp_nopush on;
keepalive_timeout 65;
#gzip on;
include /etc/nginx/conf.d/*.conf;
}
áááşá áááşáážááá˝á˛áˇá ááşá¸ááŻáśááᯠááťááŻá¸ááťááşáááş Nginx áááş áááˇáşáĄáŹá¸ access_log áááşá¸áá˝ážááşááťááşááťáŹá¸á á˝áŹááᯠááážáá áąáááşááźá áşáááşá
access_log /var/log/nginx/access.log main; # ĐĄŃандаŃŃĐ˝ŃĐš НОг
access_log /var/log/nginx/access.json.log vector; # ĐОвŃĐš НОг в ŃĐžŃПаŃĐľ json
áážááşáááşá¸áĄáá áşááťáŹá¸áĄáá˝ááş logrotate ááŻááşáááş á ááşá¸ááťááşá¸áá áşááŻáááˇáşáááş áááąáˇááŤáážááˇáş (áážááşáááşá¸áááŻááşáááş .log áážááˇáş áááŻáśá¸ááŤá)
default.conf ááᯠ/etc/nginx/conf.d/ ááž áááşáážáŹá¸ááŤ
rm -f /etc/nginx/conf.d/default.conf
virtual host /etc/nginx/conf.d/vhost1.conf áááˇáşááŤá
server {
listen 80;
server_name vhost1;
location / {
proxy_pass http://172.26.10.106:8080;
}
}
virtual host /etc/nginx/conf.d/vhost2.conf áááˇáşááŤá
server {
listen 80;
server_name vhost2;
location / {
proxy_pass http://172.26.10.108:8080;
}
}
virtual host /etc/nginx/conf.d/vhost3.conf áááˇáşááŤá
server {
listen 80;
server_name vhost3;
location / {
proxy_pass http://172.26.10.109:8080;
}
}
virtual host /etc/nginx/conf.d/vhost4.conf áááˇáşááŤá
server {
listen 80;
server_name vhost4;
location / {
proxy_pass http://172.26.10.116:8080;
}
}
/etc/hosts áááŻááşáááŻáˇ ááŹááŹááťáŹá¸áĄáŹá¸ááŻáśá¸áááŻáˇ nginx áááˇáşáá˝ááşá¸áááˇáş ááŹááŹá 172.26.10.106 ip ááᯠvirtual hosts ááťáŹá¸ áááˇáşááŤ-
172.26.10.106 vhost1
172.26.10.106 vhost2
172.26.10.106 vhost3
172.26.10.106 vhost4
áĄáŹá¸ááŻáśá¸áĄáááşáááˇáşááźá áşááťážááş
nginx -t
systemctl restart nginx
ááᯠáááşá¸ááᯠáááŻááşáááŻááşáááˇáşáá˝ááşá¸áááŻááşááźááŤá
ááŻáˇ
yum install -y https://packages.timber.io/vector/0.9.X/vector-x86_64.rpm
systemd /etc/systemd/system/vector.service áĄáá˝ááş áááşáááşáááŻááşáá áşáᯠáááşááŽá¸ááźááŤá ááŻáˇ
[Unit]
Description=Vector
After=network-online.target
Requires=network-online.target
[Service]
User=vector
Group=vector
ExecStart=/usr/bin/vector
ExecReload=/bin/kill -HUP $MAINPID
Restart=no
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=vector
[Install]
WantedBy=multi-user.target
áážááˇáş /etc/vector/vector.toml config áá˝ááş Filebeat áĄá áŹá¸áááŻá¸áážáŻááᯠá áŽá ááşáááşáážááşááŤá IP ááááşá Ꮰ172.26.10.108 áááş áážááşáááşá¸ááŹáᏠ(Vector-Server) á IP ááááşá áŹááźá áşáááş
data_dir = "/var/lib/vector"
[sources.nginx_file]
type = "file"
include = [ "/var/log/nginx/access.json.log" ]
start_at_beginning = false
fingerprinting.strategy = "device_and_inode"
[sinks.nginx_output_vector]
type = "vector"
inputs = [ "nginx_file" ]
address = "172.26.10.108:9876"
áážááşáááşá¸áááŻááşááťáŹá¸ááᯠáááşáááŻááşá áąáááş áááŻáĄááşááąáŹáĄáŻááşá áŻáá˝ááş vector áĄááŻáśá¸ááźáŻáá°ááᯠáááˇáşáááş áááąáˇááŤáážááˇáşá áĽáááŹáĄáŹá¸ááźááˇáşá centos áážá nginx áááş adm áĄáá˝á˛áˇáĄáá˝ááˇáşáĄááąá¸ááťáŹá¸ááźááˇáş áážááşáááşá¸ááťáŹá¸ááᯠáááşááŽá¸áááşá
usermod -a -G adm vector
vector áááşááąáŹááşáážáŻááᯠá áááŻááşááĄáąáŹááş
systemctl enable vector
systemctl start vector
Vector áážááşáááşá¸ááťáŹá¸ááᯠá¤áá˛áˇáááŻáˇááźááˇáşáážáŻáááŻááşáááş-
journalctl -f -u vector
áážááşáááşá¸ááťáŹá¸áá˝ááş á¤áá˛áˇáááŻáˇááąáŹ áááşáá˝ááˇáşáá áşáᯠáážááááˇáşáááşá
INFO vector::topology::builder: Healthcheck: Passed.
á áááşááá áŽá¸áážáŻá ááşá¸áááşááźááşá¸á
ááťá˝ááşáŻááşáááŻáˇáááş Apache á áśáá˝ážááşá¸ááᯠáĄááŻáśá¸ááźáŻá á ááşá¸áááşáážáŻááťáŹá¸ ááŻááşááąáŹááşááŤáááşá
httpd-tools package ááᯠááŹááŹáĄáŹá¸ááŻáśá¸áá˝ááş áááˇáşáá˝ááşá¸ááŹá¸áááşá
ááťá˝ááşáŻááşáááŻáˇáááş á
ááááşáážá ááá°ááŽááąáŹááŹáᏠ4 ááŻááž Apache á
áśáá˝ážááşá¸áááŻáĄááŻáśá¸ááźáŻá á
áááşá
ááşá¸áááşááŤáááşá ááááŚá¸á
á˝áŹá ááťá˝ááşáŻááşáááŻáˇáááş á
ááááş terminal multiplexer áááŻáá˝ááˇáşááźáŽá¸á áááŻáˇááąáŹááş Apache benchmark áááŻáĄááŻáśá¸ááźáŻá á
áááşá
ááşá¸áááşááŤáááşá áááşááŹá¸ááźááşááźááˇáş áááşáááŻáˇááŻááşááąáŹááşááááşááᯠáááşáážáŹáá˝áąáááŻááşááŤáááşá
1st server ááž
while true; do ab -H "User-Agent: 1server" -c 100 -n 10 -t 10 http://vhost1/; sleep 1; done
2st server ááž
while true; do ab -H "User-Agent: 2server" -c 100 -n 10 -t 10 http://vhost2/; sleep 1; done
3st server ááž
while true; do ab -H "User-Agent: 3server" -c 100 -n 10 -t 10 http://vhost3/; sleep 1; done
4st server ááž
while true; do ab -H "User-Agent: 4server" -c 100 -n 10 -t 10 http://vhost4/; sleep 1; done
Clickhouse áá˝ááşááąááŹáááŻá á áşááąá¸ááźááŤá ááŻáˇ
Clickhouse áááŻáˇáá˝áŹá¸ááŤá
clickhouse-client -h 172.26.10.109 -m
SQL query áá áşááŻááźáŻááŻááşááźááşá¸á
SELECT * FROM vector.logs;
âânode_nameâââââŹâââââââââââtimestampââŹâserver_nameââŹâuser_idââŹârequest_fullââââŹârequest_user_agentââŹârequest_http_hostââŹârequest_uriââŹârequest_schemeââŹârequest_methodââŹârequest_lengthââŹârequest_timeââŹârequest_referrerââŹâresponse_statusââŹâresponse_body_bytes_sentââŹâresponse_content_typeââŹâââremote_addrââŹâremote_portââŹâremote_userââŹâupstream_addrââŹâupstream_portââŹâupstream_bytes_receivedââŹâupstream_bytes_sentââŹâupstream_cache_statusââŹâupstream_connect_timeââŹâupstream_header_timeââŹâupstream_response_lengthââŹâupstream_response_timeââŹâupstream_statusââŹâupstream_content_typeââ
â nginx-vector â 2020-08-07 04:32:42 â vhost1 â â GET / HTTP/1.0 â 1server â vhost1 â / â http â GET â 66 â 0.028 â â 404 â 27 â â 172.26.10.106 â 45886 â â 172.26.10.106 â 0 â 109 â 97 â DISABLED â 0 â 0.025 â 27 â 0.029 â 404 â â
ââââââââââââââââ´ââââââââââââââââââââââ´ââââââââââââââ´ââââââââââ´âââââââââââââââââ´âââââââââââââââââââââ´ââââââââââââââââââââ´ââââââââââââââ´âââââââââââââââââ´âââââââââââââââââ´âââââââââââââââââ´âââââââââââââââ´âââââââââââââââââââ´ââââââââââââââââââ´âââââââââââââââââââââââââââ´ââââââââââââââââââââââââ´ââââââââââââââââ´ââââââââââââââ´ââââââââââââââ´ââââââââââââââââ´ââââââââââââââââ´ââââââââââââââââââââââââââ´ââââââââââââââââââââââ´ââââââââââââââââââââââââ´ââââââââââââââââââââââââ´âââââââââââââââââââââââ´âââââââââââââââââââââââââââ´âââââââââââââââââââââââââ´ââââââââââââââââââ´âââââââââââââââââââââââ
Clickhouse áážá áááŹá¸ááťáŹá¸á áĄáá˝ááşáĄá áŹá¸ááᯠáážáŹáá˝áąááŤá
select concat(database, '.', table) as table,
formatReadableSize(sum(bytes)) as size,
sum(rows) as rows,
max(modification_time) as latest_modification,
sum(bytes) as bytes_size,
any(engine) as engine,
formatReadableSize(sum(primary_key_bytes_in_memory)) as primary_keys_size
from system.parts
where active
group by database, table
order by bytes_size desc;
Clickhouse áá˝ááş áážááşáááşá¸áááşááťážáážááááşááᯠáážáŹáá˝áąááźááˇáşááźááŤá ááŻáˇá
áážááşáááşá¸áááŹá¸áĄáá˝ááşáĄá áŹá¸áážáŹ 857.19 MB ááźá áşáááşá
Elasticsearch áážá áĄáá˝ážááşá¸ááááşá¸áážá áá°ááŽááąáŹááąááŹáĄáá˝ááşáĄá áŹá¸áážáŹ 4,5GB ááźá áşáááşá
áááˇáşáááşááťááşááťáŹá¸áážá vector áá˝ááşááąááŹáááŻááááşáážááşááŤá Clickhouse áááş Elasticsearch áááş 4500/857.19 = 5.24 ááááŻáááşá¸áááşá
vector áá˝ááşá compression field ááᯠáá°áááşá¸áĄáááŻááşá¸áĄááŻáśá¸ááźáŻáááşá
áááşááŽááááşááźááˇáş á
ááŹá¸ááźáąáŹáááŻáááşá
áááşááŽááááşááźááˇáş á
ááŹá¸ááźáąáŹáááŻáááşá
"áááşááŽááááş"
source: www.habr.com