Contents
Which of the following Amazon RDS database engines support multi-AZ?
Amazon RDS uses several different technologies to provide failover support. Multi-AZ deployments for MariaDB, MySQL, Oracle, and PostgreSQL DB instances use Amazon’s failover technology. SQL Server DB instances use SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs).
How does the Amazon RDS Multi-AZ model work?
Multi-AZ RDS deployments work by automatically provisioning a standby replica of your database in another availability zone within a region of your choice. Replicas are never created in any region other than the one you’ve chosen in order to keep the latency at a minimum and also due to compliance issues.
What happens when a multi-AZ RDS instance fails?
If a storage volume on your primary instance fails in a Multi-AZ deployment, Amazon RDS automatically initiates a failover to the up-to-date standby (or to a replica in the case of Amazon Aurora). DB Instance failover is fully automatic and requires no administrative intervention.
Where are MySQL database logs stored in Amazon RDS?
Amazon RDS publishes each MySQL database log as a separate database stream in the log group. For example, if you configure the export function to include the slow query log, slow query data is stored in a slow query log stream in the /aws/rds/instance/my_instance/slowquery log group. The error log is enabled by default.
How to retain binary logs in Amazon RDS?
After creating an RDS instance, enable extended retention of binary logs on the host by executing the following command using a SQL client: This command ensures that binary logs are retained for 24 hours on the host after rotation. Otherwise, Amazon RDS automation would purge the log from the host about five minutes after rotation.
Where can I find the MySQL database logs?
You can monitor the MySQL logs directly through the Amazon RDS console, Amazon RDS API, AWS CLI, or AWS SDKs. You can also access MySQL logs by directing the logs to a database table in the main database and querying that table.
How many replicas can I create with Amazon RDS?
One of the key features of Amazon RDS for MySQL and Amazon RDS for MariaDB is the ability to create Read Replicas. You can easily create up to five replicas for a single master database instance via the AWS Management Console or the AWS CLI.