I’m trying to use Tigris to back up my SQLite database with Litestream, however I’m a bit unsure which storage tier to use.
The Archive tier seems inappropriate because the hour wait time to restore the backup seems too long.
Both Infrequent Access and Archive Instant Retrieval sound like they could fit the Litestream use case. However, the Minimum Storage Retention of 30 and 90 days, respectively, gives me pause. If this is applied on an object-level, it seems like that would force WAL frames to be retained even if the Litestream retention policy is set to shorter duration like 24 hours.
Hmm. Based on a day or so of running Litestream, I’m seeing:
35,688 PUT, COPY, POST, LIST Requests
29 GET, SELECT, and all other Requests
Based on that, it seems like it’s not really doing frequent reads.
The thing I’m more worried about is the 30-90 day retention policy. I believe that Litestream will delete the WAL files (and the delete operations themselves are free), but if I’m not mistaken that would mean that Tigris will bill for 30 or 90 days for each of the WAL files even if they are deleted before then.
If I’m understanding it correctly, that might still suggest that the Standard Tier would be the right one to use for this use case.
That’s correct, however it looks like there hasn’t been any deletes. Maybe do some testing to see how many deletes occur, if it’s a low number it might still be worth while looking at the lower cost tier.