SQL Server

Question

Hello,

I would like to request to explain for my confuse problem that I have SQL server DC/DR implementation using distributed availability group. In this DAG, I have two availability group in my DAG, one of AG is hosted in my data center and another AG is hosted in AWS cloud. I configured data movement with synchronous-commit within AG and configured data movement with asynchronous-commit between two AG. So, let me know data movement time between on-prem and AWS cloud using asynchronous-commit. Could you please explain me? Thank you.

Answer 1

Hi Paing,

Hope you're doing well.

Certainly!

1. AWS DataSync is a secure, online service that automates and accelerates moving data between on-premises and AWS storage services. It can copy data between various storage systems, including Network File System shares, Server Message Block shares, Hadoop Distributed File Systems, self-managed object storage, and AWS services like Amazon S3, Amazon EFS, and more.
2. When using asynchronous-commit between your on-premises AG and the AWS-hosted AG, the data movement time depends on several factors:

(1) Network Latency: The time it takes for data to travel over the network between your data center and AWS.

(2) Data Volume: The amount of data being transferred.

(3) Bandwidth: Available network bandwidth for data transfer.

(4) DataSync Configuration: Settings such as throttling, scheduling, and filtering.

3. Best Practices:

(1) Optimize your network connectivity between on-premises and AWS.

(2) Consider using AWS Direct Connect or VPN for dedicated and secure connections.

(3) Configure DataSync with appropriate settings to balance performance and cost.

(4) Regularly monitor and analyze data movement performance.

Remember that actual data movement time can vary based on your specific environment and workload. I recommend testing and benchmarking to get accurate measurements for your scenario.

Best Regards

Answer 2

Hi Xu Gu,

Thank you for explanation.