OnDemand User Group

Support Forums => MP Server => Topic started by: Marc on November 29, 2011, 02:17:58 PM

Title: Active/Active CMOD Configuration
Post by: Marc on November 29, 2011, 02:17:58 PM
Does anyone use an active/active configuration, i.e., two physical servers, each running their own CMOD, but sharing the same DB2/TSM storage?

If so, what technologies are you using to handle contention within DB2 ? Contention can be an issue because when a document is retrieved, it causes a write operation to log the activity in the System Log, within DB2. Simultaneous writes to DB2 can cause contention.

We currently use CMOD 8.4.1.4 and DB2 9.5 but plan on moving to CMOD 8.5 and DB2 9.7.
Title: Re: Active/Active CMOD Configuration
Post by: Alessandro Perucchi on November 29, 2011, 11:35:28 PM
Hello Marc,

don't do it, an active/passive is ok, and will be always ok.
But an active/active is, at my knowledge, not supported by CMOD.

Maybe others have other experiences...

Sincerely yours,
Alessandro
Title: Re: Active/Active CMOD Configuration
Post by: Justin Derrick on November 30, 2011, 02:37:06 AM
I can't imagine a design where you have two active CMOD servers sharing a single DB2 database.  That eliminates any benefit you have to running redundant hardware -- which is usually the least likely piece of the architecture to fail, really.

Most active-active architectures are entirely separate.  Different instances, running different databases, storing on different disks, hosted on separate servers, living in separate data centers.

How are you tying these two servers together?

-JD.
Title: Re: Active/Active CMOD Configuration
Post by: Marc on November 30, 2011, 07:44:05 AM
We are currently active/passive on our primary site (two physical servers, each running their own CMOD, but one shared DB2), AND we have redundant hardware on our DR site (also passive, with separate physical server and a second DB2).

We wanted to investigate active/active on our primary site to:
1) reduce the outage during a deployment
2) make use of hardware that is sitting idle (passive)
3) increase throughput of online retrievals

To Justin's point: We have the redundant hardware on DR site.
How would Active/Active with different databases be achieved? CMOD doesn't support replication from one database to another, so to keep the data in sync, I think you would have to load all the data twice, once to each database.
Title: Re: Active/Active CMOD Configuration
Post by: rstockton on November 30, 2011, 12:02:22 PM
We have active/active with each instance having its own CMOD, DB2 and TSM.  The servers are located in different data centers in different cities.  We have a frontend process on a LINUX based server that does load balancing and sends each input file to both instances thus allowing the files to be loaded concurrently.  We switch between servers as maintenance/upgrade is required on each server and our web services switch to the hot active instance as required.

Russell
Title: Re: Active/Active CMOD Configuration
Post by: Justin Derrick on December 01, 2011, 02:44:07 AM
I recommend the configuration that Russell is using. 
Title: Re: Active/Active CMOD Configuration
Post by: ewirtz on December 01, 2011, 03:23:58 AM
Hi,

on Z/OS another combination might work if you have a sysplex and a db2 sharing group.

1. define a virtual IP
2. start ARSSOCKD on both images of the sysplex listening to the virtual IP
3. If ARSSOCKD has implemented a proper rollback / commit logic it shall work

With this technique you would have a simple workload and the system will still work if one image is down. I think it will work, because we are running several ARSLOAD in parallel with direct DB2. This is similar to more than one ARSSOCKD running against the same DB2. But of course IBM should state that it works.

regards

Egon
Title: Re: Active/Active CMOD Configuration
Post by: Marc on December 02, 2011, 02:53:24 PM
For the active/active scenario with each instance having its own CMOD, DB2 and TSM, I don't think Annotations would work.
Annotations are tied to a specific object, so if you were to add an annotation, it would only be in one of the databases. You can't control which of the two objects you retrieve next time, so you may or may not get the Annotation.
Title: Re: Active/Active CMOD Configuration
Post by: Justin Derrick on December 04, 2011, 01:01:22 PM
It's possible to replicate Annotations across sites.
Title: Re: Active/Active CMOD Configuration
Post by: Marc on December 07, 2011, 06:53:38 AM
Justin, can you elaborate on how to replicate annotations?

