How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?
Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
Create the maintenance job using the Amazon CloudWatch job scheduling plugin.
Explanations:
Running cron jobs on an EC2 instance introduces the need to manage the instance, including scaling and fault tolerance. This does not provide minimal maintenance or high availability.
Aurora PostgreSQL is a managed service and does not support creating cron jobs directly on the database instance. This would require more management and would not meet the high availability requirement.
AWS Lambda functions are serverless and do not require managing infrastructure. They can be scheduled using Amazon CloudWatch Events, ensuring minimal maintenance and high availability.
Amazon CloudWatch does not have a job scheduling plugin specifically for running database maintenance jobs. CloudWatch is used for monitoring and event management, not for job execution directly.
I would say the answer is:
Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.