March 2023 Summaries

The article by Alex Entin explores how Wasabi Cloud Storage can be a cost-effective and efficient alternative to traditional cloud storage solutions like Amazon S3, particularly for users looking to streamline database operations and reduce storage expenses. It highlights Wasabi's advantages, such as being AWS S3 API compatible, offering faster data transfer speeds, and significantly lower costs without egress fees. The text outlines how Wasabi can be integrated with CockroachDB for various purposes, including disaster recovery, cluster migration, and data export-import processes. By switching to Wasabi, users can achieve faster backup and restore operations, making their disaster recovery processes more robust while maintaining economic efficiency. The article also emphasizes the potential for cost savings and operational enhancements for businesses willing to transition to Wasabi, suggesting it as a viable option for those aiming to cut cloud storage costs without compromising on performance.

The article provides a detailed step-by-step guide on deploying and securing a multi-cluster CockroachDB setup using the Calico clustermesh, focusing on achieving scalable and secure inter-cluster communication across multiple regions. It highlights the challenges of deploying persistent workloads like databases in Kubernetes, particularly in a multi-region context, and how CockroachDB, with its distributed architecture and strong consistency guarantees, is well-suited for these use cases. The guide outlines the process of setting up a multi-region AWS network, provisioning Kubernetes clusters, enabling pod communication, deploying CockroachDB, and securing its deployment through Calico Cloud's federated endpoints identity. Ultimately, it emphasizes the importance of Calico's clustermesh in facilitating efficient cross-cluster communication and policy enforcement, thereby addressing the complexities of a multi-cluster network architecture and enhancing scalability and security for global applications.

Cockroach Labs has experienced significant growth and expansion, marked by its database product, CockroachDB, being adopted by major companies across various industries, including Fortune 500 firms, fintech disruptors, and media giants like Netflix and Comcast. With an average annual business expansion of 139% and a notable revenue increase of 100% in Europe, the company is also expanding into Asian and Latin American markets, starting with India. The appointment of Jason Forget as President and CRO is a strategic move to accelerate this growth, leveraging his experience from Redis and Imperva. The rapid expansion of CockroachDB and the database market reflects a broader industry shift towards cloud-first IT strategies, as businesses seek distributed cloud databases to meet the demands of data intensivity and global scale. Cockroach Labs is committed to providing foundational database technology that supports its customers' success in exploiting the potential of the cloud.

Fortune 50 banks are transitioning from traditional relational databases like Oracle and PostgreSQL to CockroachDB to better meet the demands of their modern, global user base and to navigate a shifting regulatory environment. This shift is largely driven by the need to mitigate risks associated with both planned and unplanned downtime. CockroachDB, a distributed SQL database, offers superior fault tolerance and performance, particularly important for mission-critical workloads such as payment processing and identity and access management (IAM). The database's ability to seamlessly handle multi-region deployments and its operational simplicity reduce complexity and associated risks, allowing banks to innovate and grow more efficiently. By adopting CockroachDB, banks benefit from enhanced risk management, reduced operational complexity, and increased profitability through improved performance and minimized downtime, thereby maintaining competitiveness in the financial sector.

Booksy, a global digital appointment booking service for beauty, health, and wellness salons, has modernized its infrastructure to meet the demands of nearly 100 million bookings across 25 countries. Initially based on an on-premises IT setup with a monolithic architecture using Postgres, Booksy faced challenges as user numbers and service demands surged. To ensure scalability and customer satisfaction, Booksy transitioned to a cloud-first approach using Google Cloud and CockroachDB, which allowed for a shift to a microservices architecture. This change enabled the platform to remain resilient and available globally, offering additional business services like marketing and sales support. CockroachDB's ability to handle planetary-scale operations without manual management, along with its efficient backup and restore features, proved crucial in maintaining service continuity, especially during peak traffic periods. This infrastructure not only supports rapid scaling and geographic expansion but also ensures compliance with data localization needs, thereby protecting small businesses from potential losses due to downtime. Booksy's use of CockroachDB highlights the database's suitability for retail environments that require consistency, scalability, and resilience, as detailed in a Google Cloud case study and a comprehensive report on distributed SQL databases.

