Thanks a lot for your detailed explanation. This forum helped me a lot!
Original Message:
Sent: Thu February 22, 2024 05:30 AM
From: Chris Dudley
Subject: Analytics data synchronization between two data center
Analytics holds data on a scale incomparable to portal and management. We are very unlikely to ever support replication at the database level across datacenters.
To answer your questions:
1. I dont think you are quite asking the right question there, but I will answer what you wrote - yes you can have 6 analytics subsystems in a single cluster. No they will not replicate anywhere and if that cluster goes offline you lose the lot.
2. No it definitely cannot do database level replication and it is very unlikely to ever be able to do so. bi-directional replication of a database that is handling 1000s TPS? Thats simply not realistic, so no thats not possible.
3. Not a chance.
4. :
I think your only real option here is to have an independent analytics service in each datacenter, and have the gateway service in each datacenter associated with its local analytics service. Then make add offload from each analytics service to the other one. You would need to add a filter to make sure that it only forwards on events from the local gateway service in order to avoid sending the same data round and round in circles. But that would then give you all data in both datacenters.
The downside is that each analytics system will likely need to be of a larger size to handle the scale.
Summary data is generated based off the locally stored event data, that is the only means of doing so - it cannot be replicated or created by any other means.
Note the above peer to peer replication via ingestion to ingestion offload is an idea we have had on the backlog for a while but noone has asked for it so it is not a scenario we have ever actually tested or documented. You're welcome to give it a go but I cannot promise that it will either work or be supported. It is however your best (and possibly only) option other than make both services offload to an external server. Feel free to raise an RFE if you would like us to test and document and formally support this pattern.
Cheers,
Chris
------------------------------
Chris Dudley
Original Message:
Sent: Wed February 21, 2024 08:13 AM
From: Guo Jun Qiao
Subject: Analytics data synchronization between two data center
Hi
Previously I asked this question in this form. Now just want to have a further check about analytics data replication between two data centers.
We are using API Connect 10.0.5 VMware setup. We have below requirements regarding the analytics data replication.
- Analytics data will not be offloaded to 3rd party system.
- Replicate analytics data between data center 1 and data center 2.
I know that out of box the APIC cannot replicate analytics data between two data centers. However this is the requirement and it cannot change. So I am just want to check if there are any workaround to replicate analytics data between two data centers. I am thinking below options:
- Can we put below 6 Analytics subsystems into one cluster? If can, will analytics data replicate between two data centers?
- Since analytics database is bundled together with application, I am not sure if can do data replication at database level?
- Is there any way we can use third party solution to sync analytics data between two data centers?
- any other possible workarounds?
I understand that analytics data categories to 1. Analytics API event records and 2. Summary analytics data (refer to section Retention and rollover of analytics data in below URL). The Analytics API event records size is big and may not able to replication. How about Summary analytics data, it also cannot replicate between two data center?
https://www.ibm.com/docs/en/api-connect/10.0.x?topic=usage-key-concepts-api-connect-analytics

------------------------------
Guo Jun Qiao
------------------------------