Re: Replication mode

The HA & SPOF dependency can be removed completely with help of PostgreSQL
& Pgpool-II design and replace no use of any licensed software components.

We have implemented a very complex HA architecture at one of our customer
using Open Source tools (PostgreSQL/PgpoolII).

--
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com>

On Thu, Jan 11, 2018 at 7:49 AM, Ramesh naik <ramesh(dot)esl(at)gmail(dot)com> wrote:

> Hi Azim,
>
> Pgpool is not of SPOF. You can use watchdog feature in PgPool-II to
> achieve HA.
> I’ve used it before. I didn’t find any difficulties in configuring or
> managing
>
> FYI..
> http://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html
>

> On Thu, 11 Jan 2018 at 9:11 AM, Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
> wrote:
>
>> :-)
>> Our fear is using open source tools for HA creates dependency and
>> single point of failure(pgpool). Or say pacemaker which our enterprise do
>> not recommend.
>> We are planning to use postgres to use for our hadoop metastore which is
>> presently on Oracle.
>>
>>
>> On Jan 10, 2018 6:21 PM, "Mark Kirkwood" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
>> wrote:
>>
>>> On 11/01/18 13:08, Azimuddin Mohammed wrote:
>>>
>>> Thanks mark..
>>>> That does help...
>>>> Our db is not transactional ..it more of write few times read many
>>>> times ..What HA do you recommend for us by not using any open source
>>>> tools...and what could be the best backup startegy...
>>>>
>>>>
>>> Wow - that 'not using any open source tools' restriction pretty much
>>> rules out any options I'd come up with (was that *really* what you meant to
>>> write - Postgres is after all open source too...)?
>>>
>>> regards
>>>
>>> Mark
>>>
>> --
> Regards,
> Ramesh Naik E
>
> +65 8202 7519
>
>