认识
Amazon RDS for MySQL | Easy to manage relational databases optimized for total cost of ownership
MySQL is the world’s most popular open source relational database and Amazon RDS makes it easier to set up, operate, and scale MySQL deployments in the cloud. With Amazon RDS, you can deploy scalable MySQL servers in minutes with cost-efficient and resizable hardware capacity.
Amazon RDS for MySQL frees you up to focus on application development by managing time-consuming database administration tasks, including backups, upgrades, software patching, performance improvements, monitoring, scaling, and replication.
Amazon RDS supports MySQL Community Edition versions 8.4 and 8.0, which means that the code, applications, and tools you already use today can be used with Amazon RDS.
官网:https://aws.amazon.com/rds/mysql/
文档:https://docs.aws.amazon.com/rds/
仓库:
组成
WIP
构造
安全组
postgresql – Change security group on AWS RDS Database Instance – Stack Overflow
Modify the default security group,
or Create a new security group (as your have done), then go to the RDS console, click on your database, then choose Instance actions -> Modify and modify the security groups that are associated with the DB instance (add the new security group, remove the default security group)
修改参数
https://repost.aws/knowledge-center/rds-change-time-zone
- 创建参数组 Parameter groups
- 复制 default 参数组,并修改相关参数;
- 修改数据库,使用该新的参数组(可能需要重启);
For a DB instance that runs RDS for MySQL version 5.5, 5.6, 5.7, or 8.0, set the time_zone parameter in the DB parameter group. All DB instances and read replicas that use the parameter group update to the new time zone. For RDS for MySQL versions that are earlier than 5.5, you can’t change the time zone. By default, the time zone for RDS for MySQL DB instances is UTC. For more information, see Local time zone for MySQL DB instances.
Local time zone for MySQL DB instances | https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.LocalTimeZone.html
数据备份
https://repost.aws/questions/QUikB5aNeIQbOumr77AnnR0w/rds-snapshot-vs-automated-backups
https://repost.aws/questions/QU1dQD1sLfQ-KQSQEw8MBY8A/what-is-the-difference-between-rds-snapshots-rds-automated-backups-and-rds-auto-replicated-backups
Automated Backups | deal for hands-off, regular backups with point-in-time recovery.
- BACKUP: Automated Backups are automatically taken by RDS on a daily basis during a specified backup window.
- RESTORE: Automated Backups allow you to perform a point-in-time recovery, restoring your DB instance to any second during the retention period.
- Retention: Automated Backups are retained for a specified retention period (default is 7 days, up to 35 days).
Manual Snapshots | Best for on-demand backups with more control over timing and indefinite retention.
- BACKUP: RDS Snapshots are user-initiated, manual backups of your DB instance at a specific point in time.
- RESTORE: RDS Snapshots can be used to restore your DB instance to the exact state captured in the snapshot.
- Retention: RDS Snapshots are retained until you manually delete them.
RDS Auto Replicated Backups
- Automated backups replicated to another AWS region
- Provide cross-region disaster recovery capabilities
- Use the same retention period as the source region’s automated backups
权限管理
授予 ALL PRIVILEGES 权限:
- 针对 RDS 环境,其不允许 *.* 授权;
- GRANT ALL PRIVILEGES ON `%`.* TO ‘myuser’@’host’;
- https://serverfault.com/questions/961301
Master user account privileges | https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html
Role-based privilege model for RDS for MySQL | https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.CommonDBATasks.privilege-model.html
性质
—— 该“性质”指 Aurora and RDS MySQL 在数据存储方面展现出来的功能,而针对权限管理、访问控制、……,我们将其视为“组成”,而非“性质”。
该部分将讨论 Aurora and RDS MySQL 特有的性质,该部分不再讨论与 MySQL 相同的性质。