Fault tolerance is a critical aspect of modern application architecture, designed to ensure systems continue operating smoothly in the face of errors or outages, thereby preventing loss of functionality and maintaining customer confidence. The article highlights the significance of fault tolerance by contrasting it with high availability, emphasizing that while related, the two are not synonymous. It explores different strategies for building fault-tolerant systems, such as using multiple hardware systems, software instances, and backup power sources. The piece also discusses the balance between normal functioning and graceful degradation, as well as setting survival goals to determine the level of fault tolerance needed. Financial implications are addressed, noting that while fault-tolerant architectures can be costly, the expenses of outages, including revenue loss, reputation damage, and team morale impacts, can be even greater. Real-world examples, such as a major electronics company's decision to migrate to CockroachDB for enhanced scalability and reduced labor costs, illustrate the practical application of these concepts. Overall, the article underscores the importance of thoughtfully architecting systems to withstand various levels of failure, thereby ensuring operational resilience and efficiency.

Modern businesses face the challenge of maintaining innovation while reducing IT costs, with a significant portion of their budget dedicated to data management. A report highlights the potential of distributed SQL databases, like CockroachDB, to deliver substantial savings by automating many of the manual, labor-intensive tasks associated with traditional relational databases. Interviews with seven companies, including a Fortune 50 financial services firm and a major logistics company, reveal that switching to CockroachDB can reduce operational costs by nearly 70%, saving millions annually. This is achieved despite higher licensing fees, as the distributed nature of CockroachDB eliminates hidden costs related to manual scaling, sharding, and maintenance, freeing up engineering resources for more value-generating activities. For example, companies have found they could redirect 22% of their data management efforts to other projects, leading to cost savings and efficiency gains ranging from $0.53 million for startups to $8 million for larger enterprises.

CockroachDB's exploration into optimizing JSON parser performance in Go reveals significant speed improvements by transitioning from the standard Go `encoding/json` library to the `jsoniter` library, and ultimately, a customized fork of the high-performance `pkg/json` library. The initial inefficiency of the ParseJSON function, which used a two-phase parsing approach, prompted benchmarking to understand its shortcomings, particularly in memory allocation. The switch to `jsoniter` resulted in substantial speed gains but revealed suboptimal allocation behavior with escaped characters. Further enhancement was achieved by adopting and modifying `pkg/json`, achieving over 1GB/s throughput and improved allocation efficiency. This project underscores the importance of careful library selection and API design in achieving high performance, while also benefiting from Cockroach Labs' "Flex Friday" policy, allowing engineers to explore such optimizations.

A major US-based electronics company successfully transitioned from MySQL to CockroachDB, resulting in significant cost savings and operational efficiencies. Initially challenged by the complexities and expenses associated with scaling MySQL for their cloud-native IoT applications, the company moved to CockroachDB self-hosted, benefiting from its automated data partitioning and routing, which eliminated many manual processes. However, maintaining this setup required considerable resources, prompting a further shift to CockroachDB dedicated, a managed service that reduced their operational burden. Despite the initial migration costing $200,000, the company saved $700,000 in the first year, achieving a 149% ROI. This transition not only reduced costs but also freed up developer time to focus on enhancing their software, underscoring the broader advantages of adopting a next-generation distributed SQL database.

SALTO Systems is a prominent provider of cloud-based access management technology, offering secure and flexible wireless electronic access control solutions across more than 40 countries, with over 40 million daily users. Initially founded in 2001 to provide electronic lock hardware, SALTO transitioned to a cloud-based platform to address challenges such as downtime during upgrades and schema changes when using SQL Server. The company sought an infrastructure that would facilitate operational efficiency and allow developers to focus on business solutions rather than database management. This led to the adoption of CockroachDB, a database known for its ease of operation and resilience, enabling SALTO to enhance its end-user experience and maintain a highly available access management system. The move to CockroachDB allowed SALTO to streamline their operations and focus on innovation, freeing developers from the complexities of database management, and ensuring seamless operation even during outages.