Add promscale for long term storage of prometheus data

diff --git a/cookbooks/prometheus/metadata.rb b/cookbooks/prometheus/metadata.rb
index e6173a037697d66c2959a75598ec2561ad30e166..2ac7f9bf70dc1b4f8c87f5001ba10559a4767b0b 100644 (file)
--- a/cookbooks/prometheus/metadata.rb
+++ b/cookbooks/prometheus/metadata.rb
@@ -10,3 +10,4 @@ depends           "apache"
 depends           "apt"
 depends           "git"
 depends           "networking"
 depends           "apt"
 depends           "git"
 depends           "networking"

+depends           "timescaledb"

diff --git a/cookbooks/prometheus/recipes/server.rb b/cookbooks/prometheus/recipes/server.rb
index f3ff4d9ca636be1e597cca271a62f87bb35d3d0a..6e112a000fcf775d686f45f2fe9da0899615fd8d 100644 (file)
--- a/cookbooks/prometheus/recipes/server.rb
+++ b/cookbooks/prometheus/recipes/server.rb
@@ -20,6 +20,7 @@
 include_recipe "apache"
 include_recipe "apt"
 include_recipe "networking"
 include_recipe "apache"
 include_recipe "apt"
 include_recipe "networking"

+include_recipe "timescaledb"

 
 passwords = data_bag_item("prometheus", "passwords")
 tokens = data_bag_item("prometheus", "tokens")
 
 passwords = data_bag_item("prometheus", "passwords")
 tokens = data_bag_item("prometheus", "tokens")


@@ -33,6 +34,112 @@ end
 
 package "prometheus"
 
 
 package "prometheus"
 

+promscale_version = "0.1.4"
+
+database_cluster = node[:timescaledb][:cluster]
+
+postgresql_user "prometheus" do
+  cluster database_cluster
+  createrole true
+end
+
+postgresql_database "promscale" do
+  cluster database_cluster
+  owner "prometheus"
+end
+
+postgresql_extension "timescaledb" do
+  cluster database_cluster
+  database "promscale"
+end
+
+directory "/opt/promscale" do
+  owner "root"
+  group "root"
+  mode "755"
+end
+
+package %w[
+  make
+  gcc
+  clang-9
+  llvm-9
+  cargo
+]
+
+git "/opt/promscale/extension" do
+  action :sync
+  repository "https://github.com/timescale/promscale_extension.git"
+  revision "0.1.1"
+  user "root"
+  group "root"
+end
+
+execute "/opt/promscale/extension/Makefile" do
+  action :nothing
+  command "make install"
+  cwd "/opt/promscale/extension"
+  user "root"
+  group "root"
+  subscribes :run, "git[/opt/promscale/extension]", :immediate
+  notifies :restart, "service[postgresql]", :immediate
+end
+
+directory "/opt/promscale/bin" do
+  owner "root"
+  group "root"
+  mode "755"
+end
+
+remote_file "/opt/promscale/bin/promscale" do
+  action :create
+  source "https://github.com/timescale/promscale/releases/download/#{promscale_version}/promscale_#{promscale_version}_Linux_x86_64"
+  owner "root"
+  group "root"
+  mode "755"
+end
+
+systemd_service "promscale" do
+  description "Promscale Connector"
+  type "simple"
+  user "prometheus"
+  exec_start "/opt/promscale/bin/promscale --db-host /run/postgresql --db-port 5432 --db-user prometheus --db-name promscale --db-connections-max 400"
+#  exec_start lazy { "/opt/promscale/bin/promscale --db-host /run/postgresql --db-port #{node[:postgresql][:clusters][database_cluster][:port]} --db-user prometheus --db-name promscale --db-max-connections 400" }
+  private_tmp true
+  protect_system "strict"
+  protect_home true
+  no_new_privileges true
+end
+
+service "promscale" do
+  action [:enable, :start]
+  subscribes :restart, "remote_file[/opt/promscale/bin/promscale]"
+  subscribes :restart, "systemd_service[promscale]"
+end
+
+postgresql_extension "promscale" do
+  cluster database_cluster
+  database "promscale"
+  notifies :restart, "service[promscale]"
+end
+
+systemd_service "promscale-maintenance" do
+  description "Promscale Maintenace"
+  type "simple"
+  user "prometheus"
+  exec_start "/usr/bin/psql --command='CALL prom_api.execute_maintenance()' promscale"
+  private_tmp true
+  protect_system "strict"
+  protect_home true
+  no_new_privileges true
+end
+
+systemd_timer "promscale-maintenance" do
+  description "Promscale Maintenace"
+  on_active_sec 1800
+  on_unit_inactive_sec 1800
+end
+

 jobs = {}
 
 search(:node, "recipes:prometheus\\:\\:default").sort_by(&:name).each do |client|
 jobs = {}
 
 search(:node, "recipes:prometheus\\:\\:default").sort_by(&:name).each do |client|

diff --git a/cookbooks/prometheus/templates/default/prometheus.yml.erb b/cookbooks/prometheus/templates/default/prometheus.yml.erb
index 46d241905d46fd17b22d72870a64d9439135168e..591c1e0ec5cdc579aaf60e5138bac7a4e1ccda26 100644 (file)
--- a/cookbooks/prometheus/templates/default/prometheus.yml.erb
+++ b/cookbooks/prometheus/templates/default/prometheus.yml.erb
@@ -21,3 +21,9 @@ scrape_configs:
           instance: <%= target[:name].split(".").first %>
 <% end -%>
 <% end -%>
           instance: <%= target[:name].split(".").first %>
 <% end -%>
 <% end -%>

+
+remote_write:
+  - url: "http://localhost:9201/write"
+
+remote_read:
+  - url: "http://localhost:9201/read"

diff --git a/test/integration/prometheus-server/serverspec/promscale_spec.rb b/test/integration/prometheus-server/serverspec/promscale_spec.rb
new file mode 100644 (file)
index 0000000..aaedf15
--- /dev/null
+++ b/test/integration/prometheus-server/serverspec/promscale_spec.rb
@@ -0,0 +1,13 @@
+require "serverspec"
+
+# Required by serverspec
+set :backend, :exec
+
+describe service("promscale") do
+  it { should be_enabled }
+  it { should be_running }
+end
+
+describe port(9201) do
+  it { should be_listening.with("tcp6") }
+end