Looking for some thoughts please on the best way forward to move from a current active-active model to an active-passive model.
Currently we have an active-active model where we have seperate Solarwinds Servers / SQL Database Servers at a Primary and DR Site, with all of our network devices being polled by both sites.
We want to move to an active-passive model using Solarwinds HA so that the Application servers at the DR site are in passive mode awaiting failover.
If we configure it like below we have a HA VIP with the data going to the current ACTIVE Solarwinds Server, followed by a SQL Cluster VIP again going to the current ACTIVE SQL Server.
However it appears that by doing it this way only one of the actual databases will be written to.
This isn't exactly ideal in that the other database at the DR site isn't being written to / updated in any way.
If we were to lose the Primary site we would lose the database also, so we would need to find the best way to replicate the database data to the DR site at the same time to prevent this from happening if possible.
I know that Solarwinds currently don't provide HA support for the Database, but i need to find a way to keep the system functional with the minimum downtime possible in the event that the primary site ever goes down.
In our current active-active setup we have a process whereby we take the latest database backup from our primary site and restore this data to the DR database and make some changes to the database and then run the configuration wizard to point the DR instance to the DR database and we are back in action. The only reason for doing this is that most configuration changes to the database are only done on the primary site. Bad practice i know and double the amount of effort, hence why we want to move to the HA Active-Passive model.
Ideally i would like to be able to do the below but don;t know the best way to achieve this with the least amount of effort.
Maybe it's wishful thinking on my part that the above is actually achievable, if it is then great, i need to figure out how to do it.
If however its not possible then i need to be able to somehow have a working system in the event of the primary site not being available.
Sorry for the long winded post, i appreciate any suggestions / reference docs that may be linked for my reading.
I'm surely not the only one thats wanting to have this kind of setup, others must be doing some sort of HA / DR config and would appreciate any help anyone can offer.
Thanks in advance.