{"id":16352,"date":"2024-11-14T01:53:57","date_gmt":"2024-11-13T22:23:57","guid":{"rendered":"https:\/\/www.itpiran.net\/blog\/?p=16352"},"modified":"2024-11-14T01:53:57","modified_gmt":"2024-11-13T22:23:57","slug":"use-digitalocean-spaces-bucket-as-tiered-storage","status":"publish","type":"post","link":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/","title":{"rendered":"ClickHouse&#039;da DigitalOcean Spaces kovas\u0131n\u0131 katmanl\u0131 depolama olarak nas\u0131l kullanabilirim?"},"content":{"rendered":"<h1 id=\"%d9%85%d9%82%d8%af%d9%85%d9%87\">\u0645\u0642\u062f\u0645\u0647<\/h1>\n<p>ClickHouse \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646\u06cc \u0645\u062a\u0646\u200c\u0628\u0627\u0632 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u067e\u0631\u0633\u200c\u0648\u062c\u0648\u0647\u0627\u06cc OLAP \u0628\u0627 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0628\u0627\u0644\u0627 \u0648 \u062a\u062d\u0644\u06cc\u0644\u200c\u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0628\u0631\u062a\u0631\u06cc \u062f\u0627\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0645\u0642\u06cc\u0627\u0633\u200c\u067e\u0630\u06cc\u0631\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc ClickHouse \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0686\u0627\u0644\u0634\u200c\u0628\u0631\u0627\u0646\u06af\u06cc\u0632 \u0628\u0627\u0634\u062f\u060c \u0628\u0647\u200c\u0648\u06cc\u0698\u0647 \u0648\u0642\u062a\u06cc \u06a9\u0647 \u062d\u062c\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0634\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f. \u06cc\u06a9\u06cc \u0627\u0632 \u0631\u0627\u0647\u200c\u062d\u0644\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u060c \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06a9\u0645\u200c\u062f\u0633\u062a\u0631\u0633 \u0631\u0627 \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u0642\u0631\u0648\u0646\u200c\u0628\u0647\u200c\u0635\u0631\u0641\u0647\u200c\u062a\u0631 \u0645\u0646\u062a\u0642\u0644 \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u0639\u06cc\u0646 \u062d\u0627\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0631\u0627 \u0631\u0648\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0633\u0631\u06cc\u0639\u200c\u062a\u0631 \u0648 \u06af\u0631\u0627\u0646\u200c\u062a\u0631 \u0646\u06af\u0647 \u062f\u0627\u0631\u06cc\u062f. ClickHouse \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u0645\u062e\u062a\u0644\u0641\u06cc \u0627\u0632 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u062f\u06cc\u0633\u06a9\u200c\u0647\u0627\u06cc \u0645\u062d\u0644\u06cc \u0648 \u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0645\u0627\u0646\u0646\u062f DigitalOcean Spaces. \u0647\u0646\u06af\u0627\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u062f\u0633\u062a\u06af\u0627\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<p>DigitalOcean Spaces \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u06cc\u0621 \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0644\u0627\u06cc\u0647 \u062f\u0631 \u0645\u0639\u0645\u0627\u0631\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc ClickHouse \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0634\u0648\u062f. \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u0634\u0645\u0627 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u0631\u0627\u062d\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06af\u0632\u06cc\u0646\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0644\u0627\u0633\u062a\u0631 ClickHouse \u0631\u0627\u0647\u0646\u0645\u0627\u06cc\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u06cc\u06a9 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0633\u0627\u062f\u0647 Go \u0631\u0627 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f \u06a9\u0647 \u0644\u0627\u06af\u200c\u0647\u0627\u06cc \u062f\u0633\u062a\u0647\u200c\u0627\u06cc \u0631\u0627 \u0628\u0647 ClickHouse \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u0628\u062a\u062f\u0627\u060c \u0644\u0627\u06af\u200c\u0647\u0627 \u062f\u0631 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u063a (\u062f\u06cc\u0633\u06a9 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636\u060c \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u0645\u062d\u0644\u06cc \u0646\u06cc\u0632 \u06af\u0641\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f) \u0630\u062e\u06cc\u0631\u0647 \u062e\u0648\u0627\u0647\u0646\u062f \u0634\u062f \u0648 \u0633\u067e\u0633 \u067e\u0633 \u0627\u0632 \u06cc\u06a9 \u0641\u0627\u0635\u0644\u0647 \u0632\u0645\u0627\u0646\u06cc \u0645\u0634\u062e\u0635 (\u06f2 \u062f\u0642\u06cc\u0642\u0647) \u0628\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0633\u0631\u062f (\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 S3 \u0645\u0627\u0646\u0646\u062f DO Spaces) \u0645\u0646\u062a\u0642\u0644 \u062e\u0648\u0627\u0647\u0646\u062f \u0634\u062f.<\/p>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"847\"  height=\"492\"  class=\"aligncenter wp-image-16353 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 847px) 100vw, 847px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7.png 847w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-300x174.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-768x446.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-110x64.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-200x116.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-380x221.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-255x148.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-550x319.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14011627\/1-7-800x465.png 800w\" ><\/p>\n<h5 id=\"%d9%be%db%8c%d8%b4-%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\">\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627<\/h5>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0634\u0631\u0648\u0639\u060c \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:<\/p>\n<ul>\n<li>\u06cc\u06a9 \u062d\u0633\u0627\u0628 Cloud \u062f\u0631 DigitalOcean.<\/li>\n<li>\u06cc\u06a9 \u0633\u0637\u0644 DigitalOcean Spaces.<\/li>\n<li>\u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 DigitalOcean Spaces.<\/li>\n<li>\u0622\u0634\u0646\u0627\u06cc\u06cc \u0627\u0628\u062a\u062f\u0627\u06cc\u06cc \u0628\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc\u200c\u0647\u0627\u06cc ClickHouse \u0648 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u06cc\u0621.<\/li>\n<\/ul>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-1-%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%d9%88-%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c-%db%8c%da%a9-digitalocean-space\">\u0645\u0631\u062d\u0644\u0647 1 \u2014 \u0627\u06cc\u062c\u0627\u062f \u0648 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06cc\u06a9 DigitalOcean Space<\/h2>\n<p>\u0648\u0627\u0631\u062f \u062d\u0633\u0627\u0628 Cloud \u062e\u0648\u062f \u062f\u0631 DigitalOcean \u0634\u0648\u06cc\u062f \u0648 \u06cc\u06a9 \u0641\u0636\u0627\u06cc \u062c\u062f\u06cc\u062f (\u0633\u0637\u0644) \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u0633\u0637\u0644 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06a9\u0645\u200c\u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<ul>\n<li>\u0628\u0647 \u0628\u062e\u0634 Spaces \u0627\u0632 \u062f\u0627\u0634\u0628\u0648\u0631\u062f \u0628\u0631\u0648\u06cc\u062f.<\/li>\n<\/ul>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1250\"  height=\"122\"  class=\"aligncenter wp-image-16354 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1250px) 100vw, 1250px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4.png 1250w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-300x29.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-1024x100.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-768x75.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-110x11.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-200x20.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-380x37.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-255x25.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-550x54.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-800x78.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14011746\/2-4-1160x113.png 1160w\" ><\/p>\n<ul>\n<li>\u0628\u0631 \u0631\u0648\u06cc &#8220;\u0627\u06cc\u062c\u0627\u062f \u0641\u0636\u0627\u06cc \u062c\u062f\u06cc\u062f&#8221; \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f\u060c \u0646\u0627\u0645\u06cc \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0647\u060c \u0645\u0646\u0637\u0642\u0647 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u0645\u062c\u0648\u0632\u0647\u0627 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"916\"  class=\"aligncenter wp-image-16355 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-300x172.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-1024x586.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-768x440.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-1536x879.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-110x63.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-200x115.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-380x218.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-255x146.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-550x315.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-800x458.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14011850\/3-4-1160x664.png 1160w\" ><\/p>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"867\"  class=\"aligncenter wp-image-16356 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-300x163.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-1024x555.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-768x416.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-1536x832.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-110x60.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-200x108.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-380x206.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-255x138.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-550x298.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-800x434.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14011921\/4-4-1160x629.png 1160w\" ><\/p>\n<ul>\n<li>\u0622\u062f\u0631\u0633 URL \u0646\u0642\u0637\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc\u06cc (Endpoint URL) \u0631\u0627 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"893\"  class=\"aligncenter wp-image-16357 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-300x167.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-1024x572.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-768x429.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-1536x857.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-110x61.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-200x112.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-380x212.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-255x142.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-550x307.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-800x447.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14012034\/5-3-1160x647.png 1160w\" ><\/p>\n<ul>\n<li>\u06a9\u0644\u06cc\u062f \u062f\u0633\u062a\u0631\u0633\u06cc \u0648 \u06a9\u0644\u06cc\u062f \u0645\u062e\u0641\u06cc \u0631\u0627 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u06a9\u0646\u06cc\u062f \u0686\u0631\u0627 \u06a9\u0647 \u0628\u0647 \u0622\u0646\u200c\u0647\u0627 \u062f\u0631 \u0645\u0631\u0627\u062d\u0644 \u0628\u0639\u062f\u06cc \u0646\u06cc\u0627\u0632 \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u0634\u062a.<\/li>\n<\/ul>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"351\"  class=\"aligncenter wp-image-16358 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-300x66.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-1024x225.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-768x168.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-1536x337.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-110x24.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-200x44.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-380x83.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-255x56.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-550x121.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-800x176.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14012142\/6-2-1160x254.png 1160w\" ><\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647\u060c \u0633\u0637\u0644 \u0634\u0645\u0627 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0648 \u0622\u0645\u0627\u062f\u0647 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647\u200c\u0633\u0627\u0632\u06cc \u0628\u0627 ClickHouse \u0627\u0633\u062a.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-2-%d8%b1%d8%a7%d9%87%d8%a7%d9%86%d8%af%d8%a7%d8%b2%db%8c-%d8%b3%d8%b1%d9%88%d8%b1-clickhouse-%d8%af%d8%b1-%da%a9%d8%a7%d9%86%d8%aa%db%8c%d9%86%d8%b1-d\">\u0645\u0631\u062d\u0644\u0647 2 \u2014 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u0633\u0631\u0648\u0631 ClickHouse \u062f\u0631 \u06a9\u0627\u0646\u062a\u06cc\u0646\u0631 Docker<\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639\u060c \u06cc\u06a9 \u067e\u0648\u0634\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0646\u0627\u0645 \u0622\u0646 \u0631\u0627 &#8220;clickhouse&#8221; \u0628\u06af\u0630\u0627\u0631\u06cc\u062f.<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>mkdir clickhouse<\/code><\/pre>\n<\/div>\n<p>\u06cc\u06a9 \u0641\u0627\u06cc\u0644 Dockerfile \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0648\u0634\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 {YOUR_AWS_ACCESS_KEY_ID} \u0648 {YOUR_AWS_SECRET_ACCESS_KEY} \u0631\u0627 \u0628\u0627 \u06a9\u0644\u06cc\u062f \u062f\u0633\u062a\u0631\u0633\u06cc \u0648 \u06a9\u0644\u06cc\u062f \u0645\u062e\u0641\u06cc \u062e\u0648\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>FROM clickhouse\/clickhouse-server:latest\r\n# Copy the config file to the container\r\nCOPY storage.xml \/etc\/clickhouse-server\/config.d\/storage.xml\r\n# Copy the S3 table creation script\r\nCOPY create.sql \/docker-entrypoint-initdb.d\/\r\n# Set environment variables for S3 credentials\r\nENV AWS_ACCESS_KEY_ID={YOUR_AWS_ACCESS_KEY_ID}\r\nENV AWS_SECRET_ACCESS_KEY={YOUR_AWS_SECRET_ACCESS_KEY}\r\n# Expose ClickHouse HTTP and native ports\r\nEXPOSE 8123 9000\r\nUSER clickhouse\r\n# --config-file .\/programs\/server\/config.xml\r\nCMD [\"clickhouse-server\", \"--config-file\", \"\/etc\/clickhouse-server\/config.xml\"]<\/code><\/pre>\n<\/div>\n<p>\u062a\u0648\u0636\u06cc\u062d\u0627\u062a:<\/p>\n<ul>\n<li>access_key_id \u0648 secret_access_key: \u0627\u06cc\u0646\u200c\u0647\u0627 \u0627\u0639\u062a\u0628\u0627\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc DigitalOcean Spaces \u0647\u0633\u062a\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0647\u0634\u062f\u0627\u0631: \u0645\u0627 \u0628\u0631\u0627\u06cc \u0633\u0627\u062f\u06af\u06cc \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0627\u0639\u062a\u0628\u0627\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0641\u0627\u06cc\u0644 Dockerfile \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0627\u0645\u0627 \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f \u062a\u0648\u0635\u06cc\u0647 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-3-%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c-clickhouse-%d8%a8%d8%b1%d8%a7%db%8c-%d8%b0%d8%ae%db%8c%d8%b1%d9%87%d8%b3%d8%a7%d8%b2%db%8c-%d8%b3\">\u0645\u0631\u062d\u0644\u0647 3 \u2014 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc ClickHouse \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627 S3<\/h2>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647\u060c ClickHouse \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0644\u0627\u06cc\u0647 \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062e\u0648\u062f \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0634\u0627\u0645\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0628\u0647 \u0641\u0627\u06cc\u0644 config.xml \u062f\u0631 \u0646\u0635\u0628 ClickHouse \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u0637\u0644 Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062f\u06cc\u0633\u06a9 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc ClickHouse \u0627\u0639\u0644\u0627\u0645 \u06a9\u0646\u06cc\u062f. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0627\u06cc\u0644 config.xml \u0645\u0648\u062c\u0648\u062f \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u062a\u0631\u062c\u06cc\u062d\u0627\u064b \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u062c\u062f\u06cc\u062f \u062f\u0631 \u067e\u0648\u0634\u0647 conf.d \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0639\u062f\u0627\u064b \u0628\u0647 config.xml \u067e\u06cc\u0648\u0633\u062a\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\">&lt;clickhouse&gt;\r\n&lt;storage_configuration&gt;\r\n&lt;disks&gt;\r\n&lt;s3&gt;\r\n&lt;type&gt;s3&lt;\/type&gt;\r\n&lt;endpoint&gt;{YOUR_S3_SPACES_BUCKET_URL}&lt;\/endpoint&gt;\r\n&lt;use_environment_credentials&gt;true&lt;\/use_environment_credentials&gt;\r\n&lt;\/s3&gt;\r\n&lt;\/disks&gt;\r\n&lt;\/storage_configuration&gt;\r\n&lt;\/clickhouse&gt;<\/pre>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0628\u062e\u0634 \u06cc\u06a9 \u062f\u06cc\u0633\u06a9 \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 (DigitalOcean Space) \u0631\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 ClickHouse \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06a9\u0645\u200c\u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f.<\/p>\n<p><span style=\"color: #ff0000;\">\u062a\u0648\u062c\u0647: \u0645\u0642\u0627\u062f\u06cc\u0631 {YOUR_S3_SPACES_BUCKET_URL} \u0631\u0627 \u0628\u0627 URL \u0646\u0642\u0637\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc\u06cc \u062e\u0648\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-4-%d8%a7%db%8c%d8%ac%d8%a7%d8%af-%db%8c%da%a9-%d8%ac%d8%af%d9%88%d9%84-%d8%a8%d8%a7-%d8%b0%d8%ae%db%8c%d8%b1%d9%87%d8%b3%d8%a7%d8%b2%db%8c-%d9%84\">\u0645\u0631\u062d\u0644\u0647 4 \u2014 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc<\/h2>\n<p>\u062d\u0627\u0644\u060c \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 ClickHouse \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0627\u0632 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0686\u0646\u062f\u06cc\u0646 \u0633\u06cc\u0627\u0633\u062a \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u062f \u06a9\u062f\u0627\u0645 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u062f\u06cc\u0633\u06a9\u200c\u0647\u0627\u06cc \u0645\u062d\u0644\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u0648\u0646\u062f \u0648 \u06a9\u062f\u0627\u0645\u200c\u0647\u0627 \u062f\u0631 \u062f\u06cc\u0633\u06a9\u200c\u0647\u0627\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 (Spaces) \u0630\u062e\u06cc\u0631\u0647 \u0634\u0648\u0646\u062f.<\/p>\n<p>\u06cc\u06a9 \u0633\u06cc\u0627\u0633\u062a \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc\u200c\u062a\u0631 \u0631\u0627 \u067e\u0633 \u0627\u0632 \u0645\u062f\u062a \u0632\u0645\u0627\u0646 \u0645\u0634\u062e\u0635 \u0628\u0647 DigitalOcean Spaces \u0645\u0646\u062a\u0642\u0644 \u06a9\u0646\u062f:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>CREATE TABLE IF NOT EXISTS tiered_logs (\r\nevent_time DateTime,\r\nlevel String,\r\nmessage String\r\n) ENGINE = MergeTree\r\nORDER BY (event_time)\r\nTTL toDateTime(event_time) + INTERVAL 2 MINUTE TO VOLUME 'cold'\r\nSETTINGS storage_policy = 's3_tiered';<\/code><\/pre>\n<\/div>\n<p>\u062a\u0648\u0636\u06cc\u062d\u0627\u062a:<\/p>\n<ul>\n<li>default: \u0627\u06cc\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u06cc\u0633\u06a9 \u0645\u062d\u0644\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0627\u062e\u06cc\u0631 \u06cc\u0627 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0622\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/li>\n<li>s3: \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 (DigitalOcean Spaces) \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc\u200c\u062a\u0631 \u0628\u0647 \u0622\u0646 \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/li>\n<\/ul>\n<p>\u0627\u06cc\u0646 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0628\u0647 \u062f\u06cc\u0633\u06a9 \u0645\u062d\u0644\u06cc \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc\u200c\u062a\u0631 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u0647 DigitalOcean Spaces \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-5-%d8%a7%d8%ac%d8%b1%d8%a7%db%8c-%d8%b3%d8%b1%d9%88%d8%b1-clickhouse\">\u0645\u0631\u062d\u0644\u0647 5 \u2014 \u0627\u062c\u0631\u0627\u06cc \u0633\u0631\u0648\u0631 ClickHouse<\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u0633\u0631\u0648\u0631 ClickHouse\u060c \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>docker build -t clickhouse-demo .\r\ndocker run -d --name clickhouse-demo -p 8123:8123 -p 9000:9000 clickhouse-demo<\/code><\/pre>\n<\/div>\n<h3 id=\"\"><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"528\"  class=\"aligncenter wp-image-16359 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-300x99.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-1024x338.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-768x253.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-1536x507.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-110x36.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-200x66.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-380x125.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-255x84.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-550x182.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-800x264.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14012638\/7-1-1160x383.png 1160w\" ><\/h3>\n<h5 id=\"%d9%be%d9%88%d8%b1%d8%aa-%d9%87%d8%a7%db%8c-%d8%b4%d8%a8%da%a9%d9%87\">\u067e\u0648\u0631\u062a \u0647\u0627\u06cc \u0634\u0628\u06a9\u0647<\/h5>\n<ul>\n<li>8123: \u0627\u06cc\u0646 \u067e\u0648\u0631\u062a HTTP \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0628\u0631\u0642\u0631\u0627\u0631\u06cc \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627 ClickHouse \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0631\u0627\u0628\u0637 HTTP \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. (http:\/\/localhost:8123\/play). \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u067e\u0648\u0631\u062a \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u0631\u0648\u0631\u06af\u0631 \u06cc\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0645\u0627\u0646\u0646\u062f curl \u06cc\u0627 Postman \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u063a\u0644\u0628 \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0648\u0628 \u06cc\u0627 \u06a9\u0644\u0627\u06cc\u0646\u062a \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0627 ClickHouse \u0627\u0632 \u0637\u0631\u06cc\u0642 HTTP \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0631\u0646\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<li>9000: \u0627\u06cc\u0646 \u067e\u0648\u0631\u062a TCP\u060c \u067e\u0648\u0631\u062a \u0627\u0635\u0644\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0644\u0627\u06cc\u0646\u062a \u0647\u0627 \u0648 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc ClickHouse \u0627\u0633\u062a \u062a\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0631\u0648\u062a\u06a9\u0644 \u0627\u0635\u0644\u06cc ClickHouse \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u0646\u062f.<\/li>\n<li>\u0645\u0631\u062c\u0639: https:\/\/clickhouse.com\/docs\/en\/guides\/sre\/network-ports<\/li>\n<\/ul>\n<h3 id=\"-2\"><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"51\"  class=\"aligncenter wp-image-16360 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-300x10.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-1024x33.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-768x24.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-1536x49.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-110x4.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-200x6.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-380x12.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-255x8.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-550x18.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-800x26.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14012846\/8-1-1160x37.png 1160w\" ><\/h3>\n<p>\u062a\u0623\u06cc\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>docker ps\r\n<\/code><\/pre>\n<\/div>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"95\"  class=\"aligncenter wp-image-16361 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-300x18.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-1024x61.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-768x46.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-1536x91.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-110x7.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-200x12.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-380x23.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-255x15.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-550x33.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-800x48.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14013003\/9-1-1160x69.png 1160w\" ><\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-6-%d8%a7%d8%ac%d8%b1%d8%a7%db%8c-%db%8c%da%a9-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-%d8%b3%d8%a7%d8%af%d9%87-go-%da%a9%d9%87-%d9%84%d8%a7%da%af%d9%87\">\u0645\u0631\u062d\u0644\u0647 6 \u2014 \u0627\u062c\u0631\u0627\u06cc \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0633\u0627\u062f\u0647 Go \u06a9\u0647 \u0644\u0627\u06af\u200c\u0647\u0627 \u0631\u0627 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f<\/h2>\n<p>\u062f\u0631 \u06cc\u06a9 \u067e\u0648\u0634\u0647 \u062c\u062f\u06cc\u062f\u060c \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0628\u0647 \u0646\u0627\u0645 <code>main.go<\/code> \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0644\u0627\u06af\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 ClickHouse \u0627\u0631\u0633\u0627\u0644 \u06a9\u0646\u062f.<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>package main\r\nimport (\r\n\"database\/sql\"\r\n\"fmt\"\r\n\"log\"\r\n\"os\"\r\n\"time\"\r\n\"github.com\/ClickHouse\/clickhouse-go\"\r\n\"github.com\/sirupsen\/logrus\"\r\n)\r\ntype ClickHouseHook struct {\r\ndb *sql.DB\r\nentries []logrus.Entry\r\nbatchSize int\r\n}\r\n\/\/ NewClickHouseHook establishes a connection to ClickHouse using the provided DSN.\r\nfunc NewClickHouseHook(dsn string, batchSize int) (*ClickHouseHook, error) {\r\ndb, err := sql.Open(\"clickhouse\", dsn)\r\nif err != nil {\r\nreturn nil, err\r\n}\r\nif err := db.Ping(); err != nil {\r\nif exception, ok := err.(*clickhouse.Exception); ok {\r\nlog.Fatalf(\"[%d] %s \\n%s\\n\", exception.Code, exception.Message, exception.StackTrace)\r\n} else {\r\nlog.Fatal(err)\r\n}\r\n}\r\nreturn &amp;ClickHouseHook{db: db, batchSize: batchSize}, nil\r\n}\r\n\/\/ Fire is triggered by Logrus to log entries to ClickHouse.\r\nfunc (hook *ClickHouseHook) Fire(entry *logrus.Entry) error {\r\nhook.entries = append(hook.entries, *entry)\r\nif len(hook.entries) &gt;= hook.batchSize {\r\nif err := hook.flush(); err != nil {\r\nreturn err\r\n}\r\n}\r\nreturn nil\r\n}\r\n\/\/ flush sends the collected log entries to ClickHouse in a batch.\r\nfunc (hook *ClickHouseHook) flush() error {\r\ntx, err := hook.db.Begin()\r\nif err != nil {\r\nreturn err\r\n}\r\nstmt, err := tx.Prepare(\"INSERT INTO tiered_logs (event_time, level, message) VALUES (?, ?, ?)\")\r\nif err != nil {\r\nreturn err\r\n}\r\ndefer stmt.Close()\r\nfor _, entry := range hook.entries {\r\nif _, err := stmt.Exec(entry.Time, entry.Level.String(), entry.Message); err != nil {\r\nreturn err\r\n}\r\n}\r\nif err := tx.Commit(); err != nil {\r\nreturn err\r\n}\r\n\/\/ Clear the entries after flushing\r\nhook.entries = nil\r\nreturn nil\r\n}\r\n\/\/ Levels returns the logging levels for which the hook is triggered.\r\nfunc (hook *ClickHouseHook) Levels() []logrus.Level {\r\nreturn logrus.AllLevels\r\n}\r\nfunc main() {\r\n\/\/ ClickHouse DSN (replace with your credentials and host)\r\ndsn := \"tcp:\/\/localhost:9000?database=default&amp;username=default&amp;password=&amp;debug=true\"\r\n\/\/ Create ClickHouse hook with a batch size of 5\r\nhook, err := NewClickHouseHook(dsn, 5)\r\nif err != nil {\r\nlog.Fatalf(\"failed to connect to ClickHouse: %v\", err)\r\n}\r\ndefer hook.db.Close()\r\n\/\/ Set up logrus\r\nlogger := logrus.New()\r\nlogger.Out = os.Stdout\r\nlogger.SetFormatter(&amp;logrus.TextFormatter{\r\nFullTimestamp: true,\r\n})\r\nlogger.AddHook(hook)\r\n\/\/ Log some entries\r\nfor i := 0; i &lt; 10; i++ {\r\nlogger.WithFields(logrus.Fields{\r\n\"iteration\": i,\r\n}).Info(\"This is an info log entry\")\r\ntime.Sleep(time.Second)\r\n}\r\n\/\/ Flush any remaining log entries before exiting\r\nif err := hook.flush(); err != nil {\r\nlog.Fatalf(\"failed to flush logs to ClickHouse: %v\", err)\r\n}\r\nfmt.Println(\"Logs sent to ClickHouse.\")\r\n}<\/code><\/pre>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0648\u0627\u0628\u0633\u062a\u06af\u06cc\u200c\u0647\u0627\u06cc \u067e\u06a9\u06cc\u062c:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>go mod init example.com\/clickhouse-logging\r\ngo get github.com\/ClickHouse\/clickhouse-go\r\ngo get github.com\/sirupsen\/logrus<\/code><\/pre>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>go run main.go<\/code><\/pre>\n<\/div>\n<h3 id=\"-3\"><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"737\"  class=\"aligncenter wp-image-16362 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-300x138.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-1024x472.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-768x354.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-1536x708.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-110x51.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-200x92.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-380x175.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-255x117.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-550x253.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-800x369.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14013420\/10-1-1160x534.png 1160w\" ><\/h3>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-7-%d8%aa%d8%a7%db%8c%db%8c%d8%af-%d9%86%d8%aa%d8%a7%db%8c%d8%ac\">\u0645\u0631\u062d\u0644\u0647 7 \u2014 \u062a\u0627\u06cc\u06cc\u062f \u0646\u062a\u0627\u06cc\u062c<\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u06a9\u0644\u0627\u06cc\u0646\u062a ClickHouse\u060c \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-bash\" data-lang=\"Bash\"><code>docker exec -it clickhouse-demo clickhouse-client<\/code><\/pre>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062a\u0627\u06cc\u06cc\u062f \u0644\u0627\u06af\u200c\u0647\u0627 \u062f\u0631 \u06a9\u0644\u0627\u0633\u062a\u0631 ClickHouse:<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>SELECT * FROM tiered_logs<\/code><\/pre>\n<\/div>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"380\"  class=\"aligncenter wp-image-16363 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-300x71.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-1024x243.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-768x182.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-1536x365.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-110x26.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-200x48.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-380x90.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-255x61.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-550x131.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-800x190.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14013636\/11-1-1160x276.png 1160w\" ><\/p>\n<p>\u0647\u0646\u06af\u0627\u0645 \u0628\u0631\u0631\u0633\u06cc \u062f\u06cc\u0633\u06a9 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0648\u0631\u0648\u062f\u06cc \u06af\u0632\u0627\u0631\u0634\u060c \u0645\u06cc \u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u067e\u06cc\u0634 \u0641\u0631\u0636 (\u0645\u062d\u0644\u06cc) &#8211; \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u063a \u0646\u06cc\u0632 \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f &#8211; \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<div class=\"hcb_wrap\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>SELECT name, disk_name FROM system.parts WHERE table = 'tiered_logs';\r\n<\/code><\/pre>\n<\/div>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"282\"  class=\"aligncenter wp-image-16364 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-300x53.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-1024x180.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-768x135.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-1536x271.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-110x19.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-200x35.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-380x67.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-255x45.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-550x97.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-800x141.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14013813\/12-1160x204.png 1160w\" ><\/p>\n<p>\u067e\u0633 \u0627\u0632 \u0641\u0627\u0635\u0644\u0647 \u062f\u0648 \u062f\u0642\u06cc\u0642\u0647 \u0627\u06cc \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u062f\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648 CREATE TABLE\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u06af\u0632\u0627\u0631\u0634 \u0647\u0627 \u0628\u0647 \u062f\u06cc\u0633\u06a9 \u0647\u0627\u06cc S3 (\u0633\u0637\u0644 \u0631\u0627\u0647 \u062f\u0648\u0631\/\u0641\u0636\u0627) \u0645\u0646\u062a\u0642\u0644 \u0634\u062f\u0647 \u0627\u0646\u062f &#8211; \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0633\u0631\u062f \u0646\u06cc\u0632 \u0645\u06cc \u06af\u0648\u06cc\u0646\u062f.<\/p>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"288\"  class=\"aligncenter wp-image-16365 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-300x54.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-1024x184.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-768x138.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-1536x276.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-110x20.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-200x36.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-380x68.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-255x46.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-550x99.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-800x144.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14013910\/13-1160x209.png 1160w\" ><\/p>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062f\u0631 DigitalOcean Cloud UI \u0628\u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0633\u0637\u0644 \u0645\u0627 \u0627\u06a9\u0646\u0648\u0646 \u062d\u0627\u0648\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0627\u0633\u062a:<\/p>\n<p><img  loading=\"lazy\"  decoding=\"async\"  src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABAQMAAAAl21bKAAAAA1BMVEUAAP+KeNJXAAAAAXRSTlMAQObYZgAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAApJREFUCNdjYAAAAAIAAeIhvDMAAAAASUVORK5CYII=\"  alt=\"\"  width=\"1600\"  height=\"881\"  class=\"aligncenter wp-image-16366 size-full pk-lazyload\"  data-pk-sizes=\"auto\"  data-ls-sizes=\"auto, (max-width: 1600px) 100vw, 1600px\"  data-pk-src=\"https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14.png\"  data-pk-srcset=\"https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14.png 1600w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-300x165.png 300w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-1024x564.png 1024w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-768x423.png 768w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-1536x846.png 1536w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-110x61.png 110w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-200x110.png 200w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-380x209.png 380w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-255x140.png 255w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-550x303.png 550w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-800x441.png 800w, https:\/\/cdn.itpiran.net\/2024\/11\/14014010\/14-1160x639.png 1160w\" ><\/p>\n<h2 id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\">\u0646\u062a\u06cc\u062c\u0647\u200c<\/h2>\n<p>\u0628\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0634\u0645\u0627 \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u0648\u0641\u0642\u06cc\u062a\u200c\u0622\u0645\u06cc\u0632 DigitalOcean Spaces \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06af\u0632\u06cc\u0646\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc ClickHouse \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f. \u0627\u06cc\u0646 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0628\u0647 \u0634\u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0647\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0631\u0627 \u0628\u0647\u06cc\u0646\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0627 \u0627\u0646\u062a\u0642\u0627\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06a9\u0645\u200c\u062f\u0633\u062a\u0631\u0633 \u0628\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u06cc\u0621 \u0645\u0642\u0631\u0648\u0646\u200c\u0628\u0647\u200c\u0635\u0631\u0641\u0647 \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u06cc\u062f\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0628\u0627 \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0627\u0644\u0627 \u0628\u0631\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0641\u0639\u0627\u0644 \u062d\u0641\u0638 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"Giri\u015f ClickHouse, y\u00fcksek performansl\u0131 OLAP sorgular\u0131 ger\u00e7ekle\u015ftirmeye yard\u0131mc\u0131 olan a\u00e7\u0131k kaynakl\u0131 bir s\u00fctunlu veritaban\u0131 y\u00f6netim sistemidir\u2026","protected":false},"author":1,"featured_media":16368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"DigitalOcean Spaces \u062f\u0631 ClickHouse","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","_yoast_wpseo_canonical":"","_yoast_wpseo_opengraph-description":"","_yoast_wpseo_opengraph-image":"","_yoast_wpseo_twitter-description":"","_yoast_wpseo_twitter-image":"","_yoast_wpseo_focuskeywords":"","_yoast_wpseo_primary_category":"193","footnotes":""},"categories":[193],"tags":[401],"class_list":{"0":"post-16352","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"tag-digitalocean"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f - \u0628\u0644\u0627\u06af ITPiran<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647 ClickHouse \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646\u06cc \u0645\u062a\u0646\u200c\u0628\u0627\u0632 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u067e\u0631\u0633\u200c\u0648\u062c\u0648\u0647\u0627\u06cc OLAP \u0628\u0627 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0628\u0627\u0644\u0627&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-13T22:23:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1793\" \/>\n\t<meta property=\"og:image:height\" content=\"1110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f\",\"datePublished\":\"2024-11-13T22:23:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/\"},\"wordCount\":134,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/11\\\/14015158\\\/digitalOcean.jpg\",\"keywords\":[\"Digitalocean\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/\",\"name\":\"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/11\\\/14015158\\\/digitalOcean.jpg\",\"datePublished\":\"2024-11-13T22:23:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/11\\\/14015158\\\/digitalOcean.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/11\\\/14015158\\\/digitalOcean.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/use-digitalocean-spaces-bucket-as-tiered-storage\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/category\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"name\":\"\u0628\u0644\u0627\u06af ITPiran\",\"description\":\"\u0627\u062e\u0628\u0627\u0631 \u0648 \u0645\u0642\u0627\u0644\u0627\u062a \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\",\"name\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"alternateName\":\"ITPIran Blog\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"width\":512,\"height\":512,\"caption\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tr\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ClickHouse&#039;da katmanl\u0131 depolama olarak DigitalOcean Spaces kovas\u0131 nas\u0131l kullan\u0131l\u0131r? - ITPiran Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/","og_locale":"tr_TR","og_type":"article","og_title":"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647 ClickHouse \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646\u06cc \u0645\u062a\u0646\u200c\u0628\u0627\u0632 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u067e\u0631\u0633\u200c\u0648\u062c\u0648\u0647\u0627\u06cc OLAP \u0628\u0627 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0628\u0627\u0644\u0627&hellip;","og_url":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-11-13T22:23:57+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"admin","Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f","datePublished":"2024-11-13T22:23:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/"},"wordCount":134,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg","keywords":["Digitalocean"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/","name":"ClickHouse&#039;da katmanl\u0131 depolama olarak DigitalOcean Spaces kovas\u0131 nas\u0131l kullan\u0131l\u0131r? - ITPiran Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg","datePublished":"2024-11-13T22:23:57+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/11\/14015158\/digitalOcean.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/use-digitalocean-spaces-bucket-as-tiered-storage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itpiran.net\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0622\u0645\u0648\u0632\u0634\u06cc","item":"https:\/\/www.itpiran.net\/blog\/category\/tutorials\/"},{"@type":"ListItem","position":3,"name":"\u0686\u06af\u0648\u0646\u0647 \u0627\u0632 \u0633\u0637\u0644 DigitalOcean Spaces \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0627\u06cc \u062f\u0631 ClickHouse \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"\u0130ran S\u00fcrd\u00fcr\u00fclebilir Ticaret Haberleri ve Makaleleri","publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itpiran.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"S\u00fcrd\u00fcr\u00fclebilir \u0130ran \u0130\u015fletmeleri Blogu","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","contentUrl":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","width":512,"height":512,"caption":"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81","name":"y\u00f6netici","url":"https:\/\/www.itpiran.net\/blog\/tr\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/16352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/comments?post=16352"}],"version-history":[{"count":3,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/16352\/revisions"}],"predecessor-version":[{"id":16370,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/16352\/revisions\/16370"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media\/16368"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media?parent=16352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/categories?post=16352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/tags?post=16352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}