Management and Automation of Open Source Databases

Proprietary databases have been around for decades with a rich third ­party ecosystem of management tools. But what about open source databases? This whitepaper discusses the various aspects of open source database automation and management as well as the tools available to efficiently run them.

Table of contents

  • 1. Introduction
  • 2. Open Source DBs -­ the New Data Center Standard?
  • 3. The Database Infrastrucnture Lifecycle
  • 4. Tools -­ Build or Buy?
  • 5. Database Deployments -­ Beyond Chef and Puppet
  • 6. Monitoring -­ Why Not Just Use Nagios?
  • 7. Management -­ a Rising Tide of Continuous Scripting
  • 8. Severalnines ClusterControl -­ a Systematic Approach to Operations

1. Introduction

Databases are the repositories of a company’s most critical information. Being stateful, they typically are the most complex part of the application stack. Databases are complex to install and manage, especially when clustering or high availability is involved. To operate a database usually requires specialised knowledge.

While large enterprises have made significant investments in database management tools, most of these have been targeted to be used with proprietary DBMSs like Oracle or SQL Server. However the database landscape in the modern data center is changing.

By 2018, more than 70% of new in-­house applications will be developed on an OSDBMS, and 50% of existing commercial RDBMS instances will have been converted or will be in process,” predicts Gartner in a new research paper, State of Relational Open Source RDBMSs 2015.

Want to read the rest?

Download the full whitepaper for free