3 ms·
Ok what can you write it in that you can't scale to 10K users by just adding web servers? The hard to scale part is storage layer but even crappy options like R
by qaq 10y ago
Ok what can you write it in that you can't scale to 10K users by just adding web servers? The hard to scale part is storage layer but even crappy options like RDS will happily support 10K users.
- tbrownaw 10y agoMicrosoft Access. Works fine for something one team uses, works... not fine for something the entire corporation uses.
- devduderino 10y agoYep
- qaq 10y agoWell there are tools to help easily migrate Access to SQL Server, but this is moving fairly far from the original premise of this topic.
- Dylan16807 10y agoDoes Access actually work well for 20 users?
- nyir 10y agoAnecdotally it doesn't: had to use a time tracking program that used an Access database on a shared network folder and would frequently freeze up or crash due to locking issues (with around that many users). I imagine it could be done better though.
- Clubber 10y agoLast time I built something in Access was on Access 1997. I believe it had about 100 concurrent users and over a gig of data. Those both exceed the hard limits of access at the time so I had a single read/write database on a share and multiple read only databases on shares. I had to split tables among multiple database files as well. My direct boss was the CFO and he was cheap as hell. It's amazing the things we can come up with when we have to.
- cyberferret 10y ago> but even crappy options like RDS Curious as to why you see RDS as a 'crappy' option?? Given the choice of building and maintaining a MySQL box in the corner of your bedroom and hosting it on RDS - I know which way I would go (and I have done both over the years). If you are talking 'scaling' in terms of the OP's article, then RDS is almost a no brainer, and you can scale your instances (and add replicated instances etc.), hide it behind a VPN, set up firewalls to prevent DDoS attacks all in a matter of minutes, with a few mouse clicks.
- qaq 10y agoThe highest IOPS you can get on RDS is about a single consumer grade SSD.
- cyberferret 10y agoFair enough. But if the alternative is setting up a consumer grade PC on a consumer grade internet connection in a (non environmentally or power controlled) corner of a room at home, then surely we are looking at a similar situation? Given that spooling up a RDS instance is quicker and cheaper than buying all the hardware and spending time installing and configuring an SQL server, then if time to market is a critical factor, you would choose RDS over a home grown solution, wouldn't you? [Edit: I just realised that this is actually the point you were making, and I got sidetracked by my above question]
- pbreit 10y agoHave you heard of hosting? No one is running servers in their house. Nobody.
- pbreit 10y agoNo one hosts MySQL out of their bedroom. C'mon. The alternative is hosting the DB yourself at a hosting provider which is what most do and it works fine.