I understand that Aurora doesn't support it. Is there a workaround for
me to do that? Like whether I can download the snapshot to local in
plain sql script format. Then manually restore them to the new
instance?
You can certainly accomplish that by doing the following:
- Restore the snapshot to a new cluster (Cluster B).
- Export the data from that cluster using
pgdump
or mysqldump
depending on the Aurora database engine you are using. I suggest doing this in an EC2 instance in the same VPC.
- Delete Cluster B.
- Drop the database in your original cluster (Cluster A).
- Load all the data from the export into Cluster A.
However, at that point all you have accomplished is that you will have maintained the RDS cluster's endpoint URL. If you design your system to allow changes to the RDS endpoint URL, then it would be much easier for you to simply restore the snapshot to the new cluster, swap the endpoint your application connects to, and delete the old cluster.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…