openskills.info
← All skills

Skill map

Platform administration

Operates at least one production database platform deeply. As Database Administrator needs it.

HOWTOs

Concrete operational procedures from the courses on this page.

  • How to migrate a relational database to Amazon RDS or Aurora with DMS at near-zero downtime

    not executable: Needs a billed AWS account with a DMS replication instance, a source database that exposes change capture, and an RDS or Aurora target reachable from that instance. No runner in the fleet has that account. LocalStack does not implement a full-load-and-CDC DMS task a reader can trust as proof of these steps, so nothing here is executed.

    Moving a live relational database onto RDS or Aurora with an AWS DMS full-load-and-CDC task: the schema and index work around the load, the CDC latency gate that decides when a cutover is safe, and the reverse replication path that keeps rollback open.

    AWS Databases

  • How to restore an Amazon RDS or Aurora database to a point in time after data corruption

    not executable: Needs a billed AWS account with an RDS or Aurora source that has automated backups enabled, because restore-db-instance-to-point-in-time and restore-db-cluster-to-point-in-time create a new billed instance beside the source. No runner in the fleet has that account. A local emulator cannot prove real PITR against AWS automated backups, so nothing here is executed.

    Recovering from a bad write by restoring RDS or Aurora point-in-time recovery into a new instance beside the untouched source, validating the restore time, and choosing between a full cutover and a selective repair.

    AWS Databases