question

ramana avatar image
ramana asked

Replication with Always on Availability

Hi,

In which situations we need to have Replication on Always on Availability groups? Always on availability allows read connections on secondary server then why do we need to configure additionally replication?

Thanks,

Ramana

replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

That will depend on requirements.

Maybe you don’t have the money to license an identical replica so you cannot do read only secondaries.

Maybe you don’t have the money to license Enterprise edition so again you cannot do read only secondaries.

Maybe you need to replicate data to a secondary system for latency reasons.

Main OLTP in London, but you have point of presence in Hong Kong, Sidney, Seattle, New York etc, you replicate your the local data centres to stop large latency in all sites accessing London.


Maybe you just don’t want people to use readable secondaries due to potential redo performance problems so you want to keep people out as HA/DR is more important on that system than reporting.


You have centralised reporting data warehouse etc so again you need to replicate data to a DW.


There are many reasons I can think of.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you. I couldn't able to think.

Thanks,

Ramana

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.