aboutsummaryrefslogtreecommitdiff
path: root/app/deployment/postgres.hcl
blob: 456156ef69ee8336e9e30833d7d1315dc620ce69 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
job "postgres" {
  datacenters = ["dc1"]
  type = "system"
  priority = 90

  update {
    max_parallel     = 1
    stagger = "5m"
  }

  group "postgres" {
    task "sentinel" {
      driver = "docker"

      config {
        image = "superboum/amd64_postgres:v3"
        readonly_rootfs = false
        command = "/usr/local/bin/stolon-sentinel"
        args = [
          "--cluster-name", "pissenlit",
          "--store-backend", "consul",
          "--store-endpoints", "http://consul.service.2.cluster.deuxfleurs.fr:8500",
        ]
      }
      resources {
        memory = 100
      }
    }

    task "proxy" {
      driver = "docker"

      config {
        image = "superboum/amd64_postgres:v3"
        readonly_rootfs = false
        command = "/usr/local/bin/stolon-proxy"
        args = [
          "--cluster-name", "pissenlit",
          "--store-backend", "consul",
          "--store-endpoints", "http://consul.service.2.cluster.deuxfleurs.fr:8500",
          "--port", "5432",
          "--listen-address", "0.0.0.0"
        ]
        port_map {
          psql_proxy_port = 5432
        }
      }

      resources {
        memory = 100
        network {
          port "psql_proxy_port" {
            static = 5432
          }
        }
      }

      service {
        tags = ["sql"]
        port = "psql_proxy_port"
        address_mode = "host"
        name = "psql-proxy"
        check {
          type = "tcp"
          port = "psql_proxy_port"
          interval = "60s"
          timeout = "5s"
          check_restart {
            limit = 3
            grace = "10m"
            ignore_warnings = false
          }
        }
      }
    }

    task "keeper" {
      driver = "docker"

      config {
        network_mode = "host" 
        image = "superboum/amd64_postgres:v3"
        readonly_rootfs = false
        command = "/usr/local/bin/stolon-keeper"
        args = [
          "--cluster-name", "pissenlit",
          "--store-backend", "consul",
          "--store-endpoints", "http://consul.service.2.cluster.deuxfleurs.fr:8500",
          "--data-dir", "/mnt/persist",
          "--pg-su-password", "${PG_SU_PWD}",
          "--pg-repl-username", "${PG_REPL_USER}",
          "--pg-repl-password", "${PG_REPL_PWD}",
          "--pg-listen-address", "${attr.unique.network.ip-address}",
          "--pg-port", "5433",
          "--pg-bin-path", "/usr/lib/postgresql/9.6/bin/"
        ]
        port_map {
          psql_port = 5433
        }
        volumes = [
          "/mnt/ssd/postgres:/mnt/persist"
        ]
      }
      artifact {
        source = "http://127.0.0.1:8500/v1/kv/configuration/postgres/keeper/env.tpl?raw"
        destination = "secrets/env.tpl"
        mode = "file"
      }
      template {
        source = "secrets/env.tpl"
        destination = "secrets/env"
        env = true
      }

      resources {
        memory = 500
        network {
          port "psql_port" {
            static = "5433"
          }
        }
      }

      service {
        tags = ["sql"]
        port = "psql_port"
        address_mode = "host"
        name = "keeper"
        check {
          type = "tcp"
          port = "psql_port"
          interval = "60s"
          timeout = "5s"

          check_restart {
            limit = 3
            grace = "60m"
            ignore_warnings = false
          }
        }
      }
    }
  }
}