Are there any examples with read only routing actually being used?
I am able to use SSMS to connect to my availability group and can specify ApplicationIntent=ReadOnly in the connection string and it correctly uses the read only replica to execute queries. Using the same connection string in prisma is executing against the primary for some reason.
Are there any examples with read only routing actually being used? I am able to use SSMS to connect to my availability group and can specify ApplicationIntent=ReadOnly in the connection string and it correctly uses the read only replica to execute queries. Using the same connection string in prisma is executing against the primary for some reason.