Grouper Developers Forum

[Rahul Doshi <>]

Thank you for pointing me in right direction.  We are planning to use MySQL cluster and MySQL jdbc driver also has ability to specify something similar.  Hopefully that works.

Thanks,

Rahul

From: Chris Hyzer <>
Date: Wednesday, July 11, 2012 9:26 AM
To: Rahul Doshi <>, "" <>
Subject: RE: database failover

There is nothing in the Grouper code to do this.  But there are drivers / connect strings which can do this e.g. Oracle.  What database are you using?  If Oracle, are you familiar with the connect strings that accomplish this?  E.g. we use something like this:

 

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=grouper1.school.edu)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=grouper2.school.edu)(PORT=1521)))(CONNECT_DATA=(SID=thesid)))

 

Thanks,

Chris

 

From: [] On Behalf Of Rahul Doshi
Sent: Tuesday, July 10, 2012 5:03 PM
To:
Subject: [grouper-dev] database failover

 

Hello,

 

Is it possible to configure grouper for database failover?  Basically if primary database goes down, grouper automatically switches to using secondary/backup database?

 

Thanks,

Rahul