{"id":308229,"date":"2020-08-10T09:00:30","date_gmt":"2020-08-10T09:00:30","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=308229"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=308229","title":{"rendered":"\u041e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 Nginx json \u043b\u043e\u0433\u043e\u0432 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Vector \u0432 Clickhouse \u0438 Elasticsearch"},"content":{"rendered":"\n<div class=\"post__text post__text-html post__text_v1\" id=\"post-content-body\" data-io-article-url=\"https:\/\/habr.com\/ru\/post\/514480\/\">\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/hs\/th\/d5\/hsthd5wjxdinkrwblonh7cxfvp0.png\"><\/p>\n<p>  <\/p>\n<p><a href=\"https:\/\/vector.dev\/\" rel=\"nofollow\">Vector<\/a>, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0441\u0431\u043e\u0440\u0430, \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u043b\u043e\u0433\u043e\u0432, \u043c\u0435\u0442\u0440\u0438\u043a \u0438 \u0441\u043e\u0431\u044b\u0442\u0438\u0439.<\/p>\n<p>  <\/p>\n<p>\u2192\u00a0<a href=\"https:\/\/github.com\/timberio\/vector\" rel=\"nofollow\">Github<\/a><\/p>\n<p>  <\/p>\n<p>\u0411\u0443\u0434\u0443\u0447\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0439 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Rust, \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u0432\u044b\u0441\u043e\u043a\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u0438 \u043d\u0438\u0437\u043a\u0438\u043c \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u0435\u043c \u043e\u043f\u0435\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0439 \u043f\u0430\u043c\u044f\u0442\u0438 \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u0430\u043d\u0430\u043b\u043e\u0433\u0430\u043c\u0438. \u041a\u0440\u043e\u043c\u0435 \u0442\u043e\u0433\u043e, \u0431\u043e\u043b\u044c\u0448\u043e\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435 \u0443\u0434\u0435\u043b\u0435\u043d\u043e \u0444\u0443\u043d\u043a\u0446\u0438\u044f\u043c, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u043c \u0441 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e\u0441\u0442\u044c\u044e, \u0432 \u0447\u0430\u0441\u0442\u043d\u043e\u0441\u0442\u0438, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043d\u0435\u043e\u0442\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0445 \u0441\u043e\u0431\u044b\u0442\u0438\u0439 \u0432 \u0431\u0443\u0444\u0435\u0440 \u043d\u0430 \u0434\u0438\u0441\u043a\u0435 \u0438 \u0440\u043e\u0442\u0430\u0446\u0438\u0438 \u0444\u0430\u0439\u043b\u043e\u0432.<\/p>\n<p>  <\/p>\n<p>\u0410\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u043d\u043e Vector \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0440\u043e\u0443\u0442\u0435\u0440\u043e\u043c \u0441\u043e\u0431\u044b\u0442\u0438\u0439, \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u044e\u0449\u0438\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f \u0438\u0437 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 <em>\u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u0432<\/em>, \u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0438\u043c \u043d\u0430\u0434 \u044d\u0442\u0438\u043c\u0438 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f\u043c\u0438 <em>\u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u044f<\/em>, \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u043c \u0438\u0445 \u0432 \u043e\u0434\u0438\u043d \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e <em>\u0441\u0442\u043e\u043a\u043e\u0432<\/em>.<\/p>\n<p>  <\/p>\n<p>Vector \u044d\u0442\u043e \u0437\u0430\u043c\u0435\u043d\u0430 filebeat \u0438 logstash, \u043e\u043d \u043c\u043e\u0436\u0435\u0442 \u0432\u044b\u0441\u0442\u0443\u043f\u0430\u0442\u044c \u0432 \u043e\u0431\u043e\u0438\u0445 \u0440\u043e\u043b\u044f\u0445 (\u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043b\u043e\u0433\u0438), \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0439 \u043d\u0430 \u0438\u0445 <a href=\"https:\/\/vector.dev\" rel=\"nofollow\">\u0441\u0430\u0439\u0442\u0435<\/a>.<\/p>\n<p><a name=\"habracut\"><\/a>  <\/p>\n<p>\u0415\u0441\u043b\u0438 \u0432 Logstash \u0446\u0435\u043f\u043e\u0447\u043a\u0430 \u0441\u0442\u0440\u043e\u0438\u0442\u0441\u044f \u043a\u0430\u043a input \u2192 filter \u2192 output \u0442\u043e \u0432 Vector \u044d\u0442\u043e <a href=\"https:\/\/vector.dev\/docs\/reference\/sources\/\" rel=\"nofollow\">sources<\/a> \u2192 <a href=\"https:\/\/vector.dev\/docs\/reference\/transforms\/\" rel=\"nofollow\">transforms<\/a> \u2192 <a href=\"https:\/\/vector.dev\/docs\/reference\/sinks\/\" rel=\"nofollow\">sinks<\/a> <\/p>\n<p>  <\/p>\n<p>\u041f\u0440\u0438\u043c\u0435\u0440\u044b \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0432 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438.<\/p>\n<p>  <\/p>\n<p>\u042d\u0442\u0430 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f \u043f\u0435\u0440\u0435\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u043d\u0430\u044f \u0438\u043d\u0441\u0442\u0443\u043a\u0446\u0438\u044f \u043e\u0442 <a href=\"https:\/\/git.sys.im\/oss\/configs\/nginx-vector-logs\" rel=\"nofollow\">\u0412\u044f\u0447\u0435\u0441\u043b\u0430\u0432\u0430 \u0420\u0430\u0445\u0438\u043d\u0441\u043a\u043e\u0433\u043e<\/a>. \u0412 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b\u044c\u043d\u043e\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u0435\u0441\u0442\u044c \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 geoip. \u0423 \u043c\u0435\u043d\u044f \u043f\u0440\u0438 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438 geoip \u0438\u0437 \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0435\u0439 \u0441\u0435\u0442\u0438, vector \u0432\u044b\u0434\u0430\u0432\u0430\u043b \u043e\u0448\u0438\u0431\u043a\u0443.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">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=\u00abgeoip.country_name\u00bb rate_limit_secs=30<\/code><\/pre>\n<p>  <\/p>\n<p>\u0415\u0441\u043b\u0438 \u043a\u043e\u043c\u0443-\u0442\u043e \u043d\u0443\u0436\u043d\u043e \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0442\u044c geoip, \u0442\u043e \u043e\u0431\u0440\u0430\u0442\u0438\u0442\u0435\u0441\u044c \u043a\u043e \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b\u044c\u043d\u043e\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 \u043e\u0442 <a href=\"https:\/\/git.sys.im\/oss\/configs\/nginx-vector-logs\" rel=\"nofollow\">\u0412\u044f\u0447\u0435\u0441\u043b\u0430\u0432\u0430 \u0420\u0430\u0445\u0438\u043d\u0441\u043a\u043e\u0433\u043e<\/a>.<\/p>\n<p>  <\/p>\n<p>\u0411\u0443\u0434\u0435\u043c \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0442\u044c \u0441\u0432\u044f\u0437\u043a\u0443 Nginx (Access logs) \u2192 Vector (Client | Filebeat) \u2192 Vector (Server | Logstash) \u2192 Clickhouse. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c 3 \u0441\u0435\u0440\u0432\u0435\u0440\u0430. \u0425\u043e\u0442\u044f \u043c\u043e\u0436\u043d\u043e \u043e\u0431\u043e\u0439\u0442\u0438 2 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c\u0438.<\/p>\n<p>  <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/i8\/dl\/ke\/i8dlkexrhct0242f28d0jsxjace.png\"><\/p>\n<p>  <\/p>\n<p>\u0421\u0445\u0435\u043c\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0442\u0430\u043a\u0430\u044f.<\/p>\n<p>  <\/p>\n<h3 id=\"vyklyuchaem-selinux-na-vseh-vashih-serverah\">\u0412\u044b\u043a\u043b\u044e\u0447\u0430\u0435\u043c Selinux \u043d\u0430 \u0432\u0441\u0435\u0445 \u0432\u0430\u0448\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445<\/h3>\n<p>  <\/p>\n<pre><code class=\"plaintext\">sed -i 's\/^SELINUX=.*\/SELINUX=disabled\/g' \/etc\/selinux\/config reboot<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"na-vse-servera-ustanavlivaem-emulyator-http-servera--utility\">\u041d\u0430 \u0432\u0441\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u044d\u043c\u0443\u043b\u044f\u0442\u043e\u0440 HTTP \u0441\u0435\u0440\u0432\u0435\u0440\u0430 + \u0443\u0442\u0438\u043b\u0438\u0442\u044b<\/h3>\n<p>  <\/p>\n<p>\u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u044d\u043c\u0443\u043b\u044f\u0442\u043e\u0440\u0430 HTTP \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0431\u0443\u0434\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <a href=\"https:\/\/github.com\/maxiko\/nodejs-stub-server\" rel=\"nofollow\">nodejs-stub-server<\/a> \u043e\u0442 <a href=\"https:\/\/habr.com\/users\/Anthrax_Beta\/\">Maxim Ignatenko<\/a><\/p>\n<p>  <\/p>\n<p>Nodejs-stub-server \u043d\u0435 \u0438\u043c\u0435\u0435\u0442 rpm. <a href=\"https:\/\/github.com\/patsevanton\/nodejs-stub-server\" rel=\"nofollow\">\u0417\u0434\u0435\u0441\u044c<\/a> \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0435\u043c\u0443 rpm. \u0421\u043e\u0431\u0438\u0440\u0430\u0442\u044c\u0441\u044f rpm \u0431\u0443\u0434\u0435\u0442 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e <a href=\"https:\/\/copr.fedorainfracloud.org\/coprs\/antonpatsev\/nodejs-stub-server\/\" rel=\"nofollow\">Fedora Copr<\/a><\/p>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0439 antonpatsev\/nodejs-stub-server<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum -y install yum-plugin-copr epel-release yes | yum copr enable antonpatsev\/nodejs-stub-server<\/code><\/pre>\n<p>  <\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c nodejs-stub-server, Apache benchmark \u0438 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b\u044c\u043d\u044b\u0439 \u043c\u0443\u043b\u044c\u0442\u0438\u043f\u043b\u0435\u043a\u0441\u043e\u0440 screen \u043d\u0430 \u0432\u0441\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum -y install stub_http_server screen mc httpd-tools screen<\/code><\/pre>\n<p>  <\/p>\n<p>\u041f\u043e\u043f\u0440\u0430\u0432\u0438\u043b \u0432 \u0444\u0430\u0439\u043b\u0435 \/var\/lib\/stub_http_server\/stub_http_server.js \u0432\u0440\u0435\u043c\u044f \u043e\u0442\u0432\u0435\u0442\u0430 stub_http_server \u0447\u0442\u043e\u0431\u044b \u0431\u044b\u043b\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043b\u043e\u0433\u043e\u0432.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">var max_sleep = 10;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0417\u0430\u043f\u0443\u0441\u0442\u0438\u043c stub_http_server.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">systemctl start stub_http_server systemctl enable stub_http_server<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"ustanovka-clickhousehttpsclickhousetechdocsrugetting-startedinstall-na-3-servere\"><a href=\"https:\/\/clickhouse.tech\/docs\/ru\/getting-started\/install\/\" rel=\"nofollow\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 Clickhouse<\/a> \u043d\u0430 3 \u0441\u0435\u0440\u0432\u0435\u0440\u0435<\/h3>\n<p>  <\/p>\n<p>ClickHouse \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u043d\u0430\u0431\u043e\u0440 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0439 SSE 4.2, \u043f\u043e\u044d\u0442\u043e\u043c\u0443, \u0435\u0441\u043b\u0438 \u043d\u0435 \u0443\u043a\u0430\u0437\u0430\u043d\u043e \u0438\u043d\u043e\u0435, \u0435\u0433\u043e \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u043c \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u0440\u0435, \u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043a \u0441\u0438\u0441\u0442\u0435\u043c\u0435. \u0412\u043e\u0442 \u043a\u043e\u043c\u0430\u043d\u0434\u0430, \u0447\u0442\u043e\u0431\u044b \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043b\u0438 \u0442\u0435\u043a\u0443\u0449\u0438\u0439 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u0440 SSE 4.2:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">grep -q sse4_2 \/proc\/cpuinfo &amp;&amp; echo &quot;SSE 4.2 supported&quot; || echo &quot;SSE 4.2 not supported&quot;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0443\u0436\u043d\u043e \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0439:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">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<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043b\u044f \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u043f\u0430\u043a\u0435\u0442\u043e\u0432 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u044b:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">sudo yum install -y clickhouse-server clickhouse-client<\/code><\/pre>\n<p>  <\/p>\n<p>\u0420\u0430\u0437\u0440\u0435\u0448\u0430\u0435\u043c clickhouse-server \u0441\u043b\u0443\u0448\u0430\u0442\u044c \u0441\u0435\u0442\u0435\u0432\u0443\u044e \u043a\u0430\u0440\u0442\u0443 \u0432 \u0444\u0430\u0439\u043b\u0435 \/etc\/clickhouse-server\/config.xml<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">&lt;listen_host&gt;0.0.0.0&lt;\/listen_host&gt;<\/code><\/pre>\n<p>  <\/p>\n<p>\u041c\u0435\u043d\u044f\u0435\u043c \u0443\u0440\u043e\u0432\u0435\u043d\u044c \u043b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f c trace \u0434\u043e debug<\/p>\n<p>  debug  <\/p>\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0441\u0436\u0430\u0442\u0438\u044f \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">min_compress_block_size  65536 max_compress_block_size  1048576<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043b\u044f \u0430\u043a\u0442\u0438\u0432\u0430\u0446\u0438\u0438 Zstd \u0441\u0436\u0434\u0430\u0442\u0438\u044f \u043a\u043e\u043d\u0444\u0438\u0433 \u043f\u043e\u0441\u043e\u0432\u0435\u0442\u043e\u0432\u0430\u043b\u0438 \u043d\u0435 \u0442\u0440\u043e\u0433\u0430\u0442\u044c, \u0430 \u043b\u0443\u0447\u0448\u0435 \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0442\u044c DDL.<\/p>\n<p>  <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/1w\/fq\/e6\/1wfqe6qgu-yqcepvpxjfsplco7u.png\"><\/p>\n<p>  <\/p>\n<p>\u041a\u0430\u043a \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u0442\u044c zstd \u0441\u0436\u0430\u0442\u0438\u0435 \u0447\u0435\u0440\u0435\u0437 DDL \u0432 \u0433\u0443\u0433\u043b\u0435 \u044f \u043d\u0435 \u043d\u0430\u0448\u0435\u043b. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u043e\u0441\u0442\u0430\u0432\u0438\u043b \u043a\u0430\u043a \u0435\u0441\u0442\u044c.<\/p>\n<p>  <\/p>\n<p>\u041a\u043e\u043b\u043b\u0435\u0433\u0438, \u043a\u0442\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0435\u0442 zstd \u0441\u0436\u0430\u0442\u0438\u0435 \u0432 Clickhouse \u2014 \u043f\u043e\u0434\u0435\u043b\u0438\u0442\u044c, \u043f\u043e\u0436\u0430\u043b\u0443\u0439\u0441\u0442\u0430, \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f\u043c\u0438.<\/p>\n<p>  <\/p>\n<p>\u0414\u043b\u044f \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0434\u0435\u043c\u043e\u043d\u0430, \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">service clickhouse-server start<\/code><\/pre>\n<p>  <\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u043f\u0435\u0440\u0435\u0439\u0434\u0435\u043c \u043a \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 Clickhouse <\/p>\n<p>  <\/p>\n<p>\u0417\u0430\u0445\u043e\u0434\u0438\u043c \u0432 Clickhouse<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">clickhouse-client -h 172.26.10.109 -m<\/code><\/pre>\n<p>  <\/p>\n<p>172.26.10.109 \u2014 IP \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0433\u0434\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d Clickhouse.<\/p>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0411\u0414 vector<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">CREATE DATABASE vector;<\/code><\/pre>\n<p>  <\/p>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c \u0447\u0442\u043e \u0431\u0434 \u0435\u0441\u0442\u044c.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">show databases;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 vector.logs.<\/p>\n<p>  <\/p>\n<pre><code class=\"sql\">\/* \u042d\u0442\u043e \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0433\u0434\u0435 \u0445\u0440\u0430\u043d\u044f\u0442\u0441\u044f \u043b\u043e\u0433\u0438 \u043a\u0430\u043a \u0435\u0441\u0442\u044c *\/  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;<\/code><\/pre>\n<p>  <\/p>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0447\u0442\u043e \u0441\u043e\u0437\u0434\u0430\u043b\u0438\u0441\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u044b. \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c <code>clickhouse-client<\/code> \u0438 \u0434\u0435\u043b\u0430\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441.<\/p>\n<p>  <\/p>\n<p>\u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u0432 \u0431\u0434 vector.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">use vector;  Ok.  0 rows in set. Elapsed: 0.001 sec.<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u043c\u043e\u0442\u0440\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u044b.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">show tables;  \u250c\u2500name\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510 \u2502 logs                \u2502 \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"ustanovka-elasticsearch-na-4-om-servere-dlya-otpravki-teh-zhe-dannyh-v-elasticsearch-dlya-sravneniya-s-clickhouse\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 elasticsearch \u043d\u0430 4-\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0434\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0442\u0435\u0445 \u0436\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Elasticsearch \u0434\u043b\u044f \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044f \u0441 Clickhouse<\/h3>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u0438\u043c \u043f\u0443\u0431\u043b\u0438\u0447\u043d\u044b\u0439 rpm \u043a\u043b\u044e\u0447<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">rpm --import https:\/\/artifacts.elastic.co\/GPG-KEY-elasticsearch<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c 2 \u0440\u0435\u043f\u043e:<\/p>\n<p>  <\/p>\n<p>\/etc\/yum.repos.d\/elasticsearch.repo<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">[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<\/code><\/pre>\n<p>  <\/p>\n<p>\/etc\/yum.repos.d\/kibana.repo<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">[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<\/code><\/pre>\n<p>  <\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c elasticsearch \u0438 kibana<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum install -y kibana elasticsearch<\/code><\/pre>\n<p>  <\/p>\n<p>\u0422\u0430\u043a \u043a\u0430\u043a \u0431\u0443\u0434\u0435\u0442 \u0432 1 \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u0435, \u0442\u043e \u0432 \u0444\u0430\u0439\u043b \/etc\/elasticsearch\/elasticsearch.yml \u043d\u0443\u0436\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">discovery.type: single-node<\/code><\/pre>\n<p>  <\/p>\n<p>\u0427\u0442\u043e\u0431\u044b vector \u0441\u043c\u043e\u0433 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 elasticsearch \u0441 \u0434\u0440\u0443\u0433\u043e\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0438\u0437\u043c\u0435\u043d\u0438\u043c network.host.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">network.host: 0.0.0.0<\/code><\/pre>\n<p>  <\/p>\n<p>\u0427\u0442\u043e\u0431\u044b \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0438\u0442\u0441\u044f \u043a kibana \u0438\u0437\u043c\u0435\u043d\u0438\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 server.host \u0432 \u0444\u0430\u0439\u043b \/etc\/kibana\/kibana.yml<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">server.host: &quot;0.0.0.0&quot;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u0442\u0430\u0440\u0443\u0435\u043c \u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u0432 \u0430\u0432\u0442\u043e\u0437\u0430\u043f\u0443\u0441\u043a elasticsearch<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">systemctl enable elasticsearch systemctl start elasticsearch<\/code><\/pre>\n<p>  <\/p>\n<p>\u0438 kibana<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">systemctl enable kibana systemctl start kibana<\/code><\/pre>\n<p>  <\/p>\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 Elasticsearch \u0434\u043b\u044f single-node \u0440\u0435\u0436\u0438\u043c\u0430 1 shard, 0 replica. \u0421\u043a\u043e\u0440\u0435\u0435 \u0432\u0441\u0435\u0433\u043e \u0443 \u0432\u0430 \u0431\u0443\u0434\u0435\u0442 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u0438\u0437 \u0431\u043e\u043b\u044c\u0448\u043e\u0433\u043e \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u0438 \u0432\u0430\u043c \u044d\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u043d\u0435 \u043d\u0443\u0436\u043d\u043e.<\/p>\n<p>  <\/p>\n<p>\u0414\u043b\u044f \u0431\u0443\u0434\u0443\u0449\u0438\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0448\u0430\u0431\u043b\u043e\u043d \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">curl -X PUT http:\/\/localhost:9200\/_template\/default -H 'Content-Type: application\/json' -d '{&quot;index_patterns&quot;: [&quot;*&quot;],&quot;order&quot;: -1,&quot;settings&quot;: {&quot;number_of_shards&quot;: &quot;1&quot;,&quot;number_of_replicas&quot;: &quot;0&quot;}}' <\/code><\/pre>\n<p>  <\/p>\n<h4 id=\"ustanovka-vectorhttpsvectordevdocssetupinstallation-kak-zamenu-logstash-na-2-servere\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 <a href=\"https:\/\/vector.dev\/docs\/setup\/installation\/\" rel=\"nofollow\">Vector<\/a> \u043a\u0430\u043a \u0437\u0430\u043c\u0435\u043d\u0443 Logstash \u043d\u0430 2 \u0441\u0435\u0440\u0432\u0435\u0440\u0435<\/h4>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum install -y https:\/\/packages.timber.io\/vector\/0.9.X\/vector-x86_64.rpm mc httpd-tools screen<\/code><\/pre>\n<p>  <\/p>\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0438\u043c Vector \u043a\u0430\u043a \u0437\u0430\u043c\u0435\u043d\u0443 Logstash. \u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u0443\u0435\u043c \u0444\u0430\u0439\u043b \/etc\/vector\/vector.toml<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\"># \/etc\/vector\/vector.toml  data_dir = &quot;\/var\/lib\/vector&quot;  [sources.nginx_input_vector]   # General   type                          = &quot;vector&quot;   address                       = &quot;0.0.0.0:9876&quot;   shutdown_timeout_secs         = 30  [transforms.nginx_parse_json]   inputs                        = [ &quot;nginx_input_vector&quot; ]   type                          = &quot;json_parser&quot;  [transforms.nginx_parse_add_defaults]   inputs                        = [ &quot;nginx_parse_json&quot; ]   type                          = &quot;lua&quot;   version                       = &quot;2&quot;    hooks.process = &quot;&quot;&quot;   function (event, emit)      function split_first(s, delimiter)       result = {};       for match in (s..delimiter):gmatch(&quot;(.-)&quot;..delimiter) do           table.insert(result, match);       end       return result[1];     end      function split_last(s, delimiter)       result = {};       for match in (s..delimiter):gmatch(&quot;(.-)&quot;..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 == &quot;&quot; then         event.log.upstream_addr = &quot;127.0.0.1&quot;     end      if (event.log.upstream_bytes_received == &quot;-&quot; or event.log.upstream_bytes_received == &quot;&quot;) then         event.log.upstream_bytes_received = &quot;0&quot;     end      if (event.log.upstream_bytes_sent == &quot;-&quot; or event.log.upstream_bytes_sent == &quot;&quot;) then         event.log.upstream_bytes_sent = &quot;0&quot;     end      if event.log.upstream_cache_status == &quot;&quot; then         event.log.upstream_cache_status = &quot;DISABLED&quot;     end      if (event.log.upstream_connect_time == &quot;-&quot; or event.log.upstream_connect_time == &quot;&quot;) then         event.log.upstream_connect_time = &quot;0&quot;     end      if (event.log.upstream_header_time == &quot;-&quot; or event.log.upstream_header_time == &quot;&quot;) then         event.log.upstream_header_time = &quot;0&quot;     end      if (event.log.upstream_response_length == &quot;-&quot; or event.log.upstream_response_length == &quot;&quot;) then         event.log.upstream_response_length = &quot;0&quot;     end      if (event.log.upstream_response_time == &quot;-&quot; or event.log.upstream_response_time == &quot;&quot;) then         event.log.upstream_response_time = &quot;0&quot;     end      if (event.log.upstream_status == &quot;-&quot; or event.log.upstream_status == &quot;&quot;) then         event.log.upstream_status = &quot;0&quot;     end      emit(event)    end   &quot;&quot;&quot;  [transforms.nginx_parse_remove_fields]     inputs                              = [ &quot;nginx_parse_add_defaults&quot; ]     type                                = &quot;remove_fields&quot;     fields                              = [&quot;data&quot;, &quot;file&quot;, &quot;host&quot;, &quot;source_type&quot;]  [transforms.nginx_parse_coercer]      type                                = &quot;coercer&quot;     inputs                              = [&quot;nginx_parse_remove_fields&quot;]      types.request_length = &quot;int&quot;     types.request_time = &quot;float&quot;      types.response_status = &quot;int&quot;     types.response_body_bytes_sent = &quot;int&quot;      types.remote_port = &quot;int&quot;      types.upstream_bytes_received = &quot;int&quot;     types.upstream_bytes_send = &quot;int&quot;     types.upstream_connect_time = &quot;float&quot;     types.upstream_header_time = &quot;float&quot;     types.upstream_response_length = &quot;int&quot;     types.upstream_response_time = &quot;float&quot;     types.upstream_status = &quot;int&quot;      types.timestamp = &quot;timestamp&quot;  [sinks.nginx_output_clickhouse]     inputs   = [&quot;nginx_parse_coercer&quot;]     type     = &quot;clickhouse&quot;      database = &quot;vector&quot;     healthcheck = true     host = &quot;http:\/\/172.26.10.109:8123&quot; #  \u0410\u0434\u0440\u0435\u0441 Clickhouse     table = &quot;logs&quot;      encoding.timestamp_format = &quot;unix&quot;      buffer.type = &quot;disk&quot;     buffer.max_size = 104900000     buffer.when_full = &quot;block&quot;      request.in_flight_limit = 20  [sinks.elasticsearch]     type = &quot;elasticsearch&quot;     inputs   = [&quot;nginx_parse_coercer&quot;]     compression = &quot;none&quot;     healthcheck = true     # 172.26.10.116 - \u0441\u0435\u0440\u0432\u0435\u0440 \u0433\u0434\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0435\u043d elasticsearch     host = &quot;http:\/\/172.26.10.116:9200&quot;      index = &quot;vector-%Y-%m-%d&quot;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0412\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043e\u0442\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0435\u043a\u0446\u0438\u044e transforms.nginx_parse_add_defaults.<\/p>\n<p>  <\/p>\n<p>\u0422\u0430\u043a \u043a\u0430\u043a <a href=\"https:\/\/git.sys.im\/oss\/configs\/nginx-vector-logs\" rel=\"nofollow\">\u0412\u044f\u0447\u0435\u0441\u043b\u0430\u0432 \u0420\u0430\u0445\u0438\u043d\u0441\u043a\u0438\u0439<\/a> \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u043a\u043e\u043d\u0444\u0438\u0433\u0438 \u0434\u043b\u044f \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u043e\u0433\u043e CDN \u0438 \u0442\u0430\u043c \u0432 upstream_* \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u043b\u0435\u0442\u0430\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 <\/p>\n<p>  <\/p>\n<p>\u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">&quot;upstream_addr&quot;: &quot;128.66.0.10:443, 128.66.0.11:443, 128.66.0.12:443&quot; &quot;upstream_bytes_received&quot;: &quot;-, -, 123&quot; &quot;upstream_status&quot;: &quot;502, 502, 200&quot;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0415\u0441\u043b\u0438 \u044d\u0442\u043e \u043d\u0435 \u0432\u0430\u0448\u0430 \u0441\u0438\u0442\u0443\u0430\u0446\u0438\u044f \u0442\u043e \u044d\u0442\u0443 \u0441\u0435\u043a\u0446\u0438\u044e \u043c\u043e\u0436\u043d\u043e \u0443\u043f\u0440\u043e\u0441\u0442\u0438\u0442\u044c <\/p>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 service \u0434\u043b\u044f systemd \/etc\/systemd\/system\/vector.service<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\"># \/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<\/code><\/pre>\n<p>  <\/p>\n<p>\u041f\u043e\u0441\u043b\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u043c\u043e\u0436\u043d\u043e \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0442\u044c Vector<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">systemctl enable vector systemctl start vector<\/code><\/pre>\n<p>  <\/p>\n<p>\u041b\u043e\u0433\u0438 vector \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0442\u0430\u043a<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">journalctl -f -u vector<\/code><\/pre>\n<p>  <\/p>\n<p>\u0412 \u043b\u043e\u0433\u0430\u0445 \u0434\u043e\u043b\u0436\u043d\u044b \u0431\u044b\u0442\u044c \u0442\u0430\u043a\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">INFO vector::topology::builder: Healthcheck: Passed. INFO vector::topology::builder: Healthcheck: Passed.<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"na-kliente-web-server---1-y-server\">\u041d\u0430 \u043a\u043b\u0438\u0435\u043d\u0442\u0435 (Web server) \u2014 1-\u0439 \u0441\u0435\u0440\u0432\u0435\u0440<\/h3>\n<p>  <\/p>\n<p>\u041d\u0430 c\u0435\u0440\u0432\u0435\u0440\u0435 \u0441 nginx \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0432\u044b\u043a\u043b\u044e\u0447\u0438\u0442\u044c ipv6, \u0442\u0430\u043a \u043a\u0430\u043a \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 logs \u0432 clickhouse \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u043b\u0435 <code>upstream_addr<\/code> IPv4, \u0442\u0430\u043a \u043a\u0430\u043a \u044f \u043d\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e ipv6 \u0432\u043d\u0443\u0442\u0440\u0438 \u0441\u0435\u0442\u0438. \u0415\u0441\u043b\u0438 ipv6 \u043d\u0435 \u0432\u044b\u043a\u043b\u044e\u0447\u0438\u0442\u044c, \u0442\u043e \u0431\u0443\u0434\u0443\u0442 \u043e\u0448\u0438\u0431\u043a\u0438:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">DB::Exception: Invalid IPv4 value.: (while read the value of key upstream_addr)<\/code><\/pre>\n<p>  <\/p>\n<p>\u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u0447\u0438\u0442\u0430\u0442\u0435\u043b\u0438, \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 ipv6.<\/p>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b \/etc\/sysctl.d\/98-disable-ipv6.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">net.ipv6.conf.all.disable_ipv6 = 1 net.ipv6.conf.default.disable_ipv6 = 1 net.ipv6.conf.lo.disable_ipv6 = 1<\/code><\/pre>\n<p>  <\/p>\n<p>\u041f\u0440\u0438\u043c\u0435\u043d\u044f\u0435\u043c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">sysctl --system<\/code><\/pre>\n<p>  <\/p>\n<h4 id=\"ustanovim-nginx\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c nginx.<\/h4>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u0438\u043b \u0444\u0430\u0439\u043b \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u044f nginx \/etc\/yum.repos.d\/nginx.repo<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">[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<\/code><\/pre>\n<p>  <\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c \u043f\u0430\u043a\u0435\u0442 nginx<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum install -y nginx<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043b\u044f \u043d\u0430\u0447\u0430\u043b\u0430 \u043d\u0430\u043c \u043d\u0430\u0434\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c \u0444\u043e\u0440\u043c\u0430\u0442 \u043b\u043e\u0433\u043e\u0432 \u0432 Nginx \u0432 \u0444\u0430\u0439\u043b\u0435 \/etc\/nginx\/nginx.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">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] &quot;$request&quot; '                       '$status $body_bytes_sent &quot;$http_referer&quot; '                       '&quot;$http_user_agent&quot; &quot;$http_x_forwarded_for&quot;';  log_format vector escape=json     '{'         '&quot;node_name&quot;:&quot;nginx-vector&quot;,'         '&quot;timestamp&quot;:&quot;$time_iso8601&quot;,'         '&quot;server_name&quot;:&quot;$server_name&quot;,'         '&quot;request_full&quot;: &quot;$request&quot;,'         '&quot;request_user_agent&quot;:&quot;$http_user_agent&quot;,'         '&quot;request_http_host&quot;:&quot;$http_host&quot;,'         '&quot;request_uri&quot;:&quot;$request_uri&quot;,'         '&quot;request_scheme&quot;: &quot;$scheme&quot;,'         '&quot;request_method&quot;:&quot;$request_method&quot;,'         '&quot;request_length&quot;:&quot;$request_length&quot;,'         '&quot;request_time&quot;: &quot;$request_time&quot;,'         '&quot;request_referrer&quot;:&quot;$http_referer&quot;,'         '&quot;response_status&quot;: &quot;$status&quot;,'         '&quot;response_body_bytes_sent&quot;:&quot;$body_bytes_sent&quot;,'         '&quot;response_content_type&quot;:&quot;$sent_http_content_type&quot;,'         '&quot;remote_addr&quot;: &quot;$remote_addr&quot;,'         '&quot;remote_port&quot;: &quot;$remote_port&quot;,'         '&quot;remote_user&quot;: &quot;$remote_user&quot;,'         '&quot;upstream_addr&quot;: &quot;$upstream_addr&quot;,'         '&quot;upstream_bytes_received&quot;: &quot;$upstream_bytes_received&quot;,'         '&quot;upstream_bytes_sent&quot;: &quot;$upstream_bytes_sent&quot;,'         '&quot;upstream_cache_status&quot;:&quot;$upstream_cache_status&quot;,'         '&quot;upstream_connect_time&quot;:&quot;$upstream_connect_time&quot;,'         '&quot;upstream_header_time&quot;:&quot;$upstream_header_time&quot;,'         '&quot;upstream_response_length&quot;:&quot;$upstream_response_length&quot;,'         '&quot;upstream_response_time&quot;:&quot;$upstream_response_time&quot;,'         '&quot;upstream_status&quot;: &quot;$upstream_status&quot;,'         '&quot;upstream_content_type&quot;:&quot;$upstream_http_content_type&quot;'     '}';      access_log  \/var\/log\/nginx\/access.log  main;     access_log  \/var\/log\/nginx\/access.json.log vector;      # \u041d\u043e\u0432\u044b\u0439 \u043b\u043e\u0433 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 json      sendfile        on;     #tcp_nopush     on;      keepalive_timeout  65;      #gzip  on;      include \/etc\/nginx\/conf.d\/*.conf; }<\/code><\/pre>\n<p>  <\/p>\n<p>\u0427\u0442\u043e \u0431\u044b \u043d\u0435 \u043f\u043e\u043b\u043e\u043c\u0430\u0442\u044c \u0432\u0430\u0448\u0443 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438\u044e, Nginx \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0438\u043c\u0435\u0442\u044c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0434\u0438\u0440\u0435\u043a\u0442\u0438\u0432 access_log<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">access_log  \/var\/log\/nginx\/access.log  main;            # \u0421\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0439 \u043b\u043e\u0433 access_log  \/var\/log\/nginx\/access.json.log vector;      # \u041d\u043e\u0432\u044b\u0439 \u043b\u043e\u0433 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 json<\/code><\/pre>\n<p>  <\/p>\n<p>\u041d\u0435 \u0437\u0430\u0431\u0443\u0434\u0442\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u043f\u0440\u0430\u0432\u0438\u043b\u043e \u0432 logrotate \u0434\u043b\u044f \u043d\u043e\u0432\u044b\u0445 \u043b\u043e\u0433\u043e\u0432 (\u0435\u0441\u043b\u0438 log \u0444\u0430\u0438\u043b \u043d\u0435 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043d\u0430 .log)<\/p>\n<p>  <\/p>\n<p>\u0423\u0434\u0430\u043b\u044f\u0435\u043c default.conf \u0438\u0437 \/etc\/nginx\/conf.d\/<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">rm -f \/etc\/nginx\/conf.d\/default.conf<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0445\u043e\u0441\u0442 \/etc\/nginx\/conf.d\/vhost1.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">server {     listen 80;     server_name vhost1;     location \/ {         proxy_pass http:\/\/172.26.10.106:8080;     } }<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0445\u043e\u0441\u0442 \/etc\/nginx\/conf.d\/vhost2.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">server {     listen 80;     server_name vhost2;     location \/ {         proxy_pass http:\/\/172.26.10.108:8080;     } }<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0445\u043e\u0441\u0442 \/etc\/nginx\/conf.d\/vhost3.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">server {     listen 80;     server_name vhost3;     location \/ {         proxy_pass http:\/\/172.26.10.109:8080;     } }<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0445\u043e\u0441\u0442 \/etc\/nginx\/conf.d\/vhost4.conf<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">server {     listen 80;     server_name vhost4;     location \/ {         proxy_pass http:\/\/172.26.10.116:8080;     } }<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432 \u0444\u0430\u0439\u043b \/etc\/hosts \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0435 \u0445\u043e\u0441\u0442\u044b (172.26.10.106 ip \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0433\u0434\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d nginx) \u043d\u0430 \u0432\u0441\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430:<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">172.26.10.106 vhost1 172.26.10.106 vhost2 172.26.10.106 vhost3 172.26.10.106 vhost4<\/code><\/pre>\n<p>  <\/p>\n<p>\u0418 \u0435\u0441\u043b\u0438 \u0432\u0441\u0435 \u0433\u043e\u0442\u043e\u0432\u043e \u0442\u043e <\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">nginx -t  systemctl restart nginx<\/code><\/pre>\n<p>  <\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c \u0441\u0430\u043c <a href=\"https:\/\/vector.dev\/docs\/setup\/installation\/\" rel=\"nofollow\">Vector<\/a><\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">yum install -y https:\/\/packages.timber.io\/vector\/0.9.X\/vector-x86_64.rpm<\/code><\/pre>\n<p>  <\/p>\n<p>\u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0444\u0430\u0438\u043b \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u0434\u043b\u044f systemd \/etc\/systemd\/system\/vector.service<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">[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<\/code><\/pre>\n<p>  <\/p>\n<p>\u0418 \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u043c \u0437\u0430\u043c\u0435\u043d\u0443 Filebeat \u0432 \u043a\u043e\u043d\u0444\u0438\u0433\u0435 \/etc\/vector\/vector.toml. IP \u0430\u0434\u0440\u0435\u0441 172.26.10.108 \u2014 \u044d\u0442\u043e IP \u0430\u0434\u0440\u0435\u0441 log \u0441\u0435\u0440\u0432\u0435\u0440\u0430 (Vector-Server)<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">data_dir = &quot;\/var\/lib\/vector&quot;  [sources.nginx_file]   type                          = &quot;file&quot;   include                       = [ &quot;\/var\/log\/nginx\/access.json.log&quot; ]   start_at_beginning            = false   fingerprinting.strategy       = &quot;device_and_inode&quot;  [sinks.nginx_output_vector]   type                          = &quot;vector&quot;   inputs                        = [ &quot;nginx_file&quot; ]    address                       = &quot;172.26.10.108:9876&quot;<\/code><\/pre>\n<p>  <\/p>\n<p>\u041d\u0435 \u0437\u0430\u0431\u0443\u0434\u0442\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u044e\u0437\u0435\u0440\u0430 vector \u0432 \u043d\u0443\u0436\u043d\u0443\u044e \u0433\u0440\u0443\u043f\u043f\u0443 \u0447\u0442\u043e \u0431\u044b \u043e\u043d \u043c\u043e\u0433 \u0447\u0438\u0442\u0430\u0442\u044c log \u0444\u0430\u0439\u043b\u044b. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, nginx \u0432 centos \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u043b\u043e\u0433\u0438 \u0441 \u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u0433\u0440\u0443\u043f\u043f\u044b adm.<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">usermod -a -G adm vector<\/code><\/pre>\n<p>  <\/p>\n<p>\u0417\u0430\u043f\u0443\u0441\u0442\u0438\u043c \u0441\u0435\u0440\u0432\u0438\u0441 vector<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">systemctl enable vector systemctl start vector<\/code><\/pre>\n<p>  <\/p>\n<p>\u041b\u043e\u0433\u0438 vector \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0442\u0430\u043a<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">journalctl -f -u vector<\/code><\/pre>\n<p>  <\/p>\n<p>\u0412 \u043b\u043e\u0433\u0430\u0445 \u0434\u043e\u043b\u0436\u043d\u0430 \u0431\u044b\u0442\u044c \u0442\u0430\u043a\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">INFO vector::topology::builder: Healthcheck: Passed.<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"nagruzochnoe-testirovanie\">\u041d\u0430\u0433\u0440\u0443\u0437\u043e\u0447\u043d\u043e\u0435 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435<\/h3>\n<p>  <\/p>\n<p>\u0422\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0432\u043e\u0434\u0438\u043c \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Apache benchmark.<\/p>\n<p>  <\/p>\n<p>\u041d\u0430 \u0432\u0441\u0435 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0431\u044b\u043b \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d \u043f\u0430\u043a\u0435\u0442 httpd-tools<\/p>\n<p>  <\/p>\n<p>\u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Apache benchmark c 4 \u0440\u0430\u0437\u043d\u044b\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u0432 screen. \u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b\u044c\u043d\u044b\u0439 \u043c\u0443\u043b\u044c\u0442\u0438\u043f\u043b\u0435\u043a\u0441\u043e\u0440 screen, \u0430 \u0437\u0430\u0442\u0435\u043c \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Apache benchmark. \u041a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 screen \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0439\u0442\u0438 \u0432 <a href=\"https:\/\/help.ubuntu.ru\/wiki\/screen\" rel=\"nofollow\">\u0441\u0442\u0430\u0442\u044c\u0435<\/a>.<\/p>\n<p>  <\/p>\n<p>C 1-\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">while true; do ab -H &quot;User-Agent: 1server&quot; -c 100 -n 10 -t 10 http:\/\/vhost1\/; sleep 1; done<\/code><\/pre>\n<p>  <\/p>\n<p>C 2-\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">while true; do ab -H &quot;User-Agent: 2server&quot; -c 100 -n 10 -t 10 http:\/\/vhost2\/; sleep 1; done<\/code><\/pre>\n<p>  <\/p>\n<p>C 3-\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">while true; do ab -H &quot;User-Agent: 3server&quot; -c 100 -n 10 -t 10 http:\/\/vhost3\/; sleep 1; done<\/code><\/pre>\n<p>  <\/p>\n<p>C 4-\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">while true; do ab -H &quot;User-Agent: 4server&quot; -c 100 -n 10 -t 10 http:\/\/vhost4\/; sleep 1; done<\/code><\/pre>\n<p>  <\/p>\n<h3 id=\"proverim-dannye-v-clickhouse\">\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 Clickhouse<\/h3>\n<p>  <\/p>\n<p>\u0417\u0430\u0445\u043e\u0434\u0438\u043c \u0432 Clickhouse<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">clickhouse-client -h 172.26.10.109 -m<\/code><\/pre>\n<p>  <\/p>\n<p>\u0414\u0435\u043b\u0430\u0435\u043c SQL \u0437\u0430\u043f\u0440\u043e\u0441<\/p>\n<p>  <\/p>\n<pre><code class=\"plaintext\">SELECT * FROM vector.logs;  \u250c\u2500node_name\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500timestamp\u2500\u252c\u2500server_name\u2500\u252c\u2500user_id\u2500\u252c\u2500request_full\u2500\u2500\u2500\u252c\u2500request_user_agent\u2500\u252c\u2500request_http_host\u2500\u252c\u2500request_uri\u2500\u252c\u2500request_scheme\u2500\u252c\u2500request_method\u2500\u252c\u2500request_length\u2500\u252c\u2500request_time\u2500\u252c\u2500request_referrer\u2500\u252c\u2500response_status\u2500\u252c\u2500response_body_bytes_sent\u2500\u252c\u2500response_content_type\u2500\u252c\u2500\u2500\u2500remote_addr\u2500\u252c\u2500remote_port\u2500\u252c\u2500remote_user\u2500\u252c\u2500upstream_addr\u2500\u252c\u2500upstream_port\u2500\u252c\u2500upstream_bytes_received\u2500\u252c\u2500upstream_bytes_sent\u2500\u252c\u2500upstream_cache_status\u2500\u252c\u2500upstream_connect_time\u2500\u252c\u2500upstream_header_time\u2500\u252c\u2500upstream_response_length\u2500\u252c\u2500upstream_response_time\u2500\u252c\u2500upstream_status\u2500\u252c\u2500upstream_content_type\u2500\u2510 \u2502 nginx-vector \u2502 2020-08-07 04:32:42 \u2502 vhost1      \u2502         \u2502 GET \/ HTTP\/1.0 \u2502 1server            \u2502 vhost1            \u2502 \/           \u2502 http           \u2502 GET            \u2502             66 \u2502        0.028 \u2502                  \u2502             404 \u2502                       27 \u2502                       \u2502 172.26.10.106 \u2502       45886 \u2502             \u2502 172.26.10.106 \u2502             0 \u2502                     109 \u2502                  97 \u2502 DISABLED              \u2502                     0 \u2502                0.025 \u2502                       27 \u2502                  0.029 \u2502             404 \u2502                       \u2502 \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500<\/code><\/pre>\n<p>  <\/p>\n<p>\u0423\u0437\u043d\u0430\u0435\u043c \u0440\u0430\u0437\u043c\u0435\u0440 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 Clickhouse<\/p>\n<p>  <\/p>\n<pre><code class=\"sql\">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;<\/code><\/pre>\n<p>  <\/p>\n<p>\u0423\u0437\u043d\u0430\u0435\u043c \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432 Clickhouse \u0437\u0430\u043d\u044f\u043b\u0438 \u043b\u043e\u0433\u0438.<\/p>\n<p>  <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/gx\/st\/qj\/gxstqjfh6jhgefaqg2lu0xeifpg.png\"><\/p>\n<p>  <\/p>\n<p>\u0420\u0430\u0437\u043c\u0435\u0440 \u0442\u0430\u0431\u043b\u0438\u0446\u044b logs \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 857.19 \u041c\u0411.<\/p>\n<p>  <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/gr\/it\/_n\/grit_noqwrmxpup7_n9cdm9pylm.png\"><\/p>\n<p>  <\/p>\n<p>\u0420\u0430\u0437\u043c\u0435\u0440 \u0442\u0435\u0445 \u0436\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0438\u043d\u0434\u0435\u043a\u0441\u0435 \u0432 Elasticsearch \u0437\u0430\u043d\u0438\u043c\u0430\u0435 4,5\u0413\u0411.<\/p>\n<p>  <\/p>\n<p>\u0415\u0441\u043b\u0438 \u0432 vector \u0432 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u0445 \u043d\u0435 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0442\u044c \u0432 Clickhouse \u0434\u0430\u043d\u043d\u044b\u0435 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 \u0432 4500\/857.19 = 5.24 \u0440\u0430\u0437\u0430 \u043c\u0435\u043d\u044c\u0448\u0435 \u0447\u0435\u043c \u0432 Elasticsearch.<\/p>\n<p>  <\/p>\n<p>\u0412 vector \u043f\u043e\u043b\u0435 compression \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e.<\/p>\n<p>  <\/p>\n<p>\u0422\u0435\u043b\u0435\u0433\u0440\u0430\u043c-\u0447\u0430\u0442 \u043f\u043e <a href=\"https:\/\/t.me\/clickhouse_ru\" rel=\"nofollow\">Clickhouse<\/a><br \/>  \u0422\u0435\u043b\u0435\u0433\u0440\u0430\u043c-\u0447\u0430\u0442 \u043f\u043e <a href=\"https:\/\/t.me\/elasticsearch_ru\" rel=\"nofollow\">Elasticsearch<\/a><br \/>  \u0422\u0435\u043b\u0435\u0433\u0440\u0430\u043c-\u0447\u0430\u0442 \u043f\u043e &quot;<a href=\"https:\/\/t.me\/ru_logs\" rel=\"nofollow\"><em>\u0421\u0431\u043e\u0440 \u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0445<\/em> \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439<\/a>&quot;<\/p>\n<\/div>\n<p> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"https:\/\/habr.com\/ru\/post\/514480\/\"> https:\/\/habr.com\/ru\/post\/514480\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n<div class=\"post__text post__text-html post__text_v1\" id=\"post-content-body\" data-io-article-url=\"https:\/\/habr.com\/ru\/post\/514480\/\">\n<p><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/webt\/hs\/th\/d5\/hsthd5wjxdinkrwblonh7cxfvp0.png\"><\/p>\n<p>  <\/p>\n<p><a href=\"https:\/\/vector.dev\/\" rel=\"nofollow\">Vector<\/a>, \u043f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u043b\u044f \u0441\u0431\u043e\u0440\u0430, \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u043b\u043e\u0433\u043e\u0432, \u043c\u0435\u0442\u0440\u0438\u043a \u0438 \u0441\u043e\u0431\u044b\u0442\u0438\u0439.<\/p>\n<p>  <\/p>\n<p>\u2192\u00a0<a href=\"https:\/\/github.com\/timberio\/vector\" rel=\"nofollow\">Github<\/a><\/p>\n<p>  <\/p>\n<p>\u0411\u0443\u0434\u0443\u0447\u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0439 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Rust, \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u0432\u044b\u0441\u043e\u043a\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u0438 \u043d\u0438\u0437\u043a\u0438\u043c \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u0435\u043c \u043e\u043f\u0435\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0439 \u043f\u0430\u043c\u044f\u0442\u0438 \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u0430\u043d\u0430\u043b\u043e\u0433\u0430\u043c\u0438. \u041a\u0440\u043e\u043c\u0435 \u0442\u043e\u0433\u043e, \u0431\u043e\u043b\u044c\u0448\u043e\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435 \u0443\u0434\u0435\u043b\u0435\u043d\u043e \u0444\u0443\u043d\u043a\u0446\u0438\u044f\u043c, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u043c \u0441 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u043e\u0441\u0442\u044c\u044e, \u0432 \u0447\u0430\u0441\u0442\u043d\u043e\u0441\u0442\u0438, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043d\u0435\u043e\u0442\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0445 \u0441\u043e\u0431\u044b\u0442\u0438\u0439 \u0432 \u0431\u0443\u0444\u0435\u0440 \u043d\u0430 \u0434\u0438\u0441\u043a\u0435 \u0438 \u0440\u043e\u0442\u0430\u0446\u0438\u0438 \u0444\u0430\u0439\u043b\u043e\u0432.<\/p>\n<p>  <\/p>\n<p>\u0410\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u043d\u043e Vector \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0440\u043e\u0443\u0442\u0435\u0440\u043e\u043c \u0441\u043e\u0431\u044b\u0442\u0438\u0439, \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u044e\u0449\u0438\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f \u0438\u0437 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 <em>\u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u0432<\/em>, \u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0438\u043c \u043d\u0430\u0434 \u044d\u0442\u0438\u043c\u0438 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f\u043c\u0438 <em>\u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u044f<\/em>, \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u043c \u0438\u0445 \u0432 \u043e\u0434\u0438\u043d \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e <em>\u0441\u0442\u043e\u043a\u043e\u0432<\/em>.<\/p>\n<p>  <\/p>\n<p>Vector \u044d\u0442\u043e \u0437\u0430\u043c\u0435\u043d\u0430 filebeat \u0438 logstash, \u043e\u043d \u043c\u043e\u0436\u0435\u0442 \u0432\u044b\u0441\u0442\u0443\u043f\u0430\u0442\u044c \u0432 \u043e\u0431\u043e\u0438\u0445 \u0440\u043e\u043b\u044f\u0445 (\u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043b\u043e\u0433\u0438), \u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0439 \u043d\u0430 \u0438\u0445 <a href=\"https:\/\/vector.dev\" rel=\"nofollow\">\u0441\u0430\u0439\u0442\u0435<\/a>.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-308229","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/308229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=308229"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/308229\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=308229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=308229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=308229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}