Re: [ADMIN] PostgreSQL on Docker

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: [ADMIN] PostgreSQL on Docker
Дата
Msg-id CAK_s-G0XVwJE0D6dGu-FX6rA82fztkY+uhSKzrc6AL0t6-ZRcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] PostgreSQL on Docker  (Johannes Truschnigg <johannes@truschnigg.info>)
Ответы Re: [ADMIN] PostgreSQL on Docker
Список pgsql-admin
On 12 February 2017 at 16:08, Johannes Truschnigg <johannes@truschnigg.info> wrote:
> Sure you CAN run an embarassingly stateful system like a RDBMS on a
> containerization platform designed to run stateless,

Running (Docker) containers does not necessitate running stateless, many
properties of Docker are very useful for stateful systems, I'm thinking of
- isolation between environments
- deploying tested and verified Docker images
- allowing your developers to use the same Docker image as production

> the pieces of the puzzle that are storage drivers (AUFS and friends) and
> enable container networking, which is not unheard of.

An example of a pattern that avoids these issues, but does give you the
isolation and deployment benefits is:

- run 1 container on 1 node
- use bind mounts
- use --net=host

e.g.: docker run -ti -v /pgdata/abc:/var/lib/postgresql/data --net=host postgres

I'm still on the fence whether or not running PostgreSQL inside containers is
advisable or not, I've actively ran many instances successfully without any
major issues. I'm currently thinking that if you run a lot of small databases
for many teams (a Database as a Service) it would be valueable. If you however
want to squeeze all the performance out of your single large database it might
not be the best way of running your system.

regards,

Feike

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Lazaro Garcia"
Дата:
Сообщение: Re: [ADMIN] repmgr error with automated failover
Следующее
От: Feike Steenbergen
Дата:
Сообщение: Re: [ADMIN] Req. for some help with temp tables