Suppose we have a cluster composed of 3 SQL Servers. The Loadbalance Type is Dynamic, and let’s assume no transparent cache in this scenario:
A – Read + Write (1 ‘Movies’ db)
B – Read Only (1 ‘Movies’ db)
C – Read Only (1 ‘Movies’ db)
The app submits a call to the ScaleArc VIP for the stored procedure ‘GetMovie’
The stored procedure only exists on server A because it was dropped for some reason from B and C.
What happens if the call is directed to B or C? Would a standard SQL Server ‘object not found’ error message be returned or is ScaleArc ‘smart enough’ to re-direct the call to A?
No, the query will not be reissued to a different SQL Server.