Trying DynamoDB for the first time
I tried the hyped serverless framework for a new project of mine. I used AWS Lambda for my backend logic and had to decide on a database to use along with it. The natural choice is DynamoDB, because its integration with AWS Lambda is really simple. While I’m really impressed with AWS Lambda, I feel disappointed trying out DynamoDB. It has some severe restrictions and takes a lot of additional development effort to do tasks that are really easy with MongoDB.
How it works
Like any other database you can create tables and define attributes with indexes on them. Although, you seem to not be able to structure your tables under a common database name. So all your tables for different apps are in the same dashboard. Am I supposed to create a new AWS account for every new side project? I just used a naming convention
The Pricing model
DynamoDB uses a metric called RCU to determine how much load your tables (or more precise, your indexes) can handle. This directly corresponds to how much you’ll be charged in the end. RCU stands for Read Capacity Units and 1 RCU means that your DB queries can read 8KB of data per second. (WCU / Write Capacity Units are a similar metric for writing to the table.)
But what does this even mean? In which time frame is this accumulated? Is it a hard cap, i.e., even if I only have a single big query once a month, I may not read more than 8KB? Or can I read 60 * 8KB=480KB per minute (20MB per month?) before my queries time out?
It’s explained in an unrelated article about Best Practices for Querying and Scanning Data:
if I was voldemort I would've hid my horcruxes in the aws ui— I Am Devloper (@iamdevloper) 25. September 2017
“When you are not fully utilizing a partition’s throughput, DynamoDB retains a portion of your unused capacity for later bursts of throughput usage. DynamoDB currently retains up to five minutes (300 seconds) of unused read and write capacity. During an occasional burst of read or write activity, these extra capacity units can be consumed very quickly—even faster than the per-second provisioned throughput capacity that you’ve defined for your table. However, do not design your application so that it depends on burst capacity being available at all times: DynamoDB can and does use burst capacity for background maintenance and other tasks without prior notice.”
So it’s averaged over a 5 minute time frame, but you shouldn’t rely on it and it might change in the future.
Some things I wish I had known before using DynamoDB
Here are some issues I came across while building the backend for a quiz app:
Query Conditions only work on indexes
There are roughly two types of ways to search a table: Using
- When you want to search for all items with a condition on a specific attribute, that attribute must be an index (using a
KeyConditionExpression). Or, you can use a
Scaninstead of a
Query, however the use of
Scans is discouraged as it will always scan the whole database and thus consume a lot of RCUs.
You cannot query multiple items. Let’s say you want to query 10 items with
random-uuid-10. You cannot do this using a
KeyConditionExpressions don’t have an
INoperator and don’t allow the
Invalid operator used in KeyConditionExpression: OR.
Instead, you have to retrieve the ten items with all their attribute by using
BatchGet. The problem with this is that a
BatchGetagain consumes more RCUs than a
Let’s say the size of each of these items is only 0.5 KB. If we could query all of them we would need 1 RCU, because 10*0.5KB=5KB < 8KB ≈ 1 RCU. With
BatchGethowever, each item read is counted individually and therefore consumes the minimal 8KB ≈ 1 RCU each time, i.e., you’ll need 10 RCU to get these items.
Cannot use boolean types on indexes
As of now boolean types are not allowed for index attributes. So what do you do when you have an
active boolean field on your items and you want to write a query that returns only the active items?
active a string, and when an item is active you set its
active field to any value (except empty string, which is an illegal value for a string attribute 🤷). When an item is inactive, you delete the
active attribute from it. You then create a sort key / secondary index on
active for your desired behavior. This is the recommended way and you can read why it works in Take Advantage of Sparse Indexes.
This is just one of those simple things that take a lot of developer effort to work in DynamoDB.
No way to get a random item
Being the backend for a quiz app, there should be the functionality to sample one or more random items from the table.
In MongoDB, you can just use
$sample. In DynamoDB, I thought of several approaches that all had a drawback in the end or seemed to go against what is considered good practice in DynamoDB.
Assume we have a big table with items who all have an index
id. We want to randomly sample 10 items without scanning the whole database.
1. Sequential numbers as
We can just use a counter as
id. To sample, we then get the maximum
id, sample 10 integers in the range [0, …, maxId], and query the items with these ids.
This has several problems:
- How do we get the
maxIdin DynamoDB without scanning the whole DB?
- We end up with holes if we remove items. These holes are not easy to fix.
- This probably doesn’t give a good partitioning of the table which can lead to performance problems.
2. Use random
ids and cache them in the API accessing the DB
We can use random
ids for the items. Whenever a request to sample items is made, we would scan the whole database once, and then cache the
ids. Now just sample 10
ids and retrieve these items. The next time we need to sample items, we just use the cached version of the
ids and can avoid the whole table scan.
I thought this was a nice and simple idea to implement, however the caching would have to be implemented inside my AWS Lambda function. There seem to be caching solutions for AWS Lambda, but the main idea of cloud functions is that they are stateless and ephemeral, in order for them to be easy to scale. I didn’t follow this approach any further.
3. Use random
ids and store all
ids in the DB.
This is the approach I ended up using. We again use random
ids. In my concrete use case (quiz) the items (questions) are only updated manually, and therefore it is suitable that I have a unique item in the table that stores all other item
ids. My lambda function then queries this item, gets a list of all ids, samples 10 at random, and calls
BatchGetItem to get the actual item data.
Still this has some drawbacks:
indexesitem is quite big and consumes many RCU. Items may not exceed 400 KB in DynamoDB, therefore you may need to split up the
indexesitem into several onces, making this approach more complicated.
You’re accessing one item (
indexes) a lot of times which can lead to performance problems.
“For example, if a table has a very small number of heavily accessed partition key values, possibly even a single very heavily used partition key value, request traffic is concentrated on a small number of partitions – potentially only one partition.”
I’d love to see a better idea on how to sample items in DynamoDB. Please reach out to me if you have one.