Home How To Choose A DBaaS For Database Management

How To Choose A DBaaS For Database Management

Guest author Baron Schwartz, an expert in MySQL, is the founder of VividCortex and the author of “High Performance MySQL.” He has helped build and scale some of the world’s largest web, social, gaming, and mobile properties.

The industry is rapidly embracing Database-as-a-Service (DBaaS), cloud offering for companies looking to rent access to digital data warehouses managed by an external provider.

Although company-run databases won’t ever completely go away, the rise of DBaaS can free many organizations of all sizes from the drudgery of maintaining their own local database systems. The primary benefits are that it can streamline operations and reduce cost—freeing the business to focus on developing their core products or services.

See also: Why DBaaS Will Be The Next Big Thing In Database Management

Sounds great, though choosing a provider can be a tricky proposition. You’re essentially trusting a vendor with your company’s data, and that’s no small matter. To pick a service and provider that’s right for your organization, start with these fundamental considerations.

The Fundamentals Of Selecting DBaaS

To evaluate DBaaS providers, you’ll want to start by considering the following factors:

Your Company’s Needs

Generally, you should think about whether the ecosystem you’re buying into is robust and well-suited to your needs.

Consider how you see your company and your tech stack growing and changing in the future. Outline what your company wants and needs out of a database, and then pick a set of technologies accordingly. If you want to use the public cloud, you have plenty of choices, including Amazon, Microsoft Azure, HP Helion, Rackspace, IBM Cloud, and so on. For a private cloud, VMware, OpenStack and others may be what you’re looking for.

Tailored And Preconfigured Solutions

There are two main DBaaS types to choose from: a widely used database (DB) solution (like PostgreSQL or MySQL, which is hosted and managed for you), or a proprietary DB (like DynamoDB, which isn’t available elsewhere).

Both have benefits and drawbacks. Hosted or managed DBs can let you transition to other databases or service providers—such as Amazon RDS for MySQL to your own MySQL—with relative ease. Proprietary DBs are more limiting and pose a lock-in risk. However, the latter can leverage the provider’s platform in more powerful ways.

If you’ve taken a hard look at your company’s needs (see above), then you’ll want to assess those priorities against the pros and cons of both DB types.

Edge Cases

After determining which service would best fit your company, explore the DBaaS providers in this sector. There are far too many to mention here, but here’s an idea of the breadth of choices:

  • Amazon’s RDS offers a variety of databases like Aurora, MySQL, PostgreSQL, Oracle, and SQL Server.
  • AWS also offers cloud-native databases, like Dynamo, Redshift, and ElastiCache.
  • Microsoft Windows Azure SQL Database or Azure DocumentDB.
  • Google’s databases include Cloud Bigtable and CloudSQL.
  • OpenStack Trove offers MySQL, PostgreSQL, MongoDB, Cassandra, Couchbase, Redis, Vertica, and DB2. Tesora, in particular, extends this to offer additional features and databases including Oracle.
  • Others include Heroku Postgres, Salesforce.com, and IBM Cloudant.

There’s a reason database management continues to evolve over time: no management solution is perfect for everyone. DBaaS is highly evolved compared to the options available 10 years ago, but it still has issues, including limitations in flexibility or performance in specific situations. That can challenge many developers to architect their app to the strengths and avoid the limitations.

Still, DBaaS represents a fundamental shift in data management as servers become replaced by automation, platforms, and services. Even if you’re not ready to take advantage of this next step in the evolution of databases, awareness and preparation now could pay dividends for your next product or service, allowing you to out-innovate and out-compete in your market. 

Lead photo by KamiPhuc

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.