September 2017 Summaries

CockroachDB is a cloud-native, distributed SQL database designed for strong consistency and high scalability, making it easier to manage data. It pairs naturally with Mesosphere's DC/OS, an orchestration system that manages distributed applications across clusters, offering features like elastic scaling, load balancing, and automatic recovery. The CockroachDB DC/OS framework, built with the dcos-commons SDK, facilitates seamless integration by handling service discovery, storage management, and deployment challenges using configuration files. Once installed on a DC/OS cluster, the framework ensures resilient operations through health checks and scheduling, allowing for zero-downtime upgrades and process management. It also supports easy database backups to AWS S3, with potential for future expansion to other destinations. Users are encouraged to explore and contribute feedback to further enhance the deployment experience.

CockroachDB emphasizes the importance of strong transaction isolation by default, specifically the SERIALIZABLE level, to ensure data consistency and prevent subtle bugs that can arise from weaker isolation levels like READ COMMITTED or REPEATABLE READ. While many databases prioritize performance by defaulting to these weaker isolation levels, allowing for potential anomalies or "lies" in data processing, CockroachDB opts for higher safety standards. The SQL standard endorses SERIALIZABLE as the default due to its robustness against transactional anomalies, but many systems, such as Oracle and older versions of PostgreSQL, either implement weaker versions like snapshot isolation or do not support SERIALIZABLE effectively. Recent research highlights the real-world impact of weak isolation, uncovering transactional bugs in eCommerce applications that could have been avoided with stronger isolation. Despite workarounds like SELECT FOR UPDATE, which aim to secure transactions under weaker isolation, they often fail or introduce performance drawbacks. CockroachDB's approach prioritizes data accuracy and reliability over performance, aligning with findings that highlight the risks of weaker isolation and the challenge of implementing effective workarounds.

Cockroach Labs has implemented an innovative interview process to enhance diversity and reduce bias by focusing on exercise-based interviews rather than traditional resume-based assessments. This approach involves removing resumes from the interview process to prevent unconscious bias, and instead, candidates are evaluated based on real-world applications of their skills through exercises such as case studies, group discussions, and individual tasks. This method, applied to both technical and non-technical roles, aims to provide a more accurate reflection of a candidate's abilities and how they would perform on the job, thereby leading to better hiring outcomes and a more inclusive environment. Feedback from candidates has been largely positive, with many appreciating the hands-on, collaborative nature of the interviews. As part of their commitment to improving recruitment practices, Cockroach Labs plans to open source their interview questions on GitHub to encourage other companies to adopt similar inclusive strategies and to foster collaboration in refining interview methods.