AWS Database Blog

Monitoring SQL Server is an essential aspect of any relational database management system (RDBMS) when dealing with performance problems. Many of our customers want to capture certain systems and user-defined events for monitoring and troubleshooting problems related to SQL Server. SQL Server logs these events in SQL Server error logs and SQL Server agent logs. […]

In the first part of this series, we discussed several use cases for including a second Region in your disaster recovery (DR) plans for your Amazon Relational Database Service (Amazon RDS) for Oracle  database instances. We also introduced cross-Region automated backups to assist you in establishing and maintaining cross-Region point in time restore (PITR) capability for your Amazon […]

Today, customers using Amazon Relational Database Service (Amazon RDS) for Oracle have several managed high availability (HA) and disaster recovery (DR) capabilities to choose from based on your business requirements and use cases: With Amazon RDS Multi-AZ, you get enhanced availability and durability for database (DB) instances within a specific AWS Region. This is often […]

Amazon ElastiCache for Redis is an AWS managed, Redis-compliant service that provides a high-performance, scalable, and distributed key-value data store that you can use as a database, cache, message broker, or queue. Redis is a popular choice for caching, session management, gaming, leaderboards, real-time analytics, geospatial, ride-hailing, chat and messaging, media streaming, and pub/sub apps. […]

A common practice when creating a data model design, especially in the relational database management system (RDMS) world, is to start by creating an entity relationship diagram (ERD). Afterwards, you normalize your data by creating a table for each entity type in your ERD design. The term normalization refers to the process of organizing the […]

When using a document data store as your service’s source of truth, you may need to share the changes of this source with other downstream systems. The data events that are happening within this data store can be converted to business events, which can then be sourced into multiple microservices that implement different business functionalities. […]

This is a guest post by Russell Waterson, Knowledge Graph Engineer at Data Lens Ltd. Customers use knowledge graphs to consolidate and integrate information assets and make them more readily available. Building knowledge graphs by getting data from disparate existing data sources can be expensive, time-consuming, and complex. Project planning, project management, engineering, maintenance and […]

This is a guest post by Russell Waterson, Knowledge Graph Engineer at Data Lens Ltd. Customers use knowledge graphs to consolidate and integrate information assets and make them more readily available. Building knowledge graphs by getting data from disparate existing data sources can be expensive, time-consuming, and complex. Project planning, project management, engineering, maintenance and […]

Database administrators set up monitoring on database log files to get alerted on certain informational and critical events relating to a pattern of errors specific to a database. Monitoring for errors on a business-critical database is essential to avoid unexpected outcomes such as a missed service-level agreement (SLA), which might result in penalties. A good […]

There are many different ways to achieve disaster recovery objectives based on business requirements, but finding the best option for a particular situation can get overwhelming. The innovation and commercial-grade features that come with Amazon Aurora MySQL-Compatible Edition expands these options even further. This post outlines options available to customers running Aurora MySQL, and evaluates […]