My client has a setup as shown below.
AG Group A ---------> Server A (DB--> A) ----> Server B ( DB--> A)
Transactional Rep --> Server A ( DB-->A ) ---> Server C ( DB--> B)
AG Group B ---------> Server C ( DB --> B) ---> Server D ( DB --> B)
where Server A -> Database A is configured for Transactional replication to Server C -> Database B.
The Availabilty Group and replication are configured fine and the publisher is redirected to the Availability Group Listener.
The distributor database is hosted on Server C ( subscriber). To top it all the subscriber is part of another AG group so it has its own secondary AG replica in Server D (Database B).
I know in this situation transaction replication is not required at all as we could open secondary replica for Read within Availability Groups. ( client - disagrees to change).
Question is as follows:
If The Subscriber ( server C) crashes along with the distribution database, what options are available to redirect replication to a new distributor on replica server D ? Assuming both AG are synchronous and can be failed over together.
Your help and advise is much appreciated.