September 29, 2015 at 6:53 pm
if for any reason AG fails over to async node, how replication behaves? As data will not be in sync with previous primary replica, how replication will work? I think that we have to reset replication from scratch as there's a high chance subscribers might be more updated than current primary replica as failover to this node causes data loss. Any suggestions on how to keep replication in sync without resetting up? Can we achieve this?
September 30, 2015 at 4:42 am
muthyala_51 (9/29/2015)
if for any reason AG fails over to async node, how replication behaves?
It won't, unless someone does this manually!!
Read my stairway link to HA on this site starting at this link to fully understand this technology
http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]
muthyala_51 (9/29/2015)
As data will not be in sync with previous primary replica, how replication will work? I think that we have to reset replication from scratch as there's a high chance subscribers might be more updated than current primary replica as failover to this node causes data loss. Any suggestions on how to keep replication in sync without resetting up? Can we achieve this?
Replication??
Are you using snapshot, transactional or merge replication as well?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 7:58 am
It's transactional replication. I agree AG will not failover to async node but when we loose all synchronous node and when we have to bring the databases up on async node, at that point does replication will work without any issues?
September 30, 2015 at 9:57 am
if you really want to use replication with AGs start here
https://msdn.microsoft.com/en-us/library/hh710046(v=sql.110).aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 1:15 pm
Perry Whittle (9/30/2015)
if you really want to use replication with AGs start herehttps://msdn.microsoft.com/en-us/library/hh710046(v=sql.110).aspx
Perry,
I already setup AG and replication and everything is working as expected. I am just trying to find if for any reason we loose primary data center and bring up the node on secondary data center, how replication will behave at that point of time? I think i am right in guessing we have to reset replication from scratch as there will be no alternative in order to have data sync in all environments.
October 1, 2015 at 3:06 am
If replication is coming from the primary and you lose the primary, replication will break.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply