Re: Postgresql high available solution

Поиск
Список
Период
Сортировка
От salah jubeh
Тема Re: Postgresql high available solution
Дата
Msg-id 1351094657.82233.YahooMailNeo@web122205.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Postgresql high available solution  (Mino Haluz <mino.haluz@gmail.com>)
Список pgsql-general
Hello,

I think you might need to have a look on a binary replication and Pgpool ii

Regards



From: Mino Haluz <mino.haluz@gmail.com>
To: pgsql-general@postgresql.org
Sent: Wednesday, October 24, 2012 2:28 PM
Subject: [GENERAL] Postgresql high available solution

Hi,

we would like to switch from mysql cluster to postgresql. We need high
available solution so we can store telco data for our PBXes. The
problem is, we dont know what would best suit to our needs, we need:

1) High availability with failover - if one node goes down, nothing
bad happens (<5sec downtime)
2) Load balancing (actually we have 90% SELECTs and 10% update+insert)
3) No query based replication (we often use current_timestamp(), now
and other functions which could generate different values on different
nodes), this can be problem with query replication, is that true?
4) GUI for administration

What replication software or other tools would you recommend for this
setup? Or do you know some professional (or company) which could help
us to deploy such system?

Thanks,
Mino Haluz


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


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

Предыдущее
От: Steve Litt
Дата:
Сообщение: Re: Need sql to pull data from terribly architected table
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Plug-pull testing worked, diskchecker.pl failed