Book of the Month: High Availability in Oracle Database 11gR2 (2nd Ed)

In times like these the basic engineering concepts and practices behind bundled products seem to be fading away, but for those hard skilled professionals, the clock of innovation is always ticking. New product features help IT professionals make more in less time, but when it come to High Availability in Oracle Database environments you have to give a step back and have a bird’s eye view before you get your hands “dirty”.

The book that came to my hands before the summer, called “Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard” is a perfect example of the kind of book busy people need these days. Broad in terms of technologies covered, but focused in terms of what do we need to accomplish with these technologies.

Although the OVM and OEM chapters are a bit dated after the recent announcements of OVM 3.0 and OEM 12c, the rest of the book is a great hands-on experience. It covers the three basic technologies in HA: ASM, RAC and Data Guard. How-To Workshops, with the assurance that these are proven and tested by the MAA Group inside Oracle Corp.

If you’re a technical architect, a DBA or an IT Manager and you own Oracle Databases in your IT environment, you should get this book and actually go through the best practices and make sure your organization implements them.

 

LMC

 

Book of the Month – “Oracle GoldenGate 11g Implementer’s Guide” by John P. Jeffries

My relationship with Oracle Golden Gate is first emotional and then professional. My Oracle Corporation boot camp was in Ireland in early January 2010 after Oracle had acquired Golden Gate, and so most of my boot camp mates were from the EMEA Golden Gate team! We rarely talked tech stuff when in front of a pint of Guinness, but when the sales reps would talk about the product “Golden Gate”, I could see in their eyes all the excitement and admiration for a true great engineering product. This is a rare thing. You tend to see passion for a software product in the eyes of the techies and less in the eyes of a pure sales team. This admiration somehow got into me without even experiencing the wonders of the product. You can say they were a great sales team, making me believe in the magic of a software product I’ve never saw in action! Kudos to Richard Dobber, Steve Roy, Rolf Linder, and most of all Mr. Todd McGrail.

This somehow got into the boot camp main trainer’s mind too, and also because he wasn’t quite fluent in it yet, he asked the main man (Sjaak Vossepoel) to make a presentation about Golden Gate. That blew our minds even further! Knowing all the use cases, and customer case studies made us all believe this was not just another Oracle acquisition, but a first class product that would change the data distribution landscape in the Oracle arena for ever.

When back to Portugal I had the pleasure to work with the Portuguese Oracle Data Integration “guru” Octavio Oliveira, and he confirmed me all the qualities of the product, and so I got some time to get my hands dirty with it, and started to admire all it’s qualities too.

It seemed that I was somehow linked to Golden Gate (kind of fate!) when in April 2010, I was in Berlin for an Exadata EMEA training event and I met the only key guy on the former EMEA GG team that missed the boot camp: Kuli. He was one of the presenters of the event, like myself, and in the end of the day we had the opportunity to share a beer and talk a bit more. I got to admire not only the product but also the people behind it, at least in EMEA.

Another boot camp “blood brother” I’ve met again later in a Golden Gate workshop in Paris, in late 2010, was Christophe Ishkanian. He is not just a “guru” in GG, he explains it very well and he can show you in simple terms all the power of this singular product. He evens puts up with my occasional texting with last minute doubts!

So when this book reached my hands I knew I had to share the news with the world ;-)

Looking a bit further into the author’s CV, you cannot expect nothing less than a top quality book. Specially because he is not your average blogger or Oracle Professional (former Oracle ACS Engineer), the man has a true talent for writing about technical matters.

From the book: “With over 15 years of Oracle experience, and an OCP since Oracle 8i, the author has extensive knowledge of Oracle databases, including Enterprise Linux and RAC, coupled with the ability to design and build high performance distributed database systems. He has trained internal and external clients in Data Warehousing and Data Replication techniques, and continues to share his knowledge and experience through his own website: www.oracle11ggotchas.com

Picking up the book what I admired the most is the way it is organized. Chapter 1 gets you started introducing all the key concepts, but right on chapter 2 you’re installing it and preparing the data sync. The choices are overwhelming! So you got to decide yourself on what is the right design for your solution and that’s what chapter 3 gives you. So you can deploy it without mistakes chapter 4, 5 and 6 will guide you through the configuration techniques, until you hit the Golden Gate and Exadata on chapter 6, that might make you go deeper in chapter 7 if you will apply some kind of advanced transformations to your data.

After all is set, you need to monitor it (chapter eight) and eventually tune it for better performance (chapter 9). Don’t forget to jump right into chapter 10 if you can’t troubleshoot your Golden Gate configuration. There you can also find a section on how to upgrade your GG product.

The end is quite surprising since after two Appendixes of command syntaxes, scripts, and files dictionary, you have a true master’s voice on how OGG will evolve in the future with very useful URLs for places on the web where you’ll find discussions about this theme.

The book publisher is so amazing that they even prepared a 23 page PDF with a sample of the book, that you can download here.

You can buy this great book here: http://link.packtpub.com/gKfFaF

Good reading!

LMC

Book of the Month: “Achieving Extreme Performance with Oracle Exadata” by Robert Stackowiak et all

It has just landed in my hands, the first book written about Exadata ! Finally all the technology I’ve been working in the past 16 months has gone mainstream in terms of knowledge sharing.

Writers Rick Greenwald, Robert Stackowiak, Maqsood Alam and Mans Bhuller with foreword by Juan Loaiza and technical editing by Kevin Closson, Maria Colgan and Tim Shelter.

And impressive concentration of talent ;-)

Ten chapters that will give you a complete vision of what does the Database Machine (DBM) solution is all about. From the Oracle Database options and the actual Exadata Storage Software, passing through the best practices to manage the DBM, until the deployment of either a Data Warehouse or a OLTP system. The book finishes with two very important chapters that address the consolidation design and techniques available, and the best strategies to migrate your database on to the DBM.

This is a must buy book for anyone already working with DBM or that just wants to know more about the magic of this quantum-leap product.

You can buy the book here:

LMC