From b4a292901d152256591d814de18136b14ce4e3b6 Mon Sep 17 00:00:00 2001
From: alex <alex@pdp7.net>
Date: Sat, 25 May 2024 11:36:38 +0200
Subject: Try to control ClickHouse log table size

---
 .../puppet/modules/clickhouse/manifests/init.pp       | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

(limited to 'personal_infra/puppet')

diff --git a/personal_infra/puppet/modules/clickhouse/manifests/init.pp b/personal_infra/puppet/modules/clickhouse/manifests/init.pp
index 37c6bb6f..60ab3877 100644
--- a/personal_infra/puppet/modules/clickhouse/manifests/init.pp
+++ b/personal_infra/puppet/modules/clickhouse/manifests/init.pp
@@ -22,7 +22,7 @@ class clickhouse {
   ->
   package {['clickhouse-server', 'clickhouse-client', 'clickhouse-keeper']:}
   ->
-  [File['/etc/clickhouse-server/config.d/network.xml']]
+  [File['/etc/clickhouse-server/config.d/network.xml'], File['/etc/clickhouse-server/config.d/logs.xml']]
   ~>
   service {['clickhouse-server', 'clickhouse-keeper']:
     ensure => running,
@@ -37,4 +37,21 @@ class clickhouse {
       | EOT
     ,
   }
+
+  file {'/etc/clickhouse-server/config.d/logs.xml':
+    content => @(EOT)
+      <clickhouse>
+        <asynchronous_metric_log>
+          <ttl>event_date + INTERVAL 3 DAY DELETE</ttl>
+        </asynchronous_metric_log>
+        <trace_log>
+          <ttl>event_date + INTERVAL 3 DAY DELETE</ttl>
+        </trace_log>
+        <metric_log>
+          <ttl>event_date + INTERVAL 3 DAY DELETE</ttl>
+        </metric_log>
+      </clickhouse>
+    | EOT
+    ,
+  }
 }
-- 
cgit v1.2.3