Last post Oct 11, 2017 07:20 PM by Nighthawk0712
Oct 05, 2017 12:28 PM|Nighthawk0712|LINK
I know this is off topic here, but can anyone point to any good documentation on Mirroring. I have it set up and running. I am looking on more information that tells me how to set up an application to use either db.
Any help is always appreciated. Sorry if this should not be discussed here.
Oct 05, 2017 01:13 PM|Lannie|LINK
You have to designate one server as the receiver of data changes, and the other is just a background standby copy of all changes in case of failure of the primary server.
Now you can switch (role witching) the designation of which server is the master and which one gets the mirror copy, but it is not something where you can write to both at the same time and expect synchronized copies on both.
Oct 05, 2017 02:47 PM|Nighthawk0712|LINK
Thank you for the reply. Is there any good documentation out there that you can recommend?
Oct 05, 2017 07:30 PM|Lannie|LINK
In Oracle the similar functionality is called Data Guard.
Oct 11, 2017 07:20 PM|Nighthawk0712|LINK
Thank you for the link. It was very helpful.