July 16, 2018 at 3:04 pm
I have an instance with Always ON and two replicas, one of primary and one of secondary. I have created another instance and enabled Always On, each group located in different instances has a different listener with IP and different port. For the first case the listener works well, that is, it connects to the primary replica, and when the failover is done it behaves well. For the case of the second listener, I do not know why to try to connect through this, I am connecting to the group-instance of the first listener, someone has any ideas ??. For the second case, the replicas are fine, synchronized, the problem is that the listener does not connect where it should.
Thanks
July 16, 2018 at 4:16 pm
andres50289 - Monday, July 16, 2018 3:04 PMI have an instance with Always ON and two replicas, one of primary and one of secondary. I have created another instance and enabled Always On, each group located in different instances has a different listener with IP and different port. For the first case the listener works well, that is, it connects to the primary replica, and when the failover is done it behaves well. For the case of the second listener, I do not know why to try to connect through this, I am connecting to the group-instance of the first listener, someone has any ideas ??. For the second case, the replicas are fine, synchronized, the problem is that the listener does not connect where it should.
Thanks
You can connect to either the primary or a replica using the AG listener or directly to an instance. For secondary replica connections using the AG listener, refer to the following:
Listeners, Client Connectivity, Application Failover
There is a section Using a Listener to Connect to a Read-Only Secondary Replica (Read-Only Routing) which should help.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply