Hellow Devrim Thank you very much for your response I will first do a test setup and the information you have provided will help me alot so thanks again.
May I contact you my email if I get stuck somewhere ? Regards Terry On 3 December 2012 15:44, Devrim GÜNDÜZ <dev...@gunduz.org> wrote: > On Sun, 2012-12-02 at 01:45 +0500, Terry Khatri wrote: > > > > I need to do the subject setup using PostgreSQL, where when one node > > goes down another takes over without manual intervention, the way it > > is done in Oracle using grid infrastructure and in SQL Server 2012 > > using their Alway-On feature > > This is done using Red Hat Cluster Suite (RHCS). It is the "High > Availability Addon" in Red Hat Enterprise Linux, and I recommend you > (though not strictly required) to use GFS2 along with RHCS > > > My question is, has anyone done that? > > Yes ;) > > > can anyone please help me implement it > > http://www.gunduz.org/download.php?dlid=190 > > has the overview of the infrastructure. Step-by-step installation might > be too long for a mailing list, but the idea is the same as installing > anything under RHCS -- so any tutorial will help you that describes how > to configure a clustered service in RHCS. Please note that this is not > an active-active system as you wrote above, so those clusters won't > apply this. Another tip would be keeping lock file and pid in the shared > storage, not on the local disks. You will need to adjust init scripts > for that, too. There is not too much manual work btw. > > Oh, that reminds me -- RHCS is currently using cman+corosync+rgmanager, > so any solutions with pacemaker will work, but won't be supported by Red > Hat (though AFAIK RHEL 7 will use pacemaker by default) > > Feel free to use luci and ricci for configuring the services, they will > help you a lot. Luci is the web interface for configuring cluster, ricci > is the agent on each node. > > Regards, > -- > Devrim GÜNDÜZ > Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz >