Category: Intermediate (200)

This post is a follow-up to How Zendesk tripled performance by moving a legacy system onto Amazon Aurora and Amazon Redshift. In this post, we go over the techniques we used to plan and upgrade major versions of Aurora PostgreSQL databases for Zendesk Explore with minimal customer downtime. We also discuss the performance optimizations we performed, the cost savings we achieved, and how we accomplished all of this within a period of 6 months. AWS Technical Account Managers played a significant role in helping us achieve these goals in a short period of time. The upgrade was performed successfully and without customer downtime.

As of October 8th 2024, we’ve added support for Valkey 7.2 on Amazon ElastiCache and Amazon MemoryDB, our fully managed in-memory services. In this post, we discuss the AWS contributions to Valkey, AWS commitment to making Valkey more accessible for ElastiCache and MemoryDB customers, and how customers can start using it in their applications.

AWS announced that Amazon Aurora Serverless v2 supports database capacity of up to 256 Aurora Capacity Units (ACUs). Aurora Serverless v2 is an on-demand, auto scaling configuration for Amazon Aurora. It adjusts capacity in fine-grained increments to provide the right amount of database resources that the application needs. There is no database capacity for you […]

In this post, we show you an analysis tool which serves as a starting point to your database analysis journey by highlighting specific interdependencies between database objects: object dependencies, object constraints, and trigger references. Through a combination of SQL queries on the source Oracle database dictionary and Excel filters, the solution in this post can capture interdependent database objects for a target schema and generate a visual dependency diagram.

Tokenization is the process of creating a digital asset on a blockchain that can represent various assets, including physical assets, digital assets, or even rights of ownership. In this post, we explore the advantages of tokenizing real estate assets using blockchain technology in order to streamline property ownership transfers. We discuss the benefits of tokenization […]

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.

In this post, we provide an overview of Timestream Compute Units (TCUs), cost controls using TCUs, and how to estimate the desired compute units for your workload for optimal price-performance.

This is a joint post co-authored with Shailender Gupta, Global Head of Data Engineering, Reporting and Analytics at Apollo Tyres Apollo Tyres, headquartered in Gurgaon, India, is a prominent global tyre manufacturer with production facilities in India and Europe. The company has a widespread presence, selling tyres to consumers and industrial customers across over 100 […]

In this post, we share the steps to connect to an Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition instance using a federated user with IAM Identity Center and IAM database authentication.To enhance security and streamline access, you can connect to your RDS or Aurora instances using federated users with AWS IAM Identity Center and AWS Identity and Access Management (IAM) database authentication. This integration allows you to manage database access through IAM Identity Center, providing secure, centralized authentication.

Samsung Cloud is a cloud-based service that provides services such as backup/restore and synchronization, sharing, and device authentication of user data for all Samsung devices, including Galaxy smartphones around the world. This blog post introduces five approaches Samsung Cloud has taken to continuously lower the total cost of ownership (TCO) for Amazon DynamoDB since migrating from Apache Cassandra to DynamoDB in 2015.