Is the communication between primary and active secondary secured and how it works

63 views Asked by At

Premium service tier of Azure SQL database provides active geo replication due which upto 4 readable secondaries can be created. I want to know if the communication between primary and secondary database is secure and are there any chances of data being hacked in the transit?

1

There are 1 answers

0
t_yamatoya On

For more infomation:Azure SQL Database Inside#High Availability

First, a transaction is not considered to be committed unless the primary replica and at least one secondary replica can confirm that the transaction log records were successfully written to disk. Second, if both a primary replica and a secondary replica must report success, small failures that might not prevent a transaction from committing but that might point to a growing problem can be detected.