| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | "Athanasios | ZenGuard" <athanasios(at)zenguard(dot)org> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Master-slave failover question |
| Date: | 2014-01-06 20:53:33 |
| Message-ID: | CAL_0b1s8rrd8WxV_6rtng5e1y4OdTB7C6xs9z9aEHBR0XoA_Kg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, Jan 3, 2014 at 3:18 AM, Athanasios | ZenGuard
<athanasios(at)zenguard(dot)org> wrote:
> Dear list,
> I hope that everyone has a nice holiday. Currently, I am researching
> master-slave automated promotion. I have one question. Let's assume that the
> clients connect to the master 192.168.1.1 for read/write traffic and I have
> a slave at 192.168.1.2. Assume that the master goes down and that slave gets
> promoted to a slave (this I have found out how to do automatically). How
> will the clients know to connect to the new master? Any ideas on this one?
One of the ideas, and BTW my favorite method, is to use PgBouncer to
redirect queries from master to slave with pause. The full description
of the process is by the link below.
https://github.com/grayhemp/pgcookbook/blob/master/switching_to_another_server_with_pgbouncer.md
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pagett, Lacey | 2014-01-06 23:35:08 | 0FATAL: too many connections for database |
| Previous Message | Andreas Kretschmer | 2014-01-06 19:38:03 | Re: how to add 'time with time zone' data types and 'interval' data types |