问题原文
原帖链接 · irobacsi · CC BY-SA 4.0
Are there any other ways to upload files from an Ubuntu server to AWS s3 without AWS Transfer Family? I have to make a MYSQL dump every five minutes and upload to the bucket but the Transfer Family's hourly price is too high for the client. Can i attach the storage to an EC2 and make an SFTP account on it? The VPS which has the MYSQL is hosted by DigitalOcean.
已采纳解答
原帖链接 · Tim · CC BY-SA 4.0
Install the AWS CLI v2 on your server(s) and use the CLI "aws s3 cp" command to upload the files to S3.
Doing a MySQL dump every give minutes seems excessive. You might be better syncing the MySQL binary / transaction logs to S3 every five minutes using "aws s3 sync" CLI command, then doing a MySQL dump daily. You can use S3 lifecycle policies to delete the transaction logs from S3 after a week or so.
Whichever method you use, make sure you schedule regular restore tests.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
