Capacity estimation
- A parking lot has 500 position, so max user is 500
- Assuming average time to stay is 1 hour, then for one day: 24 * 500 = 12K ticket per day
- We can assume one ticket info is 1K byte, if we store ticket data for 10 years, then the total storage size is 1K * 10 * 365 * 12K = 43GB
It can be easily handled by one SQL DB server, we can use one server with replication to ensure availability and avoid single point of failure