From dccce793104ad6f949f1bae126f115bf7ab25113 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 25 Mar 2021 22:21:18 +0000 Subject: [PATCH 1/1] Configure snap-02 as a database slave --- roles/snap-02.rb | 24 +++++++++++++++++++++++- 1 file changed, 23 insertions(+), 1 deletion(-) diff --git a/roles/snap-02.rb b/roles/snap-02.rb index 8d3a66f33..68186bf07 100644 --- a/roles/snap-02.rb +++ b/roles/snap-02.rb @@ -11,9 +11,31 @@ default_attributes( :address => "10.0.0.4" } } + }, + :postgresql => { + :settings => { + :defaults => { + :shared_buffers => "128GB", + :work_mem => "128MB", + :maintenance_work_mem => "2GB", + :effective_cache_size => "360GB", + :effective_io_concurrency => "256", + :random_page_cost => "1.1" + } + } + }, + :sysctl => { + :postgres => { + :comment => "Increase shared memory for postgres", + :parameters => { + "kernel.shmmax" => 132 * 1024 * 1024 * 1024, + "kernel.shmall" => 132 * 1024 * 1024 * 1024 / 4096 + } + } } ) run_list( - "role[ucl]" + "role[ucl]", + "role[db-slave]" ) -- 2.39.5