Infrastructure Blog

Consolidating Databases the Right Way: Here's How

By: Anne Plese

Director, Product Marketing, Cloud Infrastructure Database Solutions

Today's guest blog comes from Rodrigo Righetti, Practice Director at Accenture Operations.

Oracle Exadata makes consolidating databases so easy that it just seems to “happen”.

Over the last five years, I have seen amazing advancements in Oracle Database technology. Actually, ever since the launch of the second version of Oracle Exadata, I’ve seen customers leapfrog over earlier benchmarks of performance, availability, scalability, and management. Today, Exadata’s unmatched hardware and software capabilities have made it the go-to choice for running any kind of Oracle database workload, including data warehouses, analytics, OLTP – as well as a combination of these workloads. There really is no better platform to run a mixed environment.

Because it can handle any workload you throw at it, Exadata is the perfect environment for database consolidation. (Learn how by reading Accenture’s playbook for Oracle Engineered Systems.) That comes as good news for customers, since most are experiencing runaway growth in the number of databases they’re managing. With Exadata they have the option to put everything on a single platform that’s high performing, scalable, and simple to manage.

Consolidating on Exadata is easier than you think. Of course, if you’re not familiar with the platform, it helps to start by migrating your less critical environments first, and then adding more important workloads as your infrastructure team becomes more comfortable with the platform. But this shouldn’t take very long. For many of my clients, the transition is so easy that it almost seems to “happen” on its own. Well, maybe not exactly, but you get the idea. 

Of course, it never hurts to plan ahead. This is especially true for more complex engineered systems like Oracle SuperCluster. It’s also true that even when you make solid consolidation plans, you may be surprised at what happens when you actually make the move to Exadata. More than a few customers end up with a lot more headroom than expected, thanks to features like Smart Flash Cache and Hybrid Columnar Compression, which can save a large amount of space and drive big performance gains.  

As a result, customers often find they have additional opportunities for consolidation. For example, CaixaBank, one of Spain’s leading financial services companies, worked with Accenture to consolidate 17 data marts into a powerful data repository.

So the big question is, why consolidate? Everybody knows that consolidation helps you save on hardware and other equipment, not to mention license costs. That’s a given. But these savings can go even farther because the Exadata infrastructure is engineered from the ground up to be fully integrated. This means the platform’s compute, network and storage resources can be managed centrally by a smaller group. So not only do you save on capital costs, but you can also increase your productivity and cut operating overhead, giving you the best of both worlds.

There are different ways you can consolidate databases with Exadata. One is through virtualization using Exadata Cloud Machine that Oracle maintains behind your firewall, and the other is through Oracle Exadata Cloud Service. Both technologies are great.

Multitenant is really the premier consolidation feature in Oracle. Nothing else gives you the same flexibility that Multitenant can when it comes to sharing the same environment with multiple databases. Learn How Sherwin Williams, one of the largest producers of Paint and Coatings worldwide, did it.

With virtualization on Exadata, you get an extra level of isolation that was not available before. That means you can have cross-department consolidation, test-dev, disaster recovery (DR), and applications all running on the same infrastructure – with all of them taking advantage of InfiniBand network. That’s why Exadata VMs deliver near raw hardware performance.

Remember, it’s not a case of either/or. Oracle Cloud infrastructures, for example, leverage both methods of consolidation. For clients that want to dig deeper into the best way to consolidate their databases and applications, and see the improvements they’ll get first hand, we’re happy to set up a proof-of-concept at our Accenture Innovation Center for Oracle Engineered Systems.

Is consolidation happening in your organization? If so, I’d recommend taking a close look at Exadata. When it comes to cost, performance, scalability and ease of management, Exadata can’t be beat. 

Want to learn more? Listen to Matt Steinberg, Senior Principal Product Manager at Oracle and I discuss consolidation of databases on Exadata

Rodrigo Righetti is practice director at Accenture Enkitec group and a database performance engineer with almost two decades experience working with Oracle technologies. Rodrigo joined Accenture in 2014 and has been leading Accenture’s engineered systems and database practices in South America and CMT North America. He also serves as a hands-on consultant globally and is part of Accenture’s Performance and Security Healthcheck team. Check out his blog at righettidba.blog and follow his work on Twitter @Accenture and @AccentureOps

 

Coming to OpenWorld?

Don't miss these key Exadata sessions at this year's Oracle OpenWorld:

Join the discussion

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha

Related

 

Oracle Engineered Systems Home

 

About the Oracle Infrastructure Blog

 

Contact

Oracle

Integrated Cloud Applications & Platform Services