(no title)
srcoder | 7 months ago
I've done many large database migrations which involved adding or removing indexes which included full table locking and they often lead to (accounted) downtime.
---
My honest take on this...
Most probably their regular user signup just wasn't protected well enough with captcha or CSRF and created some background processes that piled up on tables lacking some indexes which finally became a visible bottleneck.
They assumed bad traffic, so took the wrong turn. (WAF)
After they "implemented a fix" which should add an index to a large table that took down the database server because of table locking. This also doesn't recover after an abort.
Next up, UPGRADE OUR DB SERVER, and db table cache is gone, hence disabling user logging to allow to get a warm start. Didn't work, DOWNGRADE OUR DB SERVER, same thing repeats.
---
No bad actors involved.
No comments yet.