SYS-CON MEDIA Authors: Pat Romanski, Gary Arora, Zakia Bouachraoui, Yeshim Deniz, Liz McMillan

Blog Feed Post

Using DBaaS to Align Database Management with Your Application Delivery Processes

By

Today’s application development teams are moving fast, but is your team being held back by slow database management practices and tools? For many organizations, this is a significant problem that deserves as much attention as getting application code changes flowing smoothly into production. In fact, they are tightly interdependent challenges that need to be solved together.

Your Database Environment: Perception vs. Reality

Your Database Environment: Perception vs. Reality

Think about the application development process for a moment. How long does it take you to stand up a new copy of your database? Are you sure you have configured everything correctly and consistently? Do your developers and testers have access to production data for realistic testing? For most organizations, it’s unlikely that the answer to these questions are “minutes”, “very certain”, and “yes”.

It’s also critical to embrace the distributed and multi-instance nature of your organization’s data landscape. Gone are the days of a single, large and controlled database that sits underneath all of your applications. Even in a single application team, it’s a fairly universal truth that you will have multiple environments. From individual developer sandboxes, to integration and test infrastructure, and through to production clusters (and even DR copies), we aren’t really working with a single monolithic database environment. Each one of these environments means a new deployment of your database configuration.

Mapping Database Management to Application Delivery Processes

Data is different from code. Data represents the persistent state of your application, yet dynamically changes and grows as the application is used. Code, on the other hand, is much more of a static entity that can be versioned cleanly and deployed through configuration management tools. Many advanced approaches and tools have been developed to manage configuration drift, and ensuring that the code that is expected to be deployed is, in fact, the code deployed is now easier than ever. It’s the dynamic nature of data that makes managing it different from code deployments.

So what can you do about this difference? First, understand that there are aspects of your database environment that can be managed in a similar way as code and configuration. They fall into two buckets: the definition (configuration) of the database system itself and the definition of the schema / database code. Next, think about how the data being generated by your production application can be re-purposed efficiently for testing both new versions of your applications and the processes you will use to deploy your applications.

One great example of these concepts rolled into a consistent line of thinking is the work of Martin Fowler and Pramod Sadalage on Evolutionary Database Design. Evolutionary Database Design is a methodology for ensuring that your database environment is able to adapt and evolve along with your application. It advocates several specific approaches to ensuring that the database layer is an integral part of the entire application delivery pipeline.

While the Evolutionary Database Design pattern is certainly only one of many approaches to take, it’s well thought through and worth reviewing to find some key themes:

  1. Database instances need to be (re)generated on-demand – Development, integration, test, staging, and production environments should be consistent.
  2. Database schemas should be defined as “refactorings” – Your schema should be created by series of evolutionary migrations from one version to the next.
  3. Actual data matters – Use test data for earlier on in the application’s lifetime, but be prepared to use copies of production data later.

How does DBaaS Fit?

A Database-as-a-Service (DBaaS) platform can play a large role in how you advance your application delivery processes. Specifically, DBaaS can address two of the three themes from above: instance creation and data portability.

Instance creation is perhaps the easiest to comprehend, because that’s what most DBaaS solutions are solving at their core. Think about the definition of your database environment as configuration metadata (or a blueprint), which when used to deploy a new database instance from a DBaaS platform should result in a consistent database engine deployment for each instantiation. It shouldn’t matter if the environment’s specification is as simple as a single node or as complex as a multi tier cluster configured for sharding, it should be just as easy to get a new environment online.

The second role that a DBaaS platform can play is in helping to move the data itself around in the application lifecycle process. It should support operations like replica creation and database cloning, again via a self service UI and with APIs. These two functions are often though about as “operational” considerations for a database environment, but if you think about the whole application development system, they can become surprisingly useful to the entire team.

First, let’s define them:

Moving Data and DB Config through the Application Lifecycle

Moving Data and DB Config through the Application Lifecycle

  • Cloning is when a snapshot of the database system is created, and then transferred into a new “instance”. It’s a point in time copy created on-demand.
  • Replication is the synchronous or asynchronous replay of database changes against a “copy” of the database, which can then be detached from the “master” database to operate as a standalone system.

Both of these features offer a similar end result: you get a copy of the database that you can use for other purposes. Cloning takes a bit longer, but can easily happen off hours to minimize impact on the production environment. Replication can ensure a much faster “turn up” of the new environment with up-to-date data, but needs to be created ahead of the request for an instance. Regardless of the differences, they both provide a foundation with which each developer, tester and release manager can easily get a version of the production database when it’s needed.

Think about that in the context of bug-fixing: All too frequently, developers are handed user reports of an issue that is hard to reproduce without having a copy of the production data in place to replicate the situation. If it was easy for a developer to instantiate their own copy of the production environment (on demand) from a clone created each night, all of a sudden that developer will be able to resolve the bug much more effectively. Not only that, but the testing process will be able to ensure that the proposed patch does, in fact, solve the problem with real-world data as input.

Summarizing

You can move the code easily, but data and databases are a much harder a challenge without the right tools. A well designed Database-as-a-Service (DBaaS) environment can play a key role in helping you be more nimble in your treatment of data services within your application development pipeline. A DBaaS should offers solutions to both the “course grained” configuration management / automation challenges of the database engines themselves and the need to have self service access to copies of the dynamic data that your applications generate.

