Making backups and off-boarding of EC2 instances and a RDS

Question

Hi all, my company has been running a single page questionnaire/registering website for one of our services. For this, AWS was chosen to host the website and database.

All good so far anyway, it's been working absolutely fantastic! Now, a time has come up where the questionnaire isn't very relevant anymore and we would like to make a backup of all database information, and the website runs on the ec2 instances. I am pretty new to AWS as, unfortunately, a previous person in my position set this up who had better understanding of this platform.

The interface to AWS can be a bit confusing to me as a beginner, I really just need to make backups and turn off the instances so costs can be reduced but do not know where to go and what to do. Any help available?

Answer

Since you did not specify what database engine it is, I will hazard a guess and assume its either MySql or PostgreSQL, 
For Mysql all you need to do is take a backup using mysqldump  and then copy it to S3 or download it onto your corporate network for long term  storage. 
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

Similarly for PostgreSQL, you can use pgdump 
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

and if you search online, you will find multiple examples of how to use both of these utilities. 
If your database in neither MySql nor PG, please update your DB engine and similar steps can be made suggested for that db engine.

Answer

If I understand correctly you are referring to stopping db instance with instance backup for added safety.

you can refer to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html

Another good website is https://www.mssqltips.com/sqlservertip/5503/how-to-save-costs-on-nonproduction-sql-server-rds-instances/ but the feature not limited to sql server instances.

Making backups and off-boarding of EC2 instances and a RDS

相關內容