Database DevOps Survey: 60% Experienced Big DB Crash Lately
January 29, 2018

Yaniv Yehuda
DBmaestro

When was the last time your company experienced a significant database error? If it happened in the last 3 months, you’re in good company. A recent study conducted by DBmaestro asked 244 IT professionals this very question; 60% of respondents reported a crash or significant database error occurring in the last 6 months. Roughly one in ten respondents reported a serious database problem in the past week.

The survey, conducted online in October, sheds light on common practices in database management, errors and risks, as well as the rate of adoption of DevOps practices throughout all R&D functions. The results show that while DevOps practices have been widely adopted and utilized in application development, databases have been left behind. Crashes and major errors are prevalent among respondents, and even more so among companies that attempt to push database changes often.

Database Errors are Costly, Frequent, Dreaded

Database errors can be expensive; estimates vary, but studies show that an hour of database downtime can cost your business anywhere from $100,000 to $600,000+ an hour. These estimates have been growing steadily in the last several years, and can be even bigger for companies that rely heavily on timely database data retrieval for business operations.

While there can be many different causes for serious database errors, the 2018 Database Devops Survey reveals that the top causes are accidental overrides, invalid code and conflicts between teams. These three horsemen of the apocalypse account for over 50% of major database errors, respondents report.

For these reasons, it comes as no surprise that pushing changes to the database involves dread. In fact, over one-third of respondents reported that they are anxious about pushing database changes at least half the time.


DevOps Practices Used Widely – But Not for Databases

The fear-inducing errors that lead to crises when pushing new changes have all long been solved in the world of code development. With the extensive adoption of DevOps practices across multiple industries, similar errors in application development have been reduced to nothing. In fact, when asked about continuous delivery practices, 54% of respondents report that they are fully implemented in at least half of the company’s application development projects.

Adoption of these practices for the database is slow and lagging, the report shows. Only 36% of respondents report that they've implemented continuous delivery practices for database changes. On top of that, most respondents report that only the DBAs are allowed to push changes, often making them a bottleneck in the process.

It comes as no surprise that the result is slow, infrequent changes deployed to the database. Almost half (46%) of respondents reveal that they are only able to deploy database changes once or twice a month, a fact that stands in stark contrast to environments where CI/CD practices enable multiple deployments daily. In fact, only 14% of respondents currently have that capacity for database deployments.


Onward and Upward

The bottom line is clear: database needs to hop on the DevOps bandwagon, and fast. The only way to eliminate and prevent major database errors is by automating processes and adopting continuous delivery practices, stat. In turn, this will also improve the ability to push database changes often and fast, making the database as agile as any other part of the company’s development process.

Yaniv Yehuda is Co-Founder and CTO of DBmaestro
Share this

Industry News

December 01, 2022

Salesforce introduced a new Automation Everywhere Bundle to accelerate end-to-end workflow orchestration, automate across any system, and embed data and AI-driven workflows anywhere.

December 01, 2022

Weaveworks announced that Flux, the original GitOps project, has graduated in the Cloud Native Computing Foundation (CNCF®).

December 01, 2022

Tigera announced enhancements to its cluster mesh capabilities for managing multi-cluster environments with Calico.

December 01, 2022

CloudBees achieved the Amazon Web Service (AWS) Service Ready Program for Amazon Elastic Compute Cloud (Amazon EC2) Spot Instances.

November 30, 2022

GitLab announced the limited availability of GitLab Dedicated, a new way to use GitLab - as a single-tenant software as a service (SaaS) solution.

November 30, 2022

Red Hat announced an expansion of its open solutions publicly available in AWS Marketplace.

November 30, 2022

Sisense announced the availability of the Sisense CI/CD Git integration module.

November 29, 2022

Codenotary announced TrueSBOM for Serverless, a self-updating Software Bill of Materials (SBOM) for applications running on AWS Lamda, Google Cloud Functions and Microsoft Azure Functions that is made possible by simply adding one line to the application source code.

November 29, 2022

Code Intelligence announced its open-source Command-Line Interface (CLI) tool, CI Fuzz CLI, now allows Java developers to easily incorporate fuzz testing into their existing JUnit setup in order to find functional bugs and security vulnerabilities at scale.

November 29, 2022

Parasoft announced the 2022.2 release of Parasoft C/C++test with support for MISRA C:2012 Amendment 3 and a draft version of MISRA C++ 202x.

November 28, 2022

Kasm Technologies announced the release of Kasm Workspaces v1.12, providing major enhancements to its portfolio of digital workspaces delivering Desktop as a Service (DaaS), Virtualized Desktop Infrastructure (VDI), Remote Browser Isolation (RBI), Open-Source Intelligence Collection (OSINT), Training/Sandboxes, and Containerized Application Streaming (CAS).

November 28, 2022

Cloud4C has achieved Amazon Web Services (AWS) DevOps Competency status.

November 28, 2022

Simplilearn has acquired Fullstack Academy, for an all-cash transaction.

November 22, 2022

Red Hat introduced Red Hat Enterprise Linux 9.1and Red Hat Enterprise Linux 8.7.

November 22, 2022

Armory announced its new cloud-based solution called Continuous Deployment-as-a-Service, now available on the AWS Marketplace.