We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy:
Backup Type: Full Backup Server : MySQL 5.5 Backup Tool: mysqldump Interval: Every 24 hours. Data size at present : 2 TB.
Actually we are in need to store the back up of 13 months but we have only 2 months. The data is growing around 6% in every month. We are running out of Storage.
Recently, we thought of moving into mysql incremental backup. The decided plan is we need to run full backup on every week interval and incremental backup at every 24 hours.
Our main concern is storage, since our data is growing every month, I need to know the answer for following questions.
- What is the best possible solution for backup and storing the data considering our situation?
- Whether the incremental backup strategy will solve our storage issue?
- Is there any other better way to handle this situation?
Any suggestions welcome, thank you in advance.