The rise of open-source databases: what you need to know

clock • 4 min read
The rise of open-source databases: what you need to know

The rise of open-source databases: what you need to know

Open-source databases are here to stay, but you should investigate all your options before taking the leap, says Kevin Kline, Head Geek at SolarWinds

Tech pros must balance productivity with cost and complexity every day, and those who work with database platforms are further challenged as open-source databases become more commonplace.

Nearly one-third of tech pros surveyed in the latest SolarWinds Query Report say they're responsible for more than 300 databases at their organisations. Most respondents say half or more of their organisation's databases are considered critical to their business.

Commercial platforms still dominate - especially for business-critical applications - but open-source databases are on the rise. In previous eras, few enterprise IT teams were willing to inject risk into their internal systems by using an open-source data platform or a database management system from a new startup. Those days are over. We're at the beginning of a new era of mix-and-match data platforms, but there are critical provisos to keep in mind.

Don't adopt an open-source platform before investigating all your options first.

You can't beat free - or can you?

The advantages of open-source databases are many, with the salient one being obvious: you can't beat free or low-cost. Without the (often expensive) licensing fees attached to commercial software, IT budgets are unencumbered by contractual payments. With the savings, IT departments have enormous flexibility, can experiment, and move as quickly as market forces demand.

Because the open-source community doesn't grant licenses based on fees paid, small companies have the same access to innovative features as multinational ones. Startups and other small businesses arguably have an advantage over larger companies: they generally make decisions faster because there are fewer layers of management to reinterpret and reprioritise the factors needed for quick decision-making.

Whether or not you should adopt open source comes down to cost versus value. An enterprise may opt for a commercial tool capable of saving them thousands of dollars a year because of efficiencies and ready support. The licensing fee - even if it's six figures - may not seem so high because, well… it works. And when it doesn't, you have direct contractual recourse to fixes. 

Adopting open source also means you won't be alone: according to the SolarWinds Query Report, 43 per cent of tech pros say they're currently running MySQL or MariaDB. Additionally, 18 per cent say they plan to adopt MySQL, MariaDB or another open-source database platform in the next three years.

Meanwhile, enterprises are looking to open-source databases for basic database applications - or at least weighing the pros and cons. They have the on-hand expertise with database management. Ultimately, many enterprises decide to wait for better tooling before committing to a frontline adoption of an open-source database platform.

First, investigate your options

Before jumping into open-source databases, database pros should investigate why and when these platforms make the most sense for their organisations. Many times, the initial steps in an investigation about whether to use open-source databases focus only on the performance and workload capabilities of the platform. But this isn't enough.

Admittedly, finding the time to investigate these matters can seem like an insurmountable problem. After all, the SolarWinds Query Report found database professionals work with diversified platforms of more than 300 databases. Just keeping this many databases up and running, resolving problems, and fighting fires is more than a full-time job.

In fact, the report also found maintenance work accounts for a substantial portion of the database professional's day: one-third of tech pros surveyed stated much of their days were spent in maintenance. Of course, this leads to less time for investigating open-source database platforms or, for that matter, any sort of analysis potentially leading to productivity gains and cost savings.

A monitoring mindset

Tech pros can save time spent on maintenance when they implement appropriate automation and monitoring tools. Database monitoring tools, in this case, can foresee problems before they reach criticality and can even respond to various alarms in real time. Automation, on the other hand, frees up time to focus on proactive database performance management. While database professionals upskill, innovate, and investigate their open-source options, monitoring tools can run in the background, further leveraging their ability to manage multitudes of databases.

One thing I've seen over many decades of experience is that enterprises with a monitoring mindset are much more successful than those without one. When top shops get a new database platform, they don't even consider moving it into production without a monitoring method ensuring it can't break without them knowing about it. They make sure it doesn't run amok, taking all the processing cycles on a particular server. Doing this helps enormously as tech pros continue to add more things to their plates.

Open-source databases are here to stay. Before deploying one, however, investigate your options thoroughly (remembering the consequences for a wrong choice are real). Then, when deploying the new database platform, be sure to deploy automation and monitoring along with it. And throughout, have rules of deployment based on clear business goals—take the politics out of the mix.

You may also like
Labour frontbencher advocates for open source software and regulatory innovation


Regulation can promote rather than stifle innovation, says Chi Onwurah

clock 08 February 2024 • 2 min read
'Open source must be part of AI future', Lords committee


Open source is 'a key part of what UK businesses need to compete and thrive' says Baroness Stowell

clock 08 February 2024 • 4 min read
Researchers find user data exposed on LectureNotes learning app

Threats and Risks

Misconfigured database was leaking data of more than 2 million users

clock 08 February 2024 • 2 min read
Most read

Cabinet Office terminates £9m Microsoft deal

16 February 2024 • 2 min read

Microsoft announces critical zero-day Exchange bug

16 February 2024 • 1 min read

Southern Water confirms customer data breach

14 February 2024 • 2 min read

Sign up to our newsletter

The best news, stories, features and photos from the day in one perfectly formed email.

More on Security

Microsoft announces critical zero-day Exchange bug

Microsoft announces critical zero-day Exchange bug

Enables remote control of Exchange Server

Vikki Davies
clock 16 February 2024 • 1 min read
Bank of America admits data breach after supply chain hack

Bank of America admits data breach after supply chain hack

Customer info exposed

Tom Allen
clock 13 February 2024 • 2 min read
Breach exposes personal info in 'world's biggest casino' app

Breach exposes personal info in 'world's biggest casino' app

Casino owner tries to claim data was 'publicly accessible' on purpose

Vikki Davies
clock 12 February 2024 • 2 min read