AWS Database Blog
Category: RDS for MariaDB
Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects
In this post, we focus on working with the features of mysql_fdw PostgreSQL extension on Amazon RDS for PostgreSQL to help manage a large set of data that on an external database scenarios. It enables you to interact with your MySQL database for importing individual/large/selectively number of objects at the schema level and simplifying how we get information about the MySQL/MariaDB schema, to make it easier to ultimately read/write data. We will also provide an introduction to understand query performance on foreign tables.
Using RDS Proxy with Amazon RDS Multi-AZ DB instance deployment to improve planned failover time
In this post, we demonstrate improvements in planned failover downtime of Multi-AZ instance deployment with Amazon RDS Proxy, a result of several optimizations made by RDS. In the event of a failure, Amazon RDS automatically switches the roles of the primary and standby instances and updates the IP address associated with the database’s DNS (hostname). This allows client applications to maintain their connection settings during failover. This process, known as DNS propagation, can take up to 35 seconds to complete. RDS Proxy eliminates the 35 seconds of DNS propagation delay by continuously monitoring both instances, allowing it to bypass DNS propagation. This allows RDS Proxy to deliver a faster failover response for client applications, maximizing availability during failovers.
Troubleshoot Amazon RDS for MySQL and Amazon RDS for MariaDB Errors
In this post, we discuss MySQL or MariaDB errors seen in error logs and application logs related to database, their possible root cause and how to effectively troubleshoot them on Amazon Relational Database Service(Amazon RDS) for MySQL or Amazon Relational Database Service(Amazon RDS) for MariaDB.
Learn how Presence migrated off a monolithic Amazon RDS for MySQL instance, with near-zero downtime, using replication filters
Presence is a leading provider of live therapy and evaluation services for PreK-12 schools throughout the United States. Amazon RDS for MySQL has been a core part of Presence’s data architecture for many years. Presence used RDS read replicas, with replication filtering, to migrate applications from their centralized RDS for MySQL DB instance to dedicated DB instances. This approach allowed them to migrate each service, on its own schedule, with little downtime. In this post, we provide a practical example for migrating using the same method.
Export Amazon RDS for MySQL and MariaDB databases to Amazon S3 using a custom API
As customers are migrating to the AWS Cloud to take advantage of managed database services such as Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL-Compatible Edition, they also look to automate these administrative tasks. This post shows how a DBA or other user with access to a custom API can make MySQL and MariaDB backup requests. It uses Infrastructure as Code (IaC) with the AWS CDK to simplify the deployment.
Enhance database performance with Amazon RDS dedicated log volumes
For those seeking to achieve consistent database transaction performance, Amazon RDS has introduced a new feature: dedicated log volume (DLV). This feature is an additional storage volume specifically for database transaction logs. In this post, we examine common DLV performance benefits, use cases, monitoring capabilities, and the cost of deployment.
Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers
In this post, we show you how to use advanced replication features between MySQL-compatible databases such as Amazon Aurora MySQL-Compatible Edition clusters or Amazon Relational Database Service (Amazon RDS) for MySQL instances. We discuss two replication capabilities in Amazon RDS and Amazon Aurora: multi-source replication and replication filtering. Multi-source replication is supported only in Amazon […]
Trigger an AWS Lambda function from Amazon RDS for MySQL or Amazon RDS for MariaDB using audit logs and Amazon CloudWatch
AWS Lambda is a serverless compute offering that helps you design event-driven architectures. It provides direct integration with multiple AWS services, including Amazon Aurora MySQL-Compatible Edition. In this post, we show you how to invoke Lambda functions from Amazon Relational Databases Service (Amazon RDS) for MySQL and Amazon RDS for MariaDB using Amazon CloudWatch and […]
Migrate from Oracle to Amazon RDS for MySQL, MariaDB or Amazon Aurora MySQL using Oracle GoldenGate
When thinking about modernizing an Oracle Database to an open-source database on AWS, options include Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, Amazon RDS for PostgreSQL, or Amazon Aurora. The choice of target database is usually dependent on three major factors: Database conversion or refactoring efforts The enterprise-wide decision on […]
Powering Amazon RDS with AWS Graviton3: Benchmarks
In April 2023, AWS announced the ability to power Amazon Relational Database Service (Amazon RDS) instances with the AWS Graviton3 processor. AWS Graviton3 was announced in May 2022 and is built using a custom-designed ARM architecture using ARM Neoverse cores, optimized for delivering high performance and energy efficiency. AWS Graviton3 provides up to 25% better […]