This is not the typical Indie Hacker route, but things came this way. I presented a prototype for a public administration, and the thing kept going.
I am in a situation in which I am about to eat more that I can diggest, and of course I need your help.
This project consists in a network of displays (kiosk-like) that need to display certain content that will be updated every 30 second via ajax. Not real time and not similar, but a taste like this (https://ftx.com/trade/BTC-PERP). Basicly new little promos.
This network will potencially surpass a thousand of nodes, and has also subnets (in which there are common content for all the nodes in within). It also expected to surpass +30.000 publishers and ~80.000 promos a day.
This is out of my confort zone, because is just me alone and I fear scalability issues in the future and taking the wrong decisions in the begining.
How would you face this project?
how woud you prepare the structure initially?
what would you do to make sure you won't have critical problems as you add more nodes?
Does it make sense to split something at database-level or server-level?
Technically I can't split the subnets because I should keep information relative to nodes, promos and publishers together.
Any advice/suggestions/tips is more than welcome. Thanks.
PD: I did the prototype with Ruby on Rails