有关 Amazon RDS、S3 存储和默认 RDS 表的基本问题
我刚刚在 Amazon RDS 服务上创建了我的第一个数据库实例。我想知道...
1) 有没有办法让亚马逊自动备份我的数据，即使实例被删除，数据也仍然存在？
2）是否可以在多个实例之间共享表？
3）当我第一次连接到实例时，我发现有三个数据库：我专门创建的、innob和mysql。我应该继续使用我创建的那个还是其他之一？有成本影响吗？
谢谢。
I just created my first database instance on the Amazon RDS service. I was wondering...
1) Is there a way to have Amazon automatically back up my data in a way that it persists even if the instance is deleted?
2) Is it possible to share tables across multiple instances?
3) When I first connected to the instance, I found there were three databases: the one I specifically created, innob, and mysql. Should I continue using the one I created or one of the others? Are there cost implications?
THANK YOU.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
是的，亚马逊可以自动备份您的数据
请参阅此处
此外，还有数据库快照是用户启动的数据库实例备份。数据库快照一直保留到被用户删除为止。请参阅此处。
是的，实例必须位于同一个安全组中。
mysql 运行需要 innodb 和 mysql 表。您应该使用您创建的那个。
Yes, Amazon can automatically backup your data
See here
Also, there are DB snapshots which are are user-initiated backups of a DB Instance. DB Snapshots are retained until they are deleted by the user. See here.
Yes, the instances must be in the same security group.
The innodb and mysql tables are needed for mysql to run. You should use the one you created.
您可以针对 Amazon RDS 使用 MySQl 命令 mysqlimport（导入）和 mysqldump（导出）。 IIRC 导入限制为 1GB
You can use MySQl commands mysqlimport (import) and mysqldump (export) against Amazon RDS. IIRC Imports are limited to 1GB
TFD：导入不限于1GB。但是，aws 建议，如果您导入的数据超过 1g，则应将表与平面文件分开导入，而不是从 mysqldump 整体导入。
http://developer.amazonwebservices.com/connect/entry.jspa?externalID=第2933章
TFD: Imports are not limited to 1GB. However, aws recommends that if you are importing more than 1g, you should import tables separately from flatfiles, rather than monolithically piped in from mysqldump.
http://developer.amazonwebservices.com/connect/entry.jspa?externalID=2933
关于 RDS 的其他一些值得了解的事情
到外部 VPC。
Few other Good to know things about RDS
to outside VPC.