- Use the RDS console to force a reboot of the database instance so that the primary server becomes the master server again.
- The server running the .NET utilities is caching the DNS lookup on the database cluster address. Flush the DNS cache of the server and force the C# utilities to open new connections to the database.
- A.NET application will retain the IP address of a connection string until the host machine is rebooted.
- The NET utilities need to change the SQL Server endpoint in the connection strings to read from the secondary database server using a try/catch.
Your database is an RDS instance running SQL Server with Multi-AZ replication and you have several older .NET console utilities that perform database operations every 15 seconds. When the cluster has to switch the primary database server to the secondary AZ, the .NET utilities start to report connection failures to the database although other applications are able to access the database. How do you correct this problem?
ByNeha S
Feb 10, 2022