In Compass, I saved the connection details for the Sandbox cluster as instructed. It worked for a few days and then I started getting an error message. I figured out that the primary node had changed. I thought maybe it was a one time thing but it keeps changing and when I load the connection details, I have to check the server string to make sure that what is saved in Compass is still the same as the primary listed in Atlas.
I assume the primary can’t be written to for some reason so the primary designation is being switched to a secondary server. Is this correct? Is there a way to check which server is primary programmatically when trying to connect automatically?