Thread: High Availability Cluster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello.
I need to set up a high availability cluster with two servers. I have
looked for the best configuration I could use but I cannot find
anything I like. I cannot used the DRBD option and I have to use
Ubuntu 14.04 as OS.
In the past I have set up some clusters using the replication of
Postgresql 9.3. I put one node as master and one node as an hot
standby replication. To complete the installation I have configured
Heartbeat + Pacemaker in order to manage the relocation of the virtual
IP used by the master node and the relocation from the master to the
slave instance of Postgresql.

I was wondering if there is another way to set up a complete cluster
that would manage in case of failure:

* the relocation of the VIP (virtual ip address)
* the relocation of the main instance of Postgresql

Best Regards,
Maila Fatticcioni
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlR3CkgACgkQi2q3wPb3FcNKWACgqfpq7+z7h7qK3z2+H9Qg4Cdw
KWkAn0e1cjtVshTTRYt2GEtt5Wa4FRfz
=5ea1
-----END PGP SIGNATURE-----

Maila Fatticcioni <mfatticcioni@mbigroup.it> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello.
> I need to set up a high availability cluster with two servers. I have
> looked for the best configuration I could use but I cannot find
> anything I like. I cannot used the DRBD option and I have to use
>
> I was wondering if there is another way to set up a complete cluster
> that would manage in case of failure:
>
> * the relocation of the VIP (virtual ip address)
> * the relocation of the main instance of Postgresql
>
> Best Regards,
> Maila Fatticcioni

Why not DRBD & Pacemaker?


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/27/2014 12:34 PM, Andreas Kretschmer wrote:
> Maila Fatticcioni <mfatticcioni@mbigroup.it> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
>>
>> Hello. I need to set up a high availability cluster with two
>> servers. I have looked for the best configuration I could use but
>> I cannot find anything I like. I cannot used the DRBD option and
>> I have to use
>>
>> I was wondering if there is another way to set up a complete
>> cluster that would manage in case of failure:
>>
>> * the relocation of the VIP (virtual ip address) * the relocation
>> of the main instance of Postgresql
>>
>> Best Regards, Maila Fatticcioni
>
> Why not DRBD & Pacemaker?
>
>
> Andreas
>

We would prefer to not use DRBD to speed up the performance.
Is there any other available solution?

Maila

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlR3UlMACgkQi2q3wPb3FcNA9gCfd/veNBuNkmPSIbjdkHqeRdgK
CDMAoLul8+oO6CI9L9/7uCMlblLab9qP
=9OrT
-----END PGP SIGNATURE-----

> On Thu, Nov 27, 2014 at 7:26 PM, Maila Fatticcioni <mfatticcioni@mbigroup.it
>> wrote:
> 
>> I was wondering if there is another way to set up a complete cluster
>> that would manage in case of failure:
>>
>> * the relocation of the VIP (virtual ip address)
>> * the relocation of the main instance of Postgresql
>>
> 
> ​Consider trying pgpool. It has an HA mode (and I think the latest version
> works using a heartbeat, the older one uses watchdog).

No. Just the implementation of watchdog has been changed (more
precisely new life check mode added). In recent versions (since 3.3)
it uses UDP packet for life check of pgpool, which is pretty much
similar to heartbeat.

> If you are up for a commercial product, you may want to consider using
> something like EnterpriseDB's failover manager.

Commercial support for pgpool-II is provided by the way.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp