DataStax Apollo database limits

DataStax Apollo sets limits for databases to ensure good practices, foster availability, and promote optimal configurations for your database.

DataStax Apollo offers a Free tier, allowing you to create an Apollo database with 10 GB for free, forever. Create a database with just a few clicks and start developing within minutes.

The following limits are set for all databases not on the Free tier created using DataStax Apollo. These limits ensure good practices, foster availability, and promote optimal configurations for your database.

CAUTION: To ensure you experience the latest, most stable deployment, all databases (except the Free tier) will be automatically removed every 72 hours to the most recently updated binaries.

All data in the database will be deleted when the database is terminated.

Columns

Parameter Limit Notes
Single column size 5 MB Hard limit.
Number of columns per table 50 Hard limit.
Size of values in BLOB and collection types 1 MB Hard limit.

Tables

Parameter Limit Notes
Number of tables per keyspace 2001 A warning is issued when the database exceeds 100 tables.
Table properties Fixed All table properties are fixed except for Expiring data with time-to-live.
Secondary index 1 Limit is per table.
Materialized view 2 Limit is per table. A warning is issued if the materialized view will create large partitions.
1Each DataStax Apollo database supports only one keyspace.

Cassandra Query Language (CQL)

Note: At this time, user-defined functions (UDFs) and user-defined aggregate functions (UDAs) are not enabled.
Parameter Limit Notes
Consistency level Fixed Supported consistency levels:
Lists Fixed When returning lists is disabled, read-before-write.
Page size Fixed The proper page size is configured automatically.
Large partition Warning A warning is issued if reading or compacting a partition that exceeds 50 MB.

Disk utilization

Parameter Limit Notes
Full write usage Administrators Only database owners can write to the database at 100% disk utilization.

Warnings are issued when non-administrative users write over 50%, 70%, and 90% disk utilization.