X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/87df439f794f54da38a2cbbd01b8e81fb821cefa..f796dda7c7f5b3eb0734e1953e139646cb098f18:/cookbooks/tile/recipes/default.rb diff --git a/cookbooks/tile/recipes/default.rb b/cookbooks/tile/recipes/default.rb index f642aafb8..ddc7e490e 100644 --- a/cookbooks/tile/recipes/default.rb +++ b/cookbooks/tile/recipes/default.rb @@ -20,7 +20,6 @@ include_recipe "accounts" include_recipe "apache" include_recipe "git" -include_recipe "munin" include_recipe "nodejs" include_recipe "postgresql" include_recipe "prometheus" @@ -100,16 +99,23 @@ tile_directories = node[:tile][:styles].collect do |_, style| style[:tile_directories].collect { |directory| directory[:name] } end.flatten.sort.uniq -package "renderd" +package %w[ + renderd + libgoogle-perftools4 +] systemd_service "renderd" do dropin "chef" after "postgresql.service" wants "postgresql.service" + environment "LD_PRELOAD" => "libtcmalloc.so.4" limit_nofile 4096 + memory_high "80%" + memory_max "90%" sandbox true restrict_address_families "AF_UNIX" read_write_paths tile_directories + system_call_filter ["@system-service", "mincore"] restart "on-failure" end @@ -153,14 +159,11 @@ end package %w[ python3-cairo python3-mapnik + python3-pyotp python3-pyproj python3-setuptools ] -python_package "pyotp" do - python_version "3" -end - directory "/srv/tile.openstreetmap.org/cgi-bin" do owner "tile" group "tile" @@ -280,6 +283,8 @@ end nodejs_package "carto" +lowzoom_threads = node.cpu_cores - 1 + systemd_service "update-lowzoom@" do description "Low zoom tile update service for %i layer" user "tile" @@ -295,6 +300,72 @@ systemd_service "update-lowzoom@" do restart "on-failure" end +postgresql_version = node[:tile][:database][:cluster].split("/").first +postgis_version = node[:tile][:database][:postgis] + +package "postgresql-#{postgresql_version}-postgis-#{postgis_version}" + +postgresql_user "jburgess" do + cluster node[:tile][:database][:cluster] + superuser true +end + +postgresql_user "tomh" do + cluster node[:tile][:database][:cluster] + superuser true +end + +postgresql_user "pnorman" do + cluster node[:tile][:database][:cluster] + superuser true +end + +postgresql_user "tile" do + cluster node[:tile][:database][:cluster] +end + +postgresql_user "www-data" do + cluster node[:tile][:database][:cluster] +end + +postgresql_user "_renderd" do + cluster node[:tile][:database][:cluster] +end + +postgresql_database "gis" do + cluster node[:tile][:database][:cluster] + owner "tile" +end + +postgresql_extension "postgis" do + cluster node[:tile][:database][:cluster] + database "gis" +end + +postgresql_extension "hstore" do + cluster node[:tile][:database][:cluster] + database "gis" + only_if { node[:tile][:database][:hstore] } +end + +%w[geography_columns planet_osm_nodes planet_osm_rels planet_osm_ways raster_columns raster_overviews].each do |table| + postgresql_table table do + cluster node[:tile][:database][:cluster] + database "gis" + owner "tile" + permissions "tile" => :all + end +end + +%w[geometry_columns planet_osm_line planet_osm_point planet_osm_polygon planet_osm_roads spatial_ref_sys].each do |table| + postgresql_table table do + cluster node[:tile][:database][:cluster] + database "gis" + owner "tile" + permissions "tile" => :all, "www-data" => :select, "_renderd" => :select + end +end + directory "/srv/tile.openstreetmap.org/styles" do owner "tile" group "tile" @@ -310,7 +381,7 @@ node[:tile][:styles].each do |name, details| owner "root" group "root" mode "755" - variables :style => name + variables :style => name, :threads => lowzoom_threads end service "update-lowzoom@#{name}" do @@ -378,6 +449,18 @@ node[:tile][:styles].each do |name, details| end end + if details[:functions_script] + postgresql_execute details[:functions_script] do + action :nothing + command details[:functions_script] + cluster node[:tile][:database][:cluster] + database "gis" + user "tile" + group "tile" + subscribes :run, "git[#{style_directory}]" + end + end + execute "#{style_directory}/project.mml" do action :nothing command "carto -a 3.0.22 project.mml > project.xml" @@ -390,72 +473,6 @@ node[:tile][:styles].each do |name, details| end end -postgresql_version = node[:tile][:database][:cluster].split("/").first -postgis_version = node[:tile][:database][:postgis] - -package "postgresql-#{postgresql_version}-postgis-#{postgis_version}" - -postgresql_user "jburgess" do - cluster node[:tile][:database][:cluster] - superuser true -end - -postgresql_user "tomh" do - cluster node[:tile][:database][:cluster] - superuser true -end - -postgresql_user "pnorman" do - cluster node[:tile][:database][:cluster] - superuser true -end - -postgresql_user "tile" do - cluster node[:tile][:database][:cluster] -end - -postgresql_user "www-data" do - cluster node[:tile][:database][:cluster] -end - -postgresql_user "_renderd" do - cluster node[:tile][:database][:cluster] -end - -postgresql_database "gis" do - cluster node[:tile][:database][:cluster] - owner "tile" -end - -postgresql_extension "postgis" do - cluster node[:tile][:database][:cluster] - database "gis" -end - -postgresql_extension "hstore" do - cluster node[:tile][:database][:cluster] - database "gis" - only_if { node[:tile][:database][:hstore] } -end - -%w[geography_columns planet_osm_nodes planet_osm_rels planet_osm_ways raster_columns raster_overviews].each do |table| - postgresql_table table do - cluster node[:tile][:database][:cluster] - database "gis" - owner "tile" - permissions "tile" => :all - end -end - -%w[geometry_columns planet_osm_line planet_osm_point planet_osm_polygon planet_osm_roads spatial_ref_sys].each do |table| - postgresql_table table do - cluster node[:tile][:database][:cluster] - database "gis" - owner "tile" - permissions "tile" => :all, "www-data" => :select, "_renderd" => :select - end -end - package %w[ gdal-bin python3-yaml @@ -481,11 +498,6 @@ if node[:tile][:database][:external_data_script] end end -postgresql_munin "gis" do - cluster node[:tile][:database][:cluster] - database "gis" -end - directory File.dirname(node[:tile][:database][:node_file]) do owner "root" group "root" @@ -509,17 +521,19 @@ package %w[ osm2pgsql osmium-tool pyosmium - python3-pyproj ] -remote_directory "/usr/local/bin" do - source "bin" - owner "root" - group "root" +directory node[:tile][:replication][:directory] do + owner "tile" + group "tile" mode "755" - files_owner "root" - files_group "root" - files_mode "755" +end + +link "/var/lib/replicate" do + to node[:tile][:replication][:directory] + owner "tile" + group "tile" + not_if { node[:tile][:replication][:directory] == "/var/lib/replicate" } end template "/usr/local/bin/expire-tiles" do @@ -529,12 +543,6 @@ template "/usr/local/bin/expire-tiles" do mode "755" end -directory "/var/lib/replicate" do - owner "tile" - group "tile" - mode "755" -end - directory "/var/lib/replicate/expire-queue" do owner "tile" group "_renderd" @@ -546,7 +554,6 @@ template "/usr/local/bin/replicate" do owner "root" group "root" mode "755" - variables :postgresql_version => postgresql_version.to_f end systemd_service "expire-tiles" do @@ -555,13 +562,11 @@ systemd_service "expire-tiles" do user "_renderd" exec_start "/usr/local/bin/expire-tiles" nice 10 - standard_output "null" sandbox true + restrict_address_families "AF_UNIX" read_write_paths tile_directories + [ - "/store/database/nodes", - "/var/lib/replicate/expire-queue", - "/var/log/tile" - ] + "/var/lib/replicate/expire-queue" + ] end systemd_path "expire-tiles" do @@ -574,6 +579,13 @@ service "expire-tiles.path" do subscribes :restart, "systemd_path[expire-tiles]" end +template "/usr/local/bin/replicate-post" do + source "replicate-post.erb" + owner "root" + group "root" + mode "755" +end + systemd_service "replicate" do description "Rendering database replication service" after "postgresql.service" @@ -584,8 +596,7 @@ systemd_service "replicate" do restrict_address_families "AF_UNIX" read_write_paths [ "/store/database/nodes", - "/var/lib/replicate", - "/var/log/tile" + "/var/lib/replicate" ] restart "on-failure" end @@ -601,6 +612,7 @@ template "/usr/local/bin/render-lowzoom" do owner "root" group "root" mode "755" + variables :threads => lowzoom_threads end systemd_service "render-lowzoom" do @@ -615,7 +627,7 @@ end systemd_timer "render-lowzoom" do description "Render low zoom tiles" - on_calendar "Fri *-*-* 23:00:00 UTC" + on_calendar "23:00 #{node[:timezone]}" end service "render-lowzoom.timer" do @@ -656,19 +668,6 @@ tile_directories.each do |directory| end end -munin_plugin "mod_tile_fresh" -munin_plugin "mod_tile_latency" -munin_plugin "mod_tile_response" -munin_plugin "mod_tile_zoom" - -munin_plugin "renderd_processed" -munin_plugin "renderd_queue" -munin_plugin "renderd_queue_time" -munin_plugin "renderd_zoom" -munin_plugin "renderd_zoom_time" - -munin_plugin "replication_delay" - package "ruby-webrick" prometheus_exporter "modtile" do