Blog
Culture
Thank you for a fantastic 2017! | Cockroach Labs
As we wrap up 2017, we would like to thank everyone who has contributed to and used CockroachDB and who has supported and encouraged all of us here at Cockroach Labs. This has been a great year for the product's - and company’s - evolution as we launched 1.0 then our 1.1, and are now well on our way to CockroachDB 2.0!
Swati Kumar
December 21, 2017
Product
How to improve IoT application performance with multi-row DML
Internet of Things (IoT) and microservices-style applications need a database that can handle requirements such as fluctuating number of client connections, unpredictable workloads, and bursty throughputs. Traditional single-node databases handle these requirements by reducing latency to improve throughput. However, for modern distributed databases such as CockroachDB, the optimal approach to handle these requirements is to use multi-row SQL Data Manipulation Language (DML) and parallel processing. Multi-row DMLs provide an order-of-magnitude improvement in throughput performance as compared with equivalent single-row DMLs, which is why databases such as Oracle, MySQL, and Postgres widely support multi-row DMLs. CockroachDB has supported multi-row DMLs since the 1.0. This blog post discusses how to use multi-row DMLs, the performance benefits of multi-row DMLs over single-row DMLs, and the effects of compounding database and application parallelism in single-node vs. distributed databases.
Robert Lee
December 7, 2017
System
Using “follow-the-workload” to beat the latency-survivability tradeoff in CockroachDB
Geographically distributed databases like CockroachDB offer a number of benefits including reliability, security, cost-effective deployments, and more. Critics often counter that distributed databases increase latency. What if a database could offer all of the benefits of distribution, but also provide low-latency? With this challenge in mind, we set out to minimize latency in CockroachDB, all the while providing exceptional reliability for mission-critical workloads. We built “follow-the-workload” to be a key feature to improve performance and provide additional control to database administrators (DBAs).
Andy Woods
December 5, 2017
Product
Using tunable controls for low latency in CockroachDB
Geographically distributed databases like CockroachDB offer a number of benefits including reliability, cost-effective deployments, and more. Critics often counter that distributed databases increase latency. What if a database could offer all of the benefits of distribution, but also provide low latency?
Andy Woods
November 30, 2017
Culture
Open-sourcing the interview process to reduce unconscious bias
Since the U.S. Equal Employment Opportunity Commission (EEOC) opened their doors for business on July 2, 1965, a year after Title VII’s enactment into law, the mission to eliminate unlawful employment discrimination has made progress in our society. No one can deny that we are in a significantly better place than we were just over 50 years ago. The act has benefited many and has served as a model for future anti-discrimination measures passed by Congress, including the Pregnancy Discrimination Act and the Americans with Disabilities. However, the passing of this legislation has by no means solved the problem of discrimination in the workplace. Discrimination is not as overt, but is rather found in grey areas, lurking beneath the surface and often rooted deep into an individual’s unconscious bias. I know what you are thinking: “I know I have biases, but I don’t discriminate against people who are different from me!” It feels shameful. Your biases are shaped by your experiences, culture, and your lifestyle. They frame your perspective and the way you behave in the world. It’s not shameful. However, we believe that recognizing your bias and how it affects your decision-making processes will allow you to understand if and how those biases are impeding your organization's ability to create a balanced and inclusive workforce. At Cockroach Labs, we have put processes in place for our employees to be aware of the role their unconscious bias plays in hiring decisions they are making. We have removed the dependency on resumes and focused on exercise based interviewing. Our end goal is to create practices that lead to a more inclusive culture. It’s proven that by providing candidates with an understanding of what to expect throughout the process, as well as insight into what to expect, helps them perceive the process as being fair [Klehe, König, Richter, Kleinmann, Melchers]. In addition to creating fairness, we want to see if full transparency can also lead to better hiring outcomes. With this in mind, we have made the decision to open source our interview process.
Lindsay Grenawalt
November 28, 2017
System
CockroachDB for Windows users
For the first two years of CockroachDB’s existence, the Windows installation instructions read like this: Install Docker. Get the latest CockroachDB Docker image: docker pull cockroachdb/cockroach The instructions were deceptively short, considering that they amounted to downloading a supported operating system (Linux), booting it in a hypervisor, and running CockroachDB inside of that virtual machine.
Nikhil Benesch
November 21, 2017
Product
The guide to secure deployments in CockroachDB
Production deployments are a world apart from development and testing environments. They come with their own best practices and recommendations, usually customized for each piece of your software stack. In this post, we’ll examine some of the more critical decisions to be made when deploying CockroachDB in production.
Marc Berhault
November 9, 2017
Design
What does clarity of color have to do with a mission-critical database?
Josué Rivera
November 2, 2017
Engineering
Data migration made easy: Bulk ingest from CSV
We think CockroachDB is a great database for many people, and want them to try us out. Not just for new applications, but for existing, large applications as well. The first problem that users with an existing database will hit when trying us out for the first time is getting their data into CockroachDB. For the 1.1 release, we built a new feature that performs high-speed, bulk data import. It works by transforming CSV files into our backup/restore format, then is able to quickly ingest the results.
Matt Jibson
October 26, 2017