AWS Database Blog
Tag: RDS
Best practices for securing sensitive data in AWS data stores
This blog post focuses on general data security patterns and corresponding AWS security controls that protect your data. Although I mention HAQM RDS and DynamoDB in this post, I plan to cover the implementation-specific details related to HAQM RDS and DynamoDB in two subsequent posts.
HAQM RDS Under the Hood: Single-AZ instance recovery
This post describes HAQM RDS Single-AZ RTO and RPO expectations for MySQL, MariaDB, PostgreSQL, Oracle, and Microsoft SQL Server databases. HAQM Aurora uses a different technology and storage subsystem designed for the cloud. Its single instance recovery process and scenarios are described in the Aurora FAQ.
Client-Side Encryption and Decryption of Microsoft SQL Server Backups for Use with HAQM RDS
This blog post walks you through how to securely encrypt a Microsoft SQL Server backup file and restore the encrypted backup to an HAQM RDS for SQL Server instance. You perform this process using HAQM Simple Storage Service (HAQM S3) and AWS Key Management Service (AWS KMS). This post details the encryption and steps required […]
Australia Finance Group’s Journey to Cloud Databases: Migrating from Oracle Exadata to HAQM RDS
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 HAQM RDS for Oracle. In this blog post, we describe their approach to migrating the database from Oracle […]
Replicating HAQM EC2 or On-Premises SQL Server to HAQM RDS for SQL Server
HAQM 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. HAQM 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. […]
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 HAQM RDS for MySQL, HAQM RDS for MariaDB, or HAQM Aurora MySQL. The following are the two main parts of a database migration: Schema conversion: Converting the schema objects is usually the most […]
Testing HAQM RDS for Oracle: Plotting Latency and IOPS for OLTP I/O Pattern
Kevin Closson is a principal specialist solutions architect at HAQM Web Services. At HAQM Web Services (AWS), we take the HAQM 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 […]
Picking Your First Database to Migrate to HAQM RDS or HAQM Aurora with PostgreSQL-compatibility
David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on-premises and in the cloud. In a previous post, we covered the overall approach you can take to migrate your current […]
Cross-Region Automatic Disaster Recovery on HAQM RDS for Oracle Database Using DB Snapshots and AWS Lambda
Sameer Malik is a specialist solutions architect and Christian Williams is an enterprise solutions architect at HAQM Web Services. Many AWS users are taking advantage of the managed service offerings that are available in the AWS portfolio to remove much of the undifferentiated heavy lifting from their day-to-day activities. HAQM Relational Database Service (HAQM RDS) […]
Implementing DB Instance Stop and Start in HAQM RDS
This post is from Matt Merriel at AWS partner Kloud, and Marc Teichtahl, manager for AWS Partner Solutions Architecture Australia and New Zealand. Kloud uses the new stop and start capabilities in HAQM RDS to lower costs for customers who don’t require 24×7 access to their databases during the testing and development phases of their […]