The right DBaaS solution should give you:

  • Self service access new DB instances for your development and testing teams
  • Move database engine configurations through the application development pipeline
  • Easily pull data back into staging, test and dev environments to give your teams access to real-world data
  • Support production rollout of application releases through replication and / or database cloning
  • APIs to make these operations an integral part of your continual integration and deployment processes

Read the original blog entry...

More Stories By Bob Gourley

Bob Gourley writes on enterprise IT. He is a founder of Crucial Point and publisher of CTOvision.com

Latest Stories
Every organization is facing their own Digital Transformation as they attempt to stay ahead of the competition, or worse, just keep up. Each new opportunity, whether embracing machine learning, IoT, or a cloud migration, seems to bring new development, deployment, and management models. The results are more diverse and federated computing models than any time in our history.
On-premise or off, you have powerful tools available to maximize the value of your infrastructure and you demand more visibility and operational control. Fortunately, data center management tools keep a vigil on memory contestation, power, thermal consumption, server health, and utilization, allowing better control no matter your cloud's shape. In this session, learn how Intel software tools enable real-time monitoring and precise management to lower operational costs and optimize infrastructure...
"Calligo is a cloud service provider with data privacy at the heart of what we do. We are a typical Infrastructure as a Service cloud provider but it's been designed around data privacy," explained Julian Box, CEO and co-founder of Calligo, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Isomorphic Software is the global leader in high-end, web-based business applications. We develop, market, and support the SmartClient & Smart GWT HTML5/Ajax platform, combining the productivity and performance of traditional desktop software with the simplicity and reach of the open web. With staff in 10 timezones, Isomorphic provides a global network of services related to our technology, with offerings ranging from turnkey application development to SLA-backed enterprise support. Leadin...
While a hybrid cloud can ease that transition, designing and deploy that hybrid cloud still offers challenges for organizations concerned about lack of available cloud skillsets within their organization. Managed service providers offer a unique opportunity to fill those gaps and get organizations of all sizes on a hybrid cloud that meets their comfort level, while delivering enhanced benefits for cost, efficiency, agility, mobility, and elasticity.
DevOps has long focused on reinventing the SDLC (e.g. with CI/CD, ARA, pipeline automation etc.), while reinvention of IT Ops has lagged. However, new approaches like Site Reliability Engineering, Observability, Containerization, Operations Analytics, and ML/AI are driving a resurgence of IT Ops. In this session our expert panel will focus on how these new ideas are [putting the Ops back in DevOps orbringing modern IT Ops to DevOps].
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, virtualized, and cloud, through to IoT and industrial control systems. Installed as a self-configuring cyber defense platform, Darktrace continuously learns what is ‘normal' for all devices and users, updating its understa...
Enterprises are striving to become digital businesses for differentiated innovation and customer-centricity. Traditionally, they focused on digitizing processes and paper workflow. To be a disruptor and compete against new players, they need to gain insight into business data and innovate at scale. Cloud and cognitive technologies can help them leverage hidden data in SAP/ERP systems to fuel their businesses to accelerate digital transformation success.
Most organizations are awash today in data and IT systems, yet they're still struggling mightily to use these invaluable assets to meet the rising demand for new digital solutions and customer experiences that drive innovation and growth. What's lacking are potent and effective ways to rapidly combine together on-premises IT and the numerous commercial clouds that the average organization has in place today into effective new business solutions.
Concerns about security, downtime and latency, budgets, and general unfamiliarity with cloud technologies continue to create hesitation for many organizations that truly need to be developing a cloud strategy. Hybrid cloud solutions are helping to elevate those concerns by enabling the combination or orchestration of two or more platforms, including on-premise infrastructure, private clouds and/or third-party, public cloud services. This gives organizations more comfort to begin their digital tr...
Keeping an application running at scale can be a daunting task. When do you need to add more capacity? Larger databases? Additional servers? These questions get harder as the complexity of your application grows. Microservice based architectures and cloud-based dynamic infrastructures are technologies that help you keep your application running with high availability, even during times of extreme scaling. But real cloud success, at scale, requires much more than a basic lift-and-shift migrati...
David Friend is the co-founder and CEO of Wasabi, the hot cloud storage company that delivers fast, low-cost, and reliable cloud storage. Prior to Wasabi, David co-founded Carbonite, one of the world's leading cloud backup companies. A successful tech entrepreneur for more than 30 years, David got his start at ARP Instruments, a manufacturer of synthesizers for rock bands, where he worked with leading musicians of the day like Stevie Wonder, Pete Townsend of The Who, and Led Zeppelin. David has ...
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, virtualized, and cloud, through to IoT and industrial control systems. Installed as a self-configuring cyber defense platform, Darktrace continuously learns what is ‘normal' for all devices and users, updating its understa...
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
Addteq is a leader in providing business solutions to Enterprise clients. Addteq has been in the business for more than 10 years. Through the use of DevOps automation, Addteq strives on creating innovative solutions to solve business processes. Clients depend on Addteq to modernize the software delivery process by providing Atlassian solutions, create custom add-ons, conduct training, offer hosting, perform DevOps services, and provide overall support services.