General questions regarding RDS SQL Server Read Replicas

0
  1. Can I stop/resume replication for a RDS SQL Server Read Replica, like we do with on-prem SQL Server?
  2. is there any recommended max db size for a replication to occur smoothly?
  3. is there any recommended max source change rate for a replication to occur smoothly?
1回答
1
承認された回答
  1. No. Read replicas for RDS SQL Server are implemented using the built-in Distributed Availability Groups feature in SQL Server. Read replcias do not use the replication feature provided by Microsoft SQL Server.

  2. Read replicas have the same size limitations as the primary instance in terms of size. A read replica is created from a snapshot of the source instance upon creation and after that it's synchronized asynchronously. Recommendation is to make sure that the source DB instance and its read replicas are sized properly, in terms of computing power and storage, to suit their operational load. As long as you have comparable instance type/size (RAM, CPU) and storage type (EBS volume type and IOPs), synchronization should be smooth. Similar note in the documentation here.

  3. Note that read replicas use asynchronous data movement from the source. So make sure read replicas have similar resources to the primary instance so they can catchup with the rate of change on the primary.

回答済み 4年前
profile picture
エキスパート
レビュー済み 1ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