June 25, 2019 By Osman Omer 3 min read

Have you ever hoped for single-click database (DB) instance creation and configuration? Do you, like me, feel that cloud computing won’t be complete without database as a service (DBaaS)? How about automated provisioning of Oracle on IBM AIX, on-premises both with a standalone instance and Oracle RAC? Your dream can now come true.

Cloud computing isn’t a buzz word anymore; it’s more of a norm nowadays, with more organizations adopting it day in and day out. For private and public clouds, however, orchestration of enterprise-level databases into an integral cloud solution continues to be a challenge.

IBM Power Systems can help, incorporating both Oracle and Open Source Databases to provide a full as-a-service solution. Solutions include Oracle DB on IBM AIX as well as MongoDB, MariaDB, EnterpriseDB (EDB) and Cassandra DB with Linux on IBM Power Systems.

The challenge

Most cloud solutions are based on capturing software images to rapidly clone them into new copies that users can exploit. This task is not as simple with databases though, especially complex and deeply involved databases such as Oracle and EDB. It requires careful planning that incorporates additional installation processes that are normally required by the database when cloning an instance.

With Oracle, for example, there’s host-specific configuration data embedded inside the installed DB, and when captured and deployed, that configuration data wouldn’t be correct for the new instance. Also, with Oracle Automated Storage Management (ASM), the size of the database storage space in the image may not address all deployment requirements. Furthermore, when it comes to Oracle RAC, additional complexity is introduced for the cluster synchronization and homogeneity.

For Open Source Databases, there are a few challenges: difficulties can surface when rapid deployment is needed as well as around keeping up with the rapid versioning updates these databases adopt. Covering a wide range of both relational and NoSQL types could be demanding. Also, new database user IDs in the clone may be different from those of the image.

The answer

You can use IBM Power Systems virtualization and orchestration solutions to address these challenges. The image can be a generic VM with all of the configurations done externally and used by the installer upon cloning. Those configurations are set outside the image and are modifiable prior to cloning, to be honored during the cloning process. They dictate the version of the database to be installed, how much storage is needed, along with the rest of the necessary database instance customizations. So, ultimately, you end up with one solution that fits all (types, versions and sizes).

For Oracle, you can have a solution that handles the traditional deployment of 11g and 12c as well as the containerized version 18 of Oracle atop AIX. You can also use this technique for an automated Oracle RAC deployment.

For clients interested in exploring EDB as an alternative enterprise-level relational database management system (RDBMS), it’s quite simple and streamlined to get either version 9.6 or 10.2 of EDB. The solution currently also includes MongoDB, CassandraDB and MariaDB. Furthermore, adding a new Open Source Database to the solution package is straightforward.

The bottom line: Rapid database provisioning

IBM Systems Lab Services consultants have experience deploying “as a service” cloud database solutions both for Oracle on AIX as well as MongoDB and MariaDB on Linux on Power Systems. Our clients can leverage a streamlined process for rapid database provisioning as well as resource reutilization. The time for provisioning a new standalone Oracle ASM database instance can be reduced from hours or days to just minutes.

Are you ready to adopt?

If you’re ready to adopt a cloud database solution on IBM Power Systems, contact us today and it will be our pleasure to help you take your database provisioning to the next level.

Was this article helpful?

More from Cloud

A clear path to value: Overcome challenges on your FinOps journey 

3 min read - In recent years, cloud adoption services have accelerated, with companies increasingly moving from traditional on-premises hosting to public cloud solutions. However, the rise of hybrid and multi-cloud patterns has led to challenges in optimizing value and controlling cloud expenditure, resulting in a shift from capital to operational expenses.   According to a Gartner report, cloud operational expenses are expected to surpass traditional IT spending, reflecting the ongoing transformation in expenditure patterns by 2025. FinOps is an evolving cloud financial management discipline…

IBM Power8 end of service: What are my options?

3 min read - IBM Power8® generation of IBM Power Systems was introduced ten years ago and it is now time to retire that generation. The end-of-service (EoS) support for the entire IBM Power8 server line is scheduled for this year, commencing in March 2024 and concluding in October 2024. EoS dates vary by model: 31 March 2024: maintenance expires for Power Systems S812LC, S822, S822L, 822LC, 824 and 824L. 31 May 2024: maintenance expires for Power Systems S812L, S814 and 822LC. 31 October…

24 IBM offerings winning TrustRadius 2024 Top Rated Awards

2 min read - TrustRadius is a buyer intelligence platform for business technology. Comprehensive product information, in-depth customer insights and peer conversations enable buyers to make confident decisions. “Earning a Top Rated Award means the vendor has excellent customer satisfaction and proven credibility. It’s based entirely on reviews and customer sentiment,” said Becky Susko, TrustRadius, Marketing Program Manager of Awards. Top Rated Awards have to be earned: Gain 10+ new reviews in the past 12 months Earn a trScore of 7.5 or higher from…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters