January 2022 Summaries

Cockroach Labs has successfully created a culture of joy within their fully distributed company during the pandemic. They have implemented various programs and traditions to foster this culture, such as weekly team meetings with music and trivia, peer acknowledgements in the form of songs or poems, flexible work policies, and community-building events like Roachella. The company encourages a healthy work-life balance and invests intentionally in creating a supportive and inclusive environment for its employees.

Mythical Games, a leading blockchain gaming startup valued at $1.25 billion, built its gaming infrastructure on CockroachDB to ensure high availability and scalability for their platform. The company's mission is to bring players, developers, and content creators closer to the games they love while giving them ownership of in-game assets through non-fungible tokens (NFTs). Mythical Games chose CockroachDB over Cloud SQL for Postgres due to its ability to eliminate downtime during maintenance, support global scaling across multiple regions and clouds, and provide a managed offering that frees up resources for player-facing features. The company's first game, Blankos Block Party, has attracted over one million accounts since its release in December 2020.

Raydijah Walters, also known as Dijah, is a People Systems Coordinator at Cockroach Labs. She assists in implementing and maintaining people-related systems that streamline processes and eliminate manual operations. Dijah started her career in retail training and development before transitioning to work at Cockroach Labs as a Recruiting Coordinator, where she developed an interest in the systems side of the business. She is excited about making an impact by implementing innovative solutions to address operational pain points and improve workflows. Dijah advises those starting careers in people systems to be patient, remain gracious, think forward, and embrace opportunities for growth and learning. The People Team at Cockroach Labs is characterized by collaboration, cross-functional support, and a willingness to share knowledge to achieve shared goals.

In exploring the differences between Google's Spanner and CockroachDB, the emphasis lies on how these distributed databases handle time synchronization to ensure consistency. Spanner leverages atomic and GPS clocks to maintain precise time synchronization across nodes using its "TrueTime" API, which helps achieve linearizability by bounding clock offsets tightly, allowing efficient ordering of transactions. CockroachDB, inspired by Spanner, aims to achieve similar consistency without specialized hardware. Instead, it supports serializability and uses a provisional commit timestamp approach with retries to address timing uncertainties caused by clock offsets. While Spanner waits for a short interval to ensure transaction ordering, CockroachDB sometimes retries reads when encountering uncertain timestamps, which can lead to multiple read attempts but maintains the integrity of transaction ordering. The document highlights the complexity of achieving clock synchronization in distributed systems and the innovative solutions each database employs to address these challenges, noting that while Spanner provides stronger consistency guarantees, CockroachDB is designed to operate on commodity hardware with broader cloud compatibility.

Lush Fresh Handmade Cosmetics, a global cosmetics retailer, optimized their global inventory management by migrating from disparate MySQL instances to CockroachDB. The previous architecture made it difficult for Lush to assess the performance of its products at a global scale and comply with local data regulations. After evaluating alternatives, Lush chose CockroachDB due to its high availability, cloud neutrality, easy management of global user data, standard SQL compatibility, and managed offering. With CockroachDB, Lush can now optimize their inventory strategy, analyze global business performance, and relieve operational management overhead.

In this article from Cockroach Labs' "Meet the Team" series, we get to know three members of their East Sales team - Matt Vaughn (Senior Manager, Southeast Sales), Brad Lewis (Account Executive), and Anthony DiMaggio (Commercial Account Executive). They share their reasons for joining the company, highlighting its strong leadership, innovative technology, and vast potential in the cloud/database market. They also discuss what they believe makes a successful sales manager or account executive, emphasizing qualities such as determination, consistency, knowledge-seeking, positive attitude, resilience, and customer focus. The article concludes with an invitation to explore open roles at Cockroach Labs on their careers page.

sqlfmt is an online SQL formatter that aims to beautifully format SQL statements by understanding all CockroachDB syntax, attempting to use available horizontal space in the best way possible, and maintaining visual alignment regardless of editor configuration. It was designed with a focus on using available space efficiently and adapting to the complexity of the query. The tool is based on a paper describing an algorithm for efficient document layout with multiple possible layouts, initially implemented in Haskell and later converted into Go. sqlfmt is not highly customizable and aims to remove options over time as it evolves.

Cockroach Labs has four core values that guide their company culture: Commit to Excellence, Communicate Openly and Honestly, Respect Each Other, and Establish Balance. These values were established early on in the company's history and have evolved over time as the company has grown and changed. The company incorporates these values into the hiring process, employee onboarding, annual awards, and regular surveys to ensure alignment across the organization. Cockroach Labs plans to publish a series of blog posts exploring each value in more depth and sharing perspectives from employees around the world.

The adoption of event-driven microservices in cloud applications presents challenges, particularly regarding communication between services. One solution is message queuing, which allows asynchronous communication and decouples services for better efficiency and scalability. However, the dual write problem arises when data needs to be written to two separate storage locations simultaneously, leading to potential inconsistencies. The transactional outbox pattern addresses this issue by using a single transaction to store two copies of the data in the database before pushing updates to the message queue. This ensures consistency and allows for retries if needed. CockroachDB's built-in Change Data Capture feature further simplifies implementing the transactional outbox pattern.

Change Data Capture (CDC) is a set of technologies that identify and capture data changes in databases, allowing for later action. Two key use cases for CDC are streaming data to a data warehouse and event-driven architectures. In the first case, CDC can improve ETL or ELT processes by continuously streaming data from primary databases to data warehouses, reducing load spikes, network provisioning needs, and delayed business decisions. In the second use case, CDC helps maintain consistency between service boundaries in event-driven architectures through the Outbox Pattern, which avoids complicated application logic and ensures message delivery. Other potential use cases for CDC include streaming updates to search indexes, analytics, anomaly detection, and online data stores for machine learning models.

Vincent Giacomazza is the Vice President of Sales for Cockroach Labs' East Coast division. The East Sales team drives company revenue through new business, expansion, renewals, and strategic partnerships along the East Coast. They work closely with other departments within the organization to ensure customer success and satisfaction. Vincent has a background in sales and technology, having worked at several successful software companies before joining Cockroach Labs. He believes that the company's culture of transparency, inclusiveness, and respect for work-life balance is key to its success and growth. Joining the East Sales team offers an opportunity to be part of a supportive and collaborative environment focused on achieving collective goals while maintaining a healthy work-life balance.