AWS Database Blog

Category: Amazon RDS

Monitor Amazon Aurora MySQL, Amazon RDS for MySQL and MariaDB logs with Amazon CloudWatch

NEW! Amazon Aurora with MySQL compatibility now supports publishing of all logs to CloudWatch Logs using the process described below. Amazon RDS has long offered customers the ability to view and download logs associated with their DB instances for troubleshooting purposes. Now, with Amazon Relational Database Service (Amazon RDS) for MySQL and Amazon RDS for […]

Read More

Best Practices for Upgrading Amazon RDS for MySQL and Amazon RDS for MariaDB

One key feature of Amazon RDS is that you can easily upgrade a database instance to a new minor or major version of your database engine. You can perform upgrades on demand by using the AWS Management Console or AWS CLI. You can decide to automatically upgrade to a new minor engine version when it […]

Read More

Client-Side Encryption and Decryption of Microsoft SQL Server Backups for Use with Amazon RDS

This blog post walks you through how to securely encrypt a Microsoft SQL Server backup file and restore the encrypted backup to an Amazon RDS for SQL Server instance. You perform this process using Amazon Simple Storage Service (Amazon S3) and AWS Key Management Service (AWS KMS). This post details the encryption and steps required […]

Read More

Australia Finance Group’s Journey to Cloud Databases

Australia Finance Group (AFG) is one of the largest mortgage aggregators in Australia, according to the Mortgage and Finance Association of Australia. AFG migrated their Oracle Siebel Customer Relationship Management (CRM) application to a managed database with Amazon RDS for Oracle. In this blog post, we describe their approach to migrating the database from Oracle […]

Read More

Amazon RDS Under the Hood: Multi-AZ

Amazon Web Services (AWS) customers bet their businesses on their data store and highly available access to it. For these customers, Multi-AZ configurations provide an easy-to-use solution for high availability (HA). When you enable Multi-AZ, Amazon Relational Database Service (Amazon RDS) maintains a redundant and consistent standby copy of your data. If you encounter problems […]

Read More

Part 2 – Role of the DBA When Moving to Amazon RDS: Automation

In Part 1 of this blog series, I talked about how Amazon Relational Database Service (Amazon RDS) can help change the focus of your role as a database administrator (DBA) from routine, time-consuming tasks to project work that helps the business move faster. In this post, I discuss how you can push that advantage one step further and use AWS tools to do more through automation. An important aspect of being an effective DBA when your business is running at top speed is using code and automation whenever you can. AWS provides tools for you to make this easier.

Read More

Part 1 – Role of the DBA When Moving to Amazon RDS: Responsibilities

This blog post is the first in a two-part series. In this first post, we discuss how moving to Amazon Relational Database Service (Amazon RDS) can change your role as a traditional DBA and bring more value to you, the business, key projects, and end users. In the next post, we will discuss how to use other AWS products to automate any remaining regular tasks in Amazon RDS.

Read More

Replicating Amazon EC2 or On-Premises SQL Server to Amazon RDS for SQL Server

Amazon RDS for SQL Server is a managed Microsoft SQL Server database service that makes it easy to set up, operate, and scale SQL Server deployments in the cloud. Amazon RDS takes away the time-consuming database administration activities so that you can focus on your schema design, query construction, query optimization, and building your application. […]

Read More

Migrating a SQL Server Database to a MySQL-Compatible Database Engine

This post provides an overview of how you can migrate your Microsoft SQL Server database to a MySQL-compatible database engine such as Amazon RDS for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL. The following are the two main parts of a database migration: Schema conversion: Converting the schema objects is usually the most […]

Read More
SQL

Testing Amazon RDS for Oracle: Plotting Latency and IOPS for OLTP I/O Pattern

Kevin Closson is a principal specialist solutions architect at Amazon Web Services. At Amazon Web Services (AWS), we take the Amazon Leadership Principles to heart. One such principle is that leaders Earn Trust. Although this principle guides how leaders should act, I like to extend the idea into how we can help customers enjoy more […]

Read More