Table: aws_memorydb_cluster - Query AWS MemoryDB Clusters using SQL

AWS MemoryDB is a Redis-compatible, fully managed, in-memory database service that delivers ultra-fast performance for modern applications. It is designed for building and running real-time applications that require sub-millisecond latency. The aws_memorydb_cluster table in Steampipe allows you to query information about MemoryDB clusters in your AWS environment. This includes details like cluster configuration, status, security, and maintenance settings.

Table Usage Guide

The aws_memorydb_cluster table enables DevOps engineers and cloud administrators to gather detailed insights on their MemoryDB clusters. You can query various aspects of the cluster, such as its endpoint configuration, encryption settings, and shard details. This table is particularly useful for monitoring cluster health, ensuring security compliance, and managing cluster configurations.

Examples

Basic cluster information

Retrieve basic information about your AWS MemoryDB clusters, including their name, ARN, status, and node type. This can be useful for getting an overview of the clusters deployed in your AWS account.

select
  name,
  arn,
  status,
  node_type,
  engine_version,
  region
from
  aws_memorydb_cluster;

select
  name,
  arn,
  status,
  node_type,
  engine_version,
  region
from
  aws_memorydb_cluster;

List clusters with auto-minor version upgrade enabled

Identify clusters that have automatic minor version upgrades enabled, which can be useful for understanding how your clusters are being maintained and ensuring they are kept up to date.

select
  name,
  arn,
  auto_minor_version_upgrade
from
  aws_memorydb_cluster
where
  auto_minor_version_upgrade = true;

select
  name,
  arn,
  auto_minor_version_upgrade
from
  aws_memorydb_cluster
where
  auto_minor_version_upgrade = 1;

List multi-AZ clusters

Fetch a list of clusters that are configured with Multi-AZ for high availability. This can help in identifying which clusters have enhanced availability features enabled.

select
  name,
  arn,
  availability_mode
from
  aws_memorydb_cluster
where
  availability_mode = 'multiaz';

select
  name,
  arn,
  availability_mode
from
  aws_memorydb_cluster
where
  availability_mode = 'multiaz';

List clusters with encryption in transit disabled

Find clusters where encryption in transit is not enabled, which may indicate potential security risks that need to be addressed.

select
  name,
  arn,
  tls_enabled
from
  aws_memorydb_cluster
where
  tls_enabled = false;

select
  name,
  arn,
  tls_enabled
from
  aws_memorydb_cluster
where
  tls_enabled = 0;

Clusters by maintenance window

Retrieve clusters along with their scheduled maintenance windows, which is useful for planning updates and understanding potential downtime.

select
  name,
  arn,
  maintenance_window
from
  aws_memorydb_cluster;

select
  name,
  arn,
  maintenance_window
from
  aws_memorydb_cluster;

List clusters with specific node type

Query clusters that are using a particular node type, allowing you to evaluate the resource allocations and performance characteristics across your MemoryDB clusters.

select
  name,
  arn,
  node_type
from
  aws_memorydb_cluster
where
  node_type = 'db.r6gd.xlarge';

select
  name,
  arn,
  node_type
from
  aws_memorydb_cluster
where
  node_type = 'db.r6gd.xlarge';

List clusters with shard details

Retrieve detailed information about the shards within each cluster, including shard configuration and number of shards. This can help in understanding the distribution of data and load across your clusters.

select
  name,
  arn,
  number_of_shards,
  shards
from
  aws_memorydb_cluster;

select
  name,
  arn,
  number_of_shards,
  shards
from
  aws_memorydb_cluster;

Clusters with pending updates

Identify clusters that have pending updates, which may require attention to ensure the clusters are up-to-date and running optimally.

select
  name,
  arn,
  pending_updates
from
  aws_memorydb_cluster
where
  jsonb_array_length(pending_updates) > 0;

select
  name,
  arn,
  pending_updates
from
  aws_memorydb_cluster
where
  json_array_length(pending_updates) > 0;

List clusters with snapshot retention details

Gather information on the snapshot retention settings of your clusters to ensure that your data backup policies are being properly enforced.

select
  name,
  arn,
  snapshot_retention_limit,
  snapshot_window
from
  aws_memorydb_cluster;

select
  name,
  arn,
  snapshot_retention_limit,
  snapshot_window
from
  aws_memorydb_cluster;

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_memorydb_cluster