CODEWITHSUNDEEP
mysqlamazon-rdsamazon-aurora
Mayur Patel
Mayur Patel

Reputation: 789

Aurora MySql DB backup size increased drastically

I am running Aurora MySql Engine version 5.6.10a in the production environment. Automated DB snapshot size on 9th May was 120 GB and this snapshot size increased by 27 GB to 147 GB. I have checked that DB size did not increase even by 1 GB. I looked on the internet for the reason why this happened but got nothing.

Graph for snapshot size for the last two weeks as:

enter image description here

It's pretty consistent till 9th May and after 10th May. Does anyone have insight into this issue?

The rate of increase in DB size:

enter image description here

VolumeBytesUsed Graph: enter image description here

Your help will be much appreciated!!

Thanks, Mayurkumar

Upvotes: 2

Views: 1125

Answers (2)

Aman Jhaginia
Aman Jhaginia

Reputation: 11

There is bug in aurora storage provisioning , we have also faced the same issue for one of our client. In our case the storage grew from 17gb to 22000 gb in 15 days where db size was just 16gb. We were charged a lot for that period , you can connect to aws support for the resolution of this problem.

Upvotes: 1

The-Big-K
The-Big-K

Reputation: 2830

How were you checking you snapshot size? One possibility is that may have configured daily backups or so, which might be the reason why your total backup size is growing. Would love to help out more if you can provide more details on the number of snapshots, how you were checking the size of the cluster and the snapshot etc.

Upvotes: 0

Related Questions