Choosing an open source database management system

Enterprise Considerations

If you plan to use your DBMS in an enterprise-grade capacity, you'll need to consider a few additional criteria.

First and foremost, you want to look for a solution that promises stability. Depending upon how you'll use the distribution, ACID-compliance is particularly important for stability. For all use cases, a proven track record, a planned release cycle, high quality documentation, and support forums can provide assurance regarding the DBMS's longevity and community involvement.

For enterprise-grade systems, high availability is particularly important. Look for solutions that offer redundant and fault-tolerant components at the same location. And in case of a high availability failure, you'll want a solution with a disaster recovery plan to get your system back up and running.

Finally, you may need to consider paying for additional extensions or add-ons that can make an open source DBMS enterprise-grade. Most of the DBMSs highlighted here offer an enterprise version. You may also need to consider paying for outside 24/7 support from a third-party vendor if you don't have the staffing resources in house.

Conclusion

An open source DBMS can offer many benefits over closed source alternatives. With the right considerations, you can use these open source solutions in enterprise environments. To find the best one for your organization, a close look at your present and future needs will help you narrow down the field.

This article was made possible by support from Percona LLC, through Linux New Media's Topic Subsidy Program (https://www.linuxnewmedia.com/Topic_Subsidy).

The Author

Amy Pettle is an editor for ADMIN and Linux Magazine. She started out in tech publishing with C/C++ Users Journal over 20 years ago and has worked on various Linux New Media publications.

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy Linux Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • In-Memory DBMS

    Thanks to powerful hardware, in-memory databases run without accessing mass memory devices, which means they handle transactions and evaluations at high speed, introducing a paradigm shift in the database market.

  • PostgreSQL

    PostgreSQL, an open source object-relational database management system known for its reliability and extensibility, offers a robust feature set. If you are new to PostgreSQL, we help you get started with some of its most useful features.

  • FAQ

    Big data is like The Matrix – Better without the sequel

  • MySQL Workbench 5.1

    A small database is easy to plan on paper, but the structure quickly becomes more complex as you add more elements. MySQL Workbench can help you keep the tables arranged.

  • Cross-Platform Database Management with DBeaver

    Save time and effort as you rummage through large quantities of data.

comments powered by Disqus