Parallel Database for CLM
Hi,
We want to have a parallel database server for CLM so that if something goes wrong with our primary Database we can easily point CLM application to parallel database thereby reducing overall downtime.
How can we achieve his? As data will be added daily to primary database how this newly added data will be synchronised with Second Database server.
What are the Pro's and Cons of having two parallel databases?
Thanks in Advance!
One answer
Hi Amit,
You probably want to read this page about CLM and High Availability before jumping to a database cluster.
Approaches to implementing high availability and disaster recovery for Rational Jazz environments
https://jazz.net/wiki/bin/view/Deployment/ApproachesToImplementingHAAndDR
If you search for DB2 clustering, you find quite a few articles about how to set-up parallel databases and you will learn how DB2 will synchronise they two databases automatically.
There a RedBook that goes into all the details you need:
http://www.redbooks.ibm.com/abstracts/SG246376.html
Enjoy, Simon
You probably want to read this page about CLM and High Availability before jumping to a database cluster.
Approaches to implementing high availability and disaster recovery for Rational Jazz environments
https://jazz.net/wiki/bin/view/Deployment/ApproachesToImplementingHAAndDR
If you search for DB2 clustering, you find quite a few articles about how to set-up parallel databases and you will learn how DB2 will synchronise they two databases automatically.
There a RedBook that goes into all the details you need:
http://www.redbooks.ibm.com/abstracts/SG246376.html
Enjoy, Simon
Comments
Hi Simon,
Thanks for the details.
We use SQL server 2008 as a database. In case of SQL can we setup parallel databases and how sql will synchronise two databases automatically?
Hi Amit,
I'm not an expert in SQL server, however I suggest you start with this document on Microsoft's web site:
High Availability Solutions Overview
https://msdn.microsoft.com/en-us/library/ms190202%28v=sql.105%29.aspx
It states that "A SQL Server failover cluster instance appears on the network as a single computer, but has functionality that provides failover from one node to another if the current node becomes unavailable." So the database appears as a single server to RTC which probably means you do not have to modify anything in RTC for it to work.
It does go on to say that "A failover cluster does not protect against disk failure." so you will need to find a solution for this possible error condition as well.