Working with Amazon Keyspaces (for Apache Cassandra) features - Amazon Keyspaces (for Apache Cassandra)

Working with Amazon Keyspaces (for Apache Cassandra) features

This chapter provides details about working with Amazon Keyspaces and various database features, for example backup and restore, Time to Live, and multi-Region replication.

  • Time to Live – Amazon Keyspaces expires data from tables automatically based on the Time to Live value you set. Learn how to configure TTL and how to use it in your tables.

  • PITR – Protect your Amazon Keyspaces tables from accidental write or delete operations by creating continuous backups of your table data. Learn how to configure PITR on your tables and how to restore a table to a specific point in time or how to restore a table that has been accidentally deleted.

  • Working with multi-Region tables – Multi-Region tables in Amazon Keyspaces must have write throughput capacity configured in either on-demand or provisioned capacity mode with auto scaling. Plan the throughput capacity needs by estimating the required write capacity units (WCUs) for each Region, and provision the sum of writes from all Regions to ensure sufficient capacity for replicated writes.

  • Static columns – Amazon Keyspaces handles static columns differently from regular columns. This section covers calculating the encoded size of static columns, metering read/write operations on static data, and guidelines for working with static columns.

  • Queries and pagination – Amazon Keyspaces supports advanced querying capabilities like using the IN operator with SELECT statements, ordering results with ORDER BY, and automatic pagination of large result sets. This section explains how Amazon Keyspaces processes these queries and provides examples.

  • Partitioners – Amazon Keyspaces provides three partitioners: Murmur3Partitioner (default), RandomPartitioner, and DefaultPartitioner. You can change the partitioner per Region at the account level using the AWS Management Console or Cassandra Query Language (CQL).

  • Client-side timestamps – Client-side timestamps are Cassandra-compatible timestamps that Amazon Keyspaces persists for each cell in your table. Use client-side timestamps for conflict resolution and to let your client application determine the order of writes.

  • User-defined types (UDTs) – With UDTs you can define data structures in your applications that represent real-world data hierarchies.

  • Tagging resources – You can label Amazon Keyspaces resources like keyspaces and tables using tags. Tags help categorize resources, enable cost tracking, and let you configure access control based on tags. This section covers tagging restrictions, operations, and best practices for Amazon Keyspaces.

  • AWS CloudFormation templates – AWS CloudFormation helps you model and set up your Amazon Keyspaces keyspaces and tables so that you can spend less time creating and managing your resources and infrastructure.

Topics