Database Flashcards
A company is deploying a MYSQL database on AWS. The database must easily scale and have automatic backup enabled.
Which AWS database service should the company use?
Amazon Aurora
Amazon Aurora is a relational database that is compatible with MYSQL and PostgresSQL database engines. Aurora is extremely fast and scales up with 128 TB. Aurora offers automated backups.
An application uses a Postgress SQL database running on a single Amazon EC2 instance. A Cloud practitioner has been asked to increase the availability of the database so there is automatic recovery in the case of a failure.
Which tasks can the Cloud Practitioner take to meet this requirement?
Migrate the database to Amazon RDS and enable the Multi-AZ feature.
Moving the database to Amazon RDS means that the database can take advantage of the built-in Multi-AZ feature. This feature creates a standby instance in another Availability Zone and synchronously replicates to it. In the event of a failure that affects the primary database an automatic failure can occur and the database will become functional on a standyby instance.
A MySQL and PostgreSQL-compatible relational database built for the cloud that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.
Amazon Aurora -
is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.
What benefits can a company gain by deploying a relational database on RDS INSTEAD OF Amazon EC2?
2 benefits…
On Amazon RDS you get:
- Automated backups
- Software patching
Amazon RDS is a managed service and an EC2 database is a self-managed database.
RDS = less work, easier to use, less flexibility, stream-lined, simplified
EC2 = more work, more flexibility, complete control,
What advantages does a database administrator obtain by using the Amazon Relational Database Service (RDS)?
RDS simplifies relational database administration tasks.
RDS is managed so this reduces the database administration tasks an administrator would normally undertake. The managed service includes hardware provisioning, database setup, patching and backups.
Provides continuous backups of your Dynamo DB table data.
helps protect your DynamoDB tables from accidental write or delete operations.
(accronym)
Point-in-time recovery (PITR)
When enabled, DynamoDB maintains incremental backups of your table for the last 35 days until you explicitly turn it off. It is a customer responsibility to enable PITR on and AWS is responsible for actually performing the backups.
