RDS restore from S3 for MySQL with xtrabackup - stuck creating

0

Hello, I have an xtrabackup of a MySQL 5.7 server in s3 (approx 250gb uncompressed). I've created an RDS instance using Restore from S3 and it's currently stuck in "Creating" status for at least 6+ hours. The mysql error log doesn't give me any clues other than it seems to work and one of the last lines says it's ready for connections. The last event on the other hand says DB Instance Shutdown. Any ideas on why it keeps shutting down or why it's stuck in creating? Is there any other way to get insights on what's happening with the RDS instance?

Liem
已提問 1 年前檢視次數 320 次
1 個回答
0

Hello, I'm Seungwon, the support engineer answering you with RDS issue.

I regret to inform you that I am unable to provide an exact root cause analysis for your inquiry. Because, I can’t accesses your resources. So, I can only offer responses based on general possibilities. Your understanding in this matter is greatly appreciated.

First of all you need to check below limitations.

[+] Restoring a backup into a MySQL DB instance - Limitations and recommendations for importing backup files from Amazon S3 to Amazon RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.html#MySQL.Procedural.Importing.Limitations

In some cases, if there is an existing user in the previous database backup with the same name as the M'aster user of the current RDS instance being created, it can possible to failures.

I hope that you found this information useful and the services mentioned above are suitable for your requirements and specific use-cases.

If further precise analysis and root cause identification are required, I recommend considering enrollment in an AWS Support Plan.

This will ensure that an appropriate engineer is assigned to your case, enabling you to obtain the desired resolution.

[+] AWS Support Plan - https://aws.amazon.com/premiumsupport/plans/?nc1=h_ls

profile pictureAWS
支援工程師
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南