I've been playing with AWS EC2 and really like it. There is one drawback though, the instance could disappear due to hardware failure or whatever reason. This happened to me in my first week of operation. I was wondering whether there are good solutions to backup a MySQL database so that I don't lose my customer credentials?
我一直在使用AWS EC2，并且非常喜欢它。但是有一个缺点，由于硬件故障或其他原因，实例可能会消失。这发生在我手术的第一周。我想知道是否有好的解决方案来备份MySQL数据库，这样我就不会丢失客户凭证了。
2 个解决方案
#1
5
You can transfer mysql database directly from EC2 machine to S3bucket but you will consume more cost for bandwidth and storage. You go for a third party application (which is safe) to backup your mysql or any plugins. Because they compress your data & encrypt and then save in S3 storage. Also, you can enable snap shot and take snap shots for volumes (hard drives)
您可以将mysql数据库直接从EC2机器转移到S3bucket，但是您将消耗更多的带宽和存储成本。您可以使用第三方应用程序(这是安全的)来备份您的mysql或任何插件。因为它们压缩数据和加密，然后保存在S3存储中。此外，您还可以为卷(硬盘)启用快照和快照
I suggest you to use 'StoreGrid' backup software to backup your mysql database in EC2 machine. check this following link to know more about Online Backup Service on Amazon EC2/S3 http://storegrid.vembu.com/online-backup/amazon-ec2-s3-cloud-online-backup.php
我建议您使用“StoreGrid”备份软件在EC2机器上备份您的mysql数据库。查看以下链接了解更多关于Amazon EC2/S3的在线备份服务http://storegrid.vembu.com/online-backup/amazon- EC2 - S3 cloud- Online -backup.php
Check this following link to configure MySQL database BACKUP http://storegrid.vembu.com/online-backup/mysql-backup.php?ct=1
查看以下链接，配置MySQL数据库备份http://storegrid.vembu.com/online-backup/mysql-backup.php?
Note: You have mentioned Hardware failure occurs often ! --- you can backup entire hard drives too using the above software.
注意:您提到硬件故障经常发生!---你可以使用上面的软件备份整个硬盘。
I hope, now your MySQL data base is backed up from EC2 instance and stored in S3 storage safely.
我希望，现在您的MySQL数据库已经从EC2实例中备份并安全地存储在S3存储中。
Cheers !
干杯!
#2
3
Amazon now offers Relational Database Storage, that is, pre-configured EC2 instances, without any OS access to host MySQL (or Oracle, or T-SQL for real) for you, but aim to solve much of the availability, reliability and durability issues one faces when trying to host transactional data store yourself on a bare EC2 instance.
亚马逊现在提供了关系数据库存储,预配置EC2实例,没有任何操作系统访问主机MySQL(真实或Oracle或t - sql),但旨在解决大部分的可用性、可靠性和耐久性问题一脸当试图主机事务性数据存储自己裸露的EC2实例。
http://aws.amazon.com/rds/
"automated backups, DB snapshots, automatic host replacement, and Multi-AZ deployments"
“自动备份、DB快照、自动主机替换和多az部署”
#1
5
You can transfer mysql database directly from EC2 machine to S3bucket but you will consume more cost for bandwidth and storage. You go for a third party application (which is safe) to backup your mysql or any plugins. Because they compress your data & encrypt and then save in S3 storage. Also, you can enable snap shot and take snap shots for volumes (hard drives)
您可以将mysql数据库直接从EC2机器转移到S3bucket，但是您将消耗更多的带宽和存储成本。您可以使用第三方应用程序(这是安全的)来备份您的mysql或任何插件。因为它们压缩数据和加密，然后保存在S3存储中。此外，您还可以为卷(硬盘)启用快照和快照
I suggest you to use 'StoreGrid' backup software to backup your mysql database in EC2 machine. check this following link to know more about Online Backup Service on Amazon EC2/S3 http://storegrid.vembu.com/online-backup/amazon-ec2-s3-cloud-online-backup.php
我建议您使用“StoreGrid”备份软件在EC2机器上备份您的mysql数据库。查看以下链接了解更多关于Amazon EC2/S3的在线备份服务http://storegrid.vembu.com/online-backup/amazon- EC2 - S3 cloud- Online -backup.php
Check this following link to configure MySQL database BACKUP http://storegrid.vembu.com/online-backup/mysql-backup.php?ct=1
查看以下链接，配置MySQL数据库备份http://storegrid.vembu.com/online-backup/mysql-backup.php?
Note: You have mentioned Hardware failure occurs often ! --- you can backup entire hard drives too using the above software.
注意:您提到硬件故障经常发生!---你可以使用上面的软件备份整个硬盘。
I hope, now your MySQL data base is backed up from EC2 instance and stored in S3 storage safely.
我希望，现在您的MySQL数据库已经从EC2实例中备份并安全地存储在S3存储中。
Cheers !
干杯!
#2
3
Amazon now offers Relational Database Storage, that is, pre-configured EC2 instances, without any OS access to host MySQL (or Oracle, or T-SQL for real) for you, but aim to solve much of the availability, reliability and durability issues one faces when trying to host transactional data store yourself on a bare EC2 instance.
亚马逊现在提供了关系数据库存储,预配置EC2实例,没有任何操作系统访问主机MySQL(真实或Oracle或t - sql),但旨在解决大部分的可用性、可靠性和耐久性问题一脸当试图主机事务性数据存储自己裸露的EC2实例。
http://aws.amazon.com/rds/
"automated backups, DB snapshots, automatic host replacement, and Multi-AZ deployments"
“自动备份、DB快照、自动主机替换和多az部署”