A Haunted House of NoSQL Horrors
Blog post from ScyllaDB
True-life tales of NoSQL database mishaps reveal the challenges faced by developers and Site Reliability Engineers when navigating the complexities of big data systems. These horror stories, shared by engineers, highlight common pitfalls such as relying on spot instances for critical applications, creating massive data partitions with secondary indexes, and the dangers of unlimited parallelism leading to latency issues. Other cautionary tales include the risks of using shared disks for data and OS, accidental shutdowns of production instances, and the chaos of handling viral traffic on hot partitions. The narrative humorously underscores the importance of proper backup testing, avoiding oversized Cartesian products, and the perils of misconfigured caches and replication factors, all while emphasizing the necessity of avoiding these mistakes to maintain data stability and developer sanity.