AWS Database Blog

Category: Intermediate (200)

Support JSON data using Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL and Java Spring Boot on AWS

Many customers choose Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition to store JSON business objects along with relational transactional data. You can also use the Spring Boot Java framework to implement microservice applications. The Spring Boot framework provides rich features, including auto configuration, dependency injection, metrics measurement, health checks, […]

Migrate on-premises SQL Server to Amazon RDS Custom for SQL Server using native backup and restore and Amazon S3

Amazon Relational Database Services (Amazon RDS) Custom for SQL Server is a managed database service for legacy, custom, and packaged applications that require access to the underlying operating system and database (DB) environment. Amazon RDS Custom is now available for the SQL Server database engine. Amazon RDS Custom for SQL Server automates the setup, operation, […]

Evaluate logical replication performance with synthetic load generation using Apache JMeter on Amazon Aurora PostgreSQL

Many customers face challenges when they have to choose the right instance size and assess the logical replication latency. When they’re using third-party replication tools like HVR, SharePlex, Oracle GoldenGate, or AWS Database Migration Service (AWS DMS ), it’s important to identify any networking glitches or compute resource allocation at the beginning. In this post, […]

Scale your Amazon MemoryDB for Redis clusters at a lower cost with data tiering

Amazon MemoryDB for Redis is a Redis-compatible database service that delivers both in-memory performance and Multi-AZ durability. You can use MemoryDB as a primary database for use cases that require durable storage and ultra-fast performance, like user session data, message streaming between microservices, payment processing, gaming leaderboards, and Internet of Things (IoT). Today, we announced […]

Empowering fraud detection at Delivery Hero with Amazon Neptune

This is a guest post co-authored by Amr Elnaggar, Saurabh Deshpande, Mohammad Azzam, Matias Pons and Wilson Tang from Delivery Hero. Delivery Hero is available in 74 countries around the World. It operates a wide range of local brands that are united behind the shared mission Always Delivering an Amazing Experience — fast, easy, and […]

Enable notifications for block corruption on Amazon RDS for Oracle

Consistency is one of the most crucial characteristics of relational database systems. Even though every system has their own mechanisms for providing consistency based on the database engine, sometimes you may lack consistency for several reasons, such as I/O hardware and firmware, OS issues, the database engine software, and recovering from UNRECOVERABLE or NOLOGGING database […]

How OLX optimized their Amazon DynamoDB costs by scaling their query patterns

This is a guest post by Miguel Alpendre (Engineering Manager at OLX Group), Rodrigo Lopes (Senior Software Engineer at OLX Group), and Carlos Tarilonte (Senior Developer at OLX Group) in partnership with Luís Rodrigues Soares (Solution Architect at AWS). At OLX, we operate the world’s fastest-growing network of trading platforms. Serving 300 million people every […]

Demystifying Amazon RDS backup storage costs

Amazon Relational Database Service (Amazon RDS) is a managed service that makes it easy to set up, operate, and scale relational databases in the cloud. Amazon RDS gives you access to the capabilities of a familiar MySQL, MariaDB, Oracle, SQL Server, or PostgreSQL database. Amazon RDS provides two different methods for backing up and restoring […]

Migrate your SQL Server workload with CLR integration to AWS

Common language runtime (CLR) integration is an option to host .NET code within SQL Server programmatic objects like stored procedures, functions, and triggers, and adding user-defined data types. Since its introduction in SQL Server 2005, CLR integration has gained popularity within the SQL Server community for its additional flexibility and options to import .NET code […]

Build resilient applications with Amazon DynamoDB global tables: Part 2

In the first post of this series, you learned about the differences between zonal, Regional, and global services, and how they affect theoretical application availability. In this post, you’ll learn more about some important Amazon DynamoDB characteristics and how they impact multi-Region design. Properties of DynamoDB tables in a single Region DynamoDB is a NoSQL […]