4 ms·
That is pure speculation. And people that use MySQL have outages also especially at this level of load. At my company we are just using PHP and MSSQL and we hav
by rjkennedy98 7y ago
That is pure speculation. And people that use MySQL have outages also especially at this level of load. At my company we are just using PHP and MSSQL and we have our DB go out even on our internal apps on nearly a daily basis due to load problems.
I can't imagine our DBs holding up to millions of users or need to process millions of ticker symbols or trades.
- riteshpatel 7y agoSounds like missing indexes to me if outages are that frequent.
- 3fe9a03ccd14ca5 7y ago> we have our DB go out even on our internal apps on nearly a daily basis. What?? How could your team live with that?
- rjkennedy98 7y agoIts extremely difficult to cut over millions of lines of code and 15+ years of development. We are working on it, but the db was never properly sharded and that is very difficult to do at a late stage. When you work on big enough projects the common sense approaches break down. FB messager doesn't use MySQL, Amazon shopping cart doesn't use Postgres. There is a reasons why. This isn't a wordpress app, it needs to process 10s of thousands of updates a second and still be a responsive app with 99.9% uptime and low SLAs on requests.