โ
Rust ์ธ์ด๋ก ์์ฑ๋์ด ์ ์ฌ ์ธ์ด์ ๋นํด ์ฑ๋ฅ์ด ๋ฐ์ด๋๊ณ RAM ์๋น๊ฐ ์ ์ ๊ฒ์ด ํน์ง์ ๋๋ค. ๋ํ ์ ํ์ฑ๊ณผ ๊ด๋ จ๋ ๊ธฐ๋ฅ, ํนํ ์ ์ก๋์ง ์์ ์ด๋ฒคํธ๋ฅผ ๋์คํฌ์ ๋ฒํผ์ ์ ์ฅํ๊ณ ํ์ผ์ ํ์ ํ๋ ๊ธฐ๋ฅ์ ๋ง์ ๊ด์ฌ์ ๊ธฐ์ธ์ ๋๋ค.
๊ตฌ์กฐ์ ์ผ๋ก Vector๋ ํ๋ ์ด์์ ๋ฉ์์ง๋ฅผ ์์ ํ๋ ์ด๋ฒคํธ ๋ผ์ฐํฐ์ ๋๋ค. ์ถ์ฒ, ์ ํ์ ์ผ๋ก ์ด๋ฌํ ๋ฉ์์ง์ ์ ์ฉ ๋ณํ, ํ๋ ์ด์์ ์ฌ๋์๊ฒ ๋ณด๋ ๋๋ค. ๋ฐฐ์๊ตฌ.
Vector๋ filebeat์ logstash๋ฅผ ๋์ฒดํ๋ฉฐ ๋ ๊ฐ์ง ์ญํ (๋ก๊ทธ ์์ ๋ฐ ์ ์ก)์ ๋ชจ๋ ์ํํ ์ ์์ต๋๋ค. ์ด์ ๋ํ ์์ธํ ๋ด์ฉ์ ๋ค์๊ณผ ๊ฐ์ต๋๋ค.
Logstash์์ ์ฒด์ธ์ด ์
๋ ฅ โ ํํฐ โ ์ถ๋ ฅ์ผ๋ก ๊ตฌ์ถ๋ ๊ฒฝ์ฐ 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(์ก์ธ์ค ๋ก๊ทธ) โ ๋ฒกํฐ(ํด๋ผ์ด์ธํธ | Filebeat) โ ๋ฒกํฐ(์๋ฒ | Logstash) โ ์กฐํฉ์ Clickhouse์์ ๋ณ๋๋ก, Elasticsearch์์ ๋ณ๋๋ก ๊ตฌ์ฑํ๊ฒ ์ต๋๋ค. 4๊ฐ์ ์๋ฒ๋ฅผ ์ค์นํ๊ฒ ์ต๋๋ค. 3๊ฐ์ ์๋ฒ๋ก ์ฐํํ ์ ์์ง๋ง.
๊ณํ์ ๋ค์๊ณผ ๊ฐ์ต๋๋ค.
๋ชจ๋ ์๋ฒ์์ Selinux๋ฅผ ๋นํ์ฑํํฉ๋๋ค.
sed -i 's/^SELINUX=.*/SELINUX=disabled/g' /etc/selinux/config
reboot
๋ชจ๋ ์๋ฒ์ HTTP ์๋ฒ ์๋ฎฌ๋ ์ดํฐ + ์ ํธ๋ฆฌํฐ๋ฅผ ์ค์นํฉ๋๋ค.
HTTP ์๋ฒ ์๋ฎฌ๋ ์ดํฐ๋ก์ ์ฐ๋ฆฌ๋
Nodejs-stub-server์๋ rpm์ด ์์ต๋๋ค.
antonpatsev/nodejs-stub-server ์ ์ฅ์ ์ถ๊ฐ
yum -y install yum-plugin-copr epel-release
yes | yum copr enable antonpatsev/nodejs-stub-server
๋ชจ๋ ์๋ฒ์ nodejs-stub-server, Apache ๋ฒค์น๋งํฌ ๋ฐ ํ๋ฉด ํฐ๋ฏธ๋ ๋ฉํฐํ๋ ์๋ฅผ ์ค์นํฉ๋๋ค.
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
ํด๋ฆญํ์ฐ์ค ์ค์น ์๋ฒ 3์์
ClickHouse๋ SSE 4.2 ๋ช ๋ น ์ธํธ๋ฅผ ์ฌ์ฉํ๋ฏ๋ก ๋ณ๋๋ก ์ง์ ํ์ง ์๋ ํ ์ฌ์ฉ๋๋ ํ๋ก์ธ์์์ ์ด์ ๋ํ ์ง์์ ์ถ๊ฐ ์์คํ ์๊ตฌ ์ฌํญ์ด ๋ฉ๋๋ค. ๋ค์์ ํ์ฌ ํ๋ก์ธ์๊ฐ SSE 4.2๋ฅผ ์ง์ํ๋์ง ํ์ธํ๋ ๋ช ๋ น์ ๋๋ค.
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
๋จผ์ ๊ณต์ ์ ์ฅ์๋ฅผ ์ฐ๊ฒฐํด์ผ ํฉ๋๋ค:
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
ํจํค์ง๋ฅผ ์ค์นํ๋ ค๋ฉด ๋ค์ ๋ช ๋ น์ ์คํํด์ผ ํฉ๋๋ค.
sudo yum install -y clickhouse-server clickhouse-client
clickhouse-server๊ฐ /etc/clickhouse-server/config.xml ํ์ผ์์ ๋คํธ์ํฌ ์นด๋๋ฅผ ์์ ํ๋๋ก ํ์ฉํฉ๋๋ค.
<listen_host>0.0.0.0</listen_host>
์ถ์ ์์ ๋๋ฒ๊ทธ๋ก ๋ก๊น ์์ค ๋ณ๊ฒฝ
๋๋ฒ๊ทธ
ํ์ค ์์ถ ์ค์ :
min_compress_block_size 65536
max_compress_block_size 1048576
Zstd ์์ถ์ ํ์ฑํํ๋ ค๋ฉด ๊ตฌ์ฑ์ ๊ฑด๋๋ฆฌ์ง ๋ง๊ณ DDL์ ์ฌ์ฉํ๋ ๊ฒ์ด ์ข์ต๋๋ค.
Google์์ DDL์ ํตํด zstd ์์ถ์ ์ฌ์ฉํ๋ ๋ฐฉ๋ฒ์ ์ฐพ์ ์ ์์ต๋๋ค. ๊ทธ๋์ ๊ทธ๋๋ก ๋์์ต๋๋ค.
Clickhouse์์ zstd ์์ถ์ ์ฌ์ฉํ๋ ๋๋ฃ๋ค์ ์ง์นจ์ ๊ณต์ ํด ์ฃผ์ธ์.
์๋ฒ๋ฅผ ๋ฐ๋ชฌ์ผ๋ก ์์ํ๋ ค๋ฉด ๋ค์์ ์คํํ์ธ์.
service clickhouse-server start
์ด์ Clickhouse ์ค์ ์ผ๋ก ๋์ด๊ฐ๊ฒ ์ต๋๋ค.
ํด๋ฆญํ์ฐ์ค ๋ฐ๋ก๊ฐ๊ธฐ
clickhouse-client -h 172.26.10.109 -m
172.26.10.109 โ ํด๋ฆญํ์ฐ์ค๊ฐ ์ค์น๋ ์๋ฒ์ IP์ ๋๋ค.
๋ฒกํฐ ๋ฐ์ดํฐ๋ฒ ์ด์ค๋ฅผ ๋ง๋ค์ด ๋ด ์๋ค
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
๊ทธ๋ฆฌ๊ณ ์์ฒญ์ ํด๋ณด์ธ์.
๋ฒกํฐ ๋ฐ์ดํฐ๋ฒ ์ด์ค๋ก ๊ฐ๋ณด๊ฒ ์ต๋๋ค.
use vector;
Ok.
0 rows in set. Elapsed: 0.001 sec.
ํ ์ด๋ธ์ ์ดํด ๋ณด๊ฒ ์ต๋๋ค.
show tables;
โโnameโโโโโโโโโโโโโโโโโ
โ logs โ
โโโโโโโโโโโโโโโโโโโโโโโ
Clickhouse์์ ๋น๊ต๋ฅผ ์ํด ๋์ผํ ๋ฐ์ดํฐ๋ฅผ Elasticsearch๋ก ๋ณด๋ด๊ธฐ ์ํด 4๋ฒ์งธ ์๋ฒ์ elasticsearch๋ฅผ ์ค์นํฉ๋๋ค.
๊ณต๊ฐ rpm ํค ์ถ๊ฐ
rpm --import https://artifacts.elastic.co/GPG-KEY-elasticsearch
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
๋ฒกํฐ๊ฐ ๋ค๋ฅธ ์๋ฒ์์ Elasticsearch๋ก ๋ฐ์ดํฐ๋ฅผ ๋ณด๋ผ ์ ์๋๋ก network.host๋ฅผ ๋ณ๊ฒฝํด ๋ณด๊ฒ ์ต๋๋ค.
network.host: 0.0.0.0
Kibana์ ์ฐ๊ฒฐํ๋ ค๋ฉด /etc/kibana/kibana.yml ํ์ผ์์ server.host ๋งค๊ฐ๋ณ์๋ฅผ ๋ณ๊ฒฝํ์ญ์์ค.
server.host: "0.0.0.0"
์ค๋๋์์ผ๋ฉฐ ์๋ ์์์ elasticsearch ํฌํจ
systemctl enable elasticsearch
systemctl start elasticsearch
๊ทธ๋ฆฌ๊ณ ํค๋ฐ๋
systemctl enable kibana
systemctl start kibana
๋จ์ผ ๋ ธ๋ ๋ชจ๋ ์ค๋ 1๊ฐ, ๋ณต์ ๋ณธ 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"}}'
์ค์น ๋ฒกํฐ ์๋ฒ 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"
๋ณํ.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
๋ฒกํฐ ๋ก๊ทธ๋ ๋ค์๊ณผ ๊ฐ์ด ๋ณผ ์ ์์ต๋๋ค.
journalctl -f -u vector
๋ก๊ทธ์ ์ด์ ๊ฐ์ ํญ๋ชฉ์ด ์์ด์ผ ํฉ๋๋ค.
INFO vector::topology::builder: Healthcheck: Passed.
INFO vector::topology::builder: Healthcheck: Passed.
ํด๋ผ์ด์ธํธ(์น ์๋ฒ) - ์ฒซ ๋ฒ์งธ ์๋ฒ
nginx๊ฐ ์๋ ์๋ฒ์์๋ clickhouse์ ๋ก๊ทธ ํ
์ด๋ธ์ด ํ๋๋ฅผ ์ฌ์ฉํ๋ฏ๋ก ipv6์ ๋นํ์ฑํํด์ผ ํฉ๋๋ค. upstream_addr
IPv4, ๋คํธ์ํฌ ๋ด๋ถ์์ ipv6์ ์ฌ์ฉํ์ง ์๊ธฐ ๋๋ฌธ์
๋๋ค. ipv6์ ๋์ง ์์ผ๋ฉด ์ค๋ฅ๊ฐ ๋ฐ์ํฉ๋๋ค.
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๋ฅผ ์ค์นํด๋ณด์.
nginx ์ ์ฅ์ ํ์ผ /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 ํจํค์ง ์ค์น
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๋ก ๋๋์ง ์๋ ๊ฒฝ์ฐ).
/etc/nginx/conf.d/์์ default.conf๋ฅผ ์ ๊ฑฐํฉ๋๋ค.
rm -f /etc/nginx/conf.d/default.conf
๊ฐ์ ํธ์คํธ ์ถ๊ฐ /etc/nginx/conf.d/vhost1.conf
server {
listen 80;
server_name vhost1;
location / {
proxy_pass http://172.26.10.106:8080;
}
}
๊ฐ์ ํธ์คํธ ์ถ๊ฐ /etc/nginx/conf.d/vhost2.conf
server {
listen 80;
server_name vhost2;
location / {
proxy_pass http://172.26.10.108:8080;
}
}
๊ฐ์ ํธ์คํธ ์ถ๊ฐ /etc/nginx/conf.d/vhost3.conf
server {
listen 80;
server_name vhost3;
location / {
proxy_pass http://172.26.10.109:8080;
}
}
๊ฐ์ ํธ์คํธ ์ถ๊ฐ /etc/nginx/conf.d/vhost4.conf
server {
listen 80;
server_name vhost4;
location / {
proxy_pass http://172.26.10.116:8080;
}
}
๋ชจ๋ ์๋ฒ์ ๊ฐ์ ํธ์คํธ(nginx๊ฐ ์ค์น๋ ์๋ฒ์ 172.26.10.106 IP)๋ฅผ /etc/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 ๊ตฌ์ฑ์์ 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"
๋ฒกํฐ ์ฌ์ฉ์๊ฐ ๋ก๊ทธ ํ์ผ์ ์ฝ์ ์ ์๋๋ก ํ์ ๊ทธ๋ฃน์ ๋ฒกํฐ ์ฌ์ฉ์๋ฅผ ์ถ๊ฐํ๋ ๊ฒ์ ์์ง ๋ง์ญ์์ค. ์๋ฅผ ๋ค์ด centos์ nginx๋ adm ๊ทธ๋ฃน ๊ถํ์ผ๋ก ๋ก๊ทธ๋ฅผ ์์ฑํฉ๋๋ค.
usermod -a -G adm vector
๋ฒกํฐ ์๋น์ค๋ฅผ ์์ํด๋ณด์
systemctl enable vector
systemctl start vector
๋ฒกํฐ ๋ก๊ทธ๋ ๋ค์๊ณผ ๊ฐ์ด ๋ณผ ์ ์์ต๋๋ค.
journalctl -f -u vector
๋ก๊ทธ์ ์ด์ ๊ฐ์ ํญ๋ชฉ์ด ์์ด์ผ ํฉ๋๋ค.
INFO vector::topology::builder: Healthcheck: Passed.
์คํธ๋ ์ค ํ ์คํธ
Apache ๋ฒค์น๋งํฌ๋ฅผ ์ด์ฉํ์ฌ ํ ์คํธ๋ฅผ ์งํํฉ๋๋ค.
httpd-tools ํจํค์ง๊ฐ ๋ชจ๋ ์๋ฒ์ ์ค์น๋์์ต๋๋ค.
ํ๋ฉด์ ํ์๋ 4๊ฐ์ ๋ค๋ฅธ ์๋ฒ์์ Apache ๋ฒค์น๋งํฌ๋ฅผ ์ฌ์ฉํ์ฌ ํ
์คํธ๋ฅผ ์์ํฉ๋๋ค. ๋จผ์ ์คํฌ๋ฆฐ ํฐ๋ฏธ๋ ๋ฉํฐํ๋ ์๋ฅผ ์์ํ ๋ค์ Apache ๋ฒค์น๋งํฌ๋ฅผ ์ฌ์ฉํ์ฌ ํ
์คํธ๋ฅผ ์์ํฉ๋๋ค. ํ๋ฉด ์์
๋ฐฉ๋ฒ์ ๋ค์์์ ์ฐพ์ ์ ์์ต๋๋ค.
1์ฐจ ์๋ฒ๋ถํฐ
while true; do ab -H "User-Agent: 1server" -c 100 -n 10 -t 10 http://vhost1/; sleep 1; done
2์ฐจ ์๋ฒ๋ถํฐ
while true; do ab -H "User-Agent: 2server" -c 100 -n 10 -t 10 http://vhost2/; sleep 1; done
3์ฐจ ์๋ฒ๋ถํฐ
while true; do ab -H "User-Agent: 3server" -c 100 -n 10 -t 10 http://vhost3/; sleep 1; done
4์ฐจ ์๋ฒ๋ถํฐ
while true; do ab -H "User-Agent: 4server" -c 100 -n 10 -t 10 http://vhost4/; sleep 1; done
ํด๋ฆญํ์ฐ์ค์์ ๋ฐ์ดํฐ๋ฅผ ํ์ธํด๋ณด์
ํด๋ฆญํ์ฐ์ค ๋ฐ๋ก๊ฐ๊ธฐ
clickhouse-client -h 172.26.10.109 -m
SQL ์ฟผ๋ฆฌ ๋ง๋ค๊ธฐ
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 โ โ
โโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโดโโโโโโโโโโดโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโดโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโดโโโโโโโโโโโโโโโโโโโโโโโ
ํด๋ฆญํ์ฐ์ค ํ ์ด๋ธ ํฌ๊ธฐ ์์๋ณด๊ธฐ
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;
ํด๋ฆญํ์ฐ์ค์์ ๋ก๊ทธ๊ฐ ์ผ๋ง๋ ์ฐจ์งํ๋์ง ์์๋ด ์๋ค.
๋ก๊ทธ ํ ์ด๋ธ ํฌ๊ธฐ๋ 857.19MB์ ๋๋ค.
Elasticsearch์ ์ธ๋ฑ์ค์ ์๋ ๋์ผํ ๋ฐ์ดํฐ์ ํฌ๊ธฐ๋ 4,5GB์ ๋๋ค.
๋งค๊ฐ๋ณ์์ ๋ฒกํฐ์ ๋ฐ์ดํฐ๋ฅผ ์ง์ ํ์ง ์์ผ๋ฉด Clickhouse๋ Elasticsearch๋ณด๋ค 4500/857.19 = 5.24๋ฐฐ ์ ์ ์์ ์ฐจ์งํฉ๋๋ค.
๋ฒกํฐ์์๋ ๊ธฐ๋ณธ์ ์ผ๋ก ์์ถ ํ๋๊ฐ ์ฌ์ฉ๋ฉ๋๋ค.
ํ
๋ ๊ทธ๋จ ์ฑํ
ํ
๋ ๊ทธ๋จ ์ฑํ
ํ
๋ ๊ทธ๋จ ์ฑํ
"
์ถ์ฒ : habr.com