The One-Woman Dev Team Diaries logo

The One-Woman Dev Team Diaries

Subscribe
Archives
January 15, 2024

#163 - Disappointing Downtime

Two weeks of downtime and slow performance, big infrastructure changes, and minimal coding! 😩

View this email in your browser
#163 | 15 January 2024

Disappointing Downtime


So much for that good feeling about 2024...

Just kidding!! We're only two weeks in. Everything I said still stands! 😆

But...the start to the year was not as great as I hoped it would be. 😔

As normal, we'd already been seeing a significant uptick in the number of users using the app in run-up to Jan 1st.

Where we'd usually see just over a thousand concurrent users, we were now seeing two, then three, then four thousand people on the app or website at any given time.

Come New Year's Day, we were seeing almost eight times our normal usage numbers...
Screenshot of concurrent users on StoryGraph. The text above the line chart shows "Current visitors: 7.9k.  Unique visitors in last 30 mins: 29.1K. Pageviews in last 30 mins: 188k.
Didn't quite hit that 8k. 😢

...but the app couldn't hack it! 😩

Based on our numbers last year, we thought we'd be able to reach closer to 15-20k concurrent users before having any issues, but alas, we had been hovering closer to a bottleneck than we realised.

We had to take the app down all of a sudden and make some infrastructure changes, and I'll talk about that some more in the next section, but for now, in the midst of all of the disappointment and frustration, I want to focus on some positives to come out of the opening two weeks of the New Year.

First, the record numbers!
Screenshot of usage stats: Unique visitors, 24m, +69%; Pageviews, 38.2m, +76%, Bounce Rate 19%, 0% change.
With 2.4 million unique visitors in the first week of 2024, we saw a 50% increase from the same period last year and a 69% increase from the week prior!
.
.
.
I think that number would have gone a fair amount higher but the downtime prevented us from seeing what it would have been! 😔

Okay, okay, back to the positives...
.
.
.
Screenshot from the US Apple App Store showing StoryGraph as the number 2 Top Free Book App, behind Goodreads.
All of our popularity took us to Number 2 in Books in the US App Store (ahead of Kindle and Audible and behind Goodreads). We've since dropped back down but I look forward to the days when we're consistently up there! 💪🏾

And I think the most wonderful thing to come out of all of this was the outpouring of love and support from everyone during this difficult time. While we know it was frustrating for the app to have been down for so long during the beginning of the year, 95% (just made this number up, to be honest. It certainly felt like it!) of the messages we received were absolutely lovely!
Screenshot of nine tweets expressing love for us and congratulating us on our success!
We invest a lot of time and effort into our customer relations and it was really gratifying to see that pay off. 🥰
 

Since last time...
 

Most of the last two weeks have been spent making changes to our database infrastructure, and we're not done yet! 😅
Screenshot of the message people see after they've submitted their Goodreads data to be imported into StoryGraph. It reads: "We've received your Goodreads data, but we're currently experiencing heavy load. We'll email you once your import is complete.  If you haven't heard from us within 72 hours, please contact us via the app or website."
Normally this message says 24 hours and most imports are done within 30 minutes to a few hours...

To explain in as high-level terms as possible:

Before the New Year surge we had one large database and a live copy of it.

We thought that if we needed to scale, we'd be able to set up the second backup database as a 'read replica', and while doing this did help a little bit, our app has far too many updates every second, what with the constant Goodreads imports, for this to be an effective scalable solution for us, and so...
 

Next two weeks


...we'll be moving to a "distributed" database architecture, where we actually split all of the data across several more databases, therefore distributing the "writes" as well as the "reads".

Fingers crossed this works out well for us! 🤞🏾

Oh, and insert something about reading challenges and book clubs finally being done here... 😅
Screenshot of the new upcoming book-specific reading challenges. The top of the shot shows a progress bar 25% filled and the text: 1 book read out of 4.  Then there's a description that says "All of the Man Booker Prize Winners". There's a heading "Challenge books" and then four boxes, arranged in a 2x2 format. Each pane has a book cover, title and author, and above going from left to right reads: 1. Currently reading, 2. To-Read, 3. Prompt Complete, and 4. To-Read. The third box pane is a deep yellow/gold colour.
I mean, I have been doing stuff.
Just incredibly slowly and when I have the time...
🥲
 

What I'm reading


Hopefully I'll finish off You, Again, by Kate Goldbeck, a recommendation I picked up from a Bookstagram friend. I'm really enjoying it so far!
Screenshot of You, Again book pane on StoryGraph. On the left is the book cover, featuring an autumnal background, and a man and woman on the cover. The title and author name is overlayed on them in yellow writing. In the middle is all the book information, including its metadata and tags: 337 pages, first pub 2023, fiction, contemporary, lgbtqia+, romance, emotional, funny lighthearted, medium-paced, and a custom tag: dec-tbr. To the right is my reading information: a progress bar 61% of the way through, "Stared Dec 24, 2023", marked as "currently reading" , and marked as "owned".

Have a great week,

Nadia

P.S. Know somebody who's an avid reader or would enjoy following along with this journey? Please do forward this email to them! Thank you. :-)
 
Haven't tried The StoryGraph yet? Check it out today!
Love the app? Consider upgrading to our Plus plan!

Want to volunteer? Apply to be a Librarian!
Use Mastodon? Check out our server!
Were you forwarded this email?
If you liked what you read, you can subscribe for future updates and catch up on past ones.
Instagram
Twitter
Facebook
Copyright © 2024 The One-Woman Dev Team Diaries, All rights reserved.

Subscribe for a behind-the-scenes look at my StoryGraph founder journey and beyond.



Want to change how you receive these emails?
You can update your preferences or unsubscribe from this list.
Don't miss what's next. Subscribe to The One-Woman Dev Team Diaries:
Bluesky Threads X Bookshop.org LinkedIn Instagram Personal Website
This email brought to you by Buttondown, the easiest way to start and grow your newsletter.