IBM has said that CMOD does not support replication, so I know it's not done directly by CMOD.
Also, I don't think DB2 HADR can send data both ways.
Title: Re: Active/Active CMOD Configuration
Post by: Justin Derrick on December 08, 2011, 08:26:19 AM
It's been a while since I set this up, but it basically involves setting a series of triggers that find annotations, the record on the opposite machine, and duplicates the annotation.
Title: Re: Active/Active CMOD Configuration
Post by: Faceman on August 10, 2016, 07:37:21 AM
Hello - reviving an old discussion here.  I'm looking for a solution to sync annotations between two data centers.  We have a current home-grown solution but we're looking for a better way. 

Our setup is active/passive for users (who use annotations).  Active/active for internet traffic (no annotations).  Our systems load concurrently to both data centers.  There is no replication with our current setup.

Thanks everyone!
Title: Re: Active/Active CMOD Configuration
Post by: Alessandro Perucchi on August 15, 2016, 03:32:15 AM
As of today, it is not possible. You must use you current setup.

It is possible that this active-active scenario will come to CMOD is a short-medium term future, but until it arrives, you will need to live with the current solution limitation :-/
Title: Re: Active/Active CMOD Configuration
Post by: ewirtz on August 29, 2016, 03:22:46 AM
Hi Marc,

just an additional remark because of new experiences.

We are now using two arssockd and 10 arsload instances on the same machine against the same CMOD database. We don't see any retention problems. At least on Z/OS machines it works fine.

regards

Egon

Title: Re: Active/Active CMOD Configuration
Post by: Alessandro Perucchi on September 08, 2016, 06:52:40 AM
Hi Marc,

just an additional remark because of new experiences.

We are now using two arssockd and 10 arsload instances on the same machine against the same CMOD database. We don't see any retention problems. At least on Z/OS machines it works fine.

regards

Egon

Well that's something that works ONLY on z/OS today... but not yet on MP.
I have heard that they will have it on MP in the future. When in the future I have no idea... but it is coming. I hope not in 10 years.... :-/

So an answer would be, you want active/active with CMOD? Then switch to z/OS !!! :-D
Title: Re: Active/Active CMOD Configuration
Post by: Steve Bechtolt on September 21, 2016, 11:55:09 AM
We are using a Active/Standby HA utilizing HPE ServiceGuard.
We have two identical (CPU, RAM, etc.) servers in a cluster at one site.
All storage (cache, db2, tsm, application) is stored on SAN disks that float
between the nodes of the cluster. 
If there's a hardware failure on the active node, it takes less than 10 minutes to failover to the standby node.
Title: Re: Active/Active CMOD Configuration
Post by: Alessandro Perucchi on September 21, 2016, 04:10:43 PM
We are using a Active/Standby HA utilizing HPE ServiceGuard.
We have two identical (CPU, RAM, etc.) servers in a cluster at one site.
All storage (cache, db2, tsm, application) is stored on SAN disks that float
between the nodes of the cluster. 
If there's a hardware failure on the active node, it takes less than 10 minutes to failover to the standby node.

Nice, setup :-)
but the original question was active/active .
Title: Re: Active/Active CMOD Configuration
Post by: Ed_Arnold on October 20, 2016, 10:50:23 AM
Active/Active is only available on z/OS.

Ed
Title: Re: Active/Active CMOD Configuration
Post by: Ed_Arnold on February 21, 2018, 11:52:16 AM
Active/Active is only available on z/OS.

Ed

No longer true as of CMOD v10.1.

High availability active-active is now available on AIX.

Ed
Title: Re: Active/Active CMOD Configuration
Post by: teeraw on February 22, 2018, 07:13:52 AM
On CMOD 10.1, support Active/Active architecture as this technote:

http://www-01.ibm.com/support/docview.wss?uid=swg27049639