Aurora MySQL Cross-Region Backup Limitations

0

Hello,

We noticed the new post on support for cross-region RDS for MySQL backups here: https://aws.amazon.com/about-aws/whats-new/2023/02/amazon-rds-mysql-dr-capabilities-cross-region-automated-backups/

I am curious about any capability our organization might have to automatically apply continuous cross-region backups for all Aurora clusters on a per-account level for DR purposes. I believe Aurora cross-region replication is a separate and unrelated topic here (docs: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.CrossRegion.html).

It isn't clear whether the post above applies to Aurora MySQL or just RDS for MySQL. A few questions:

  1. Does the blog post apply only to RDS for MySQL or also for Aurora MySQL?

  2. I see the blog post applies to built-in RDS backups. Does it also apply to backups made with AWS Backup?

  3. The AWS Backup "Copy to destination" field "info" tooltip states that backups for RDS still do not support continuous backups for RDS. The blog post seems to say that transaction logs can now be replicated, though. Is the tooltip correct, or out of date?

    AWS Backup "Copy to destination" tooltip

  4. Is there currently any way to do continuous cross-region backups (i.e., with PITR) for all Aurora MySQL clusters at the account level? Again, separate from replication on a per-cluster basis. If not, is there any way to do such backups on a per-cluster level without using replicas?

TIA,

Mike

Mike
preguntada hace un año932 visualizaciones
1 Respuesta
1

1. Does the blog post apply only to RDS for MySQL or also for Aurora MySQL? This post is for RDS MySQL Automated Backups

2. I see the blog post applies to built-in RDS backups. Does it also apply to backups made with AWS Backup? From AWS Backup documentation Destination copies from S3 buckets and RDS databases with PITR are not Point-in-Time restorable (PITR).

3. The AWS Backup "Copy to destination" field "info" tooltip states that backups for RDS still do not support continuous backups for RDS. The blog post seems to say that transaction logs can now be replicated, though. Is the tooltip correct, or out of date? the feature is available on RDS backups, from documentation When backup replication is configured for a DB instance, RDS starts a cross-Region copy of all snapshots and transaction logs when they're ready.

4. Is there currently any way to do continuous cross-region backups (i.e., with PITR) for all Aurora MySQL clusters at the account level? Again, separate from replication on a per-cluster basis. If not, is there any way to do such backups on a per-cluster level without using replicas? Besides the aurora replica, you can create:

AWS
Jorge
respondido hace un año
profile picture
EXPERTO
revisado hace 4 meses
  • Thanks @Jorge. Just to confirm I'm understanding correctly:

    1. Only for RDS for MySQL (not for Aurora MySQL).
    2. No. Cross-region RDS backups through AWS Backup do not support PITR.
    3. The tooltip is still correct since the feature is not for AWS Backup.
    4. (No clarification needed -- thanks for the info.)

    Can you confirm?

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas