AWS Database Blog

Category: Intermediate (200)

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 […]

Build resilient applications with Amazon DynamoDB global tables: Part 1

Customers that need to build resilient applications with the lowest possible recovery time objective (RTO) and recovery point objective (RPO) want to make the best use of AWS global infrastructure to support their resilience goals. Building an application using multiple Availability Zones in a single AWS Region can provide high levels of availability, but you […]

Understanding statistics in PostgreSQL

PostgreSQL has become the preferred open-source relational database for many enterprise developers and startups, and powers leading business and mobile applications. AWS provides two managed PostgreSQL options: Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Database statistics play a key role in improving the performance of the database. The query […]