Wednesday Feb 11, 2015

Cross-Site Load Balancing - Prerequisites and Steps to Be Performed

Summary of the Prerequisites and Steps to Be Performed


Let’s consider the following configuration:

Site A: Primary is replicated by Active Data Guard to Site B: Secondary

Site B: Primary is replicated by Active Data Guard to Site A: Secondary

Let's assume that we have a pdb (MY_PDB) which runs on Site A: Primary. If, for example the workload is too high on Site A: Primary and a specific SLA can not be fulfilled, we can perform the following steps in order to move MY_PDB to Site B: Primary where the SLA can be met:

1. Stop MY_PDB on Site A: Primary and Site B: Secondary(Log files will continue to apply in MOUNT DB Mode)

2. Unplug MY_PDB from Site A: Primary

3. Copy XML manifest to the other site – Site B: Primary

4. Setup aliases on Site B: Primary and Site A: Secondary

5. Ensure media recovery (MRP) is running on the Site A: Secondary

6. Plugin MY_PDB on Site B: Primary

7. Check MY_PDB was replicated on Site A: Secondary

8. Open MY_PDB on Site B: Primary

9. Open MY_PDB (Read Only) on Site A: Secondary (if Active DG is running)

10. Drop MY_PDB on Site A: Primary (keep Datafiles)

These steps show that load balancing across sites is possible using a combination of Oracle Multitenant and Oracle Data Guard. When coupled with the flexibility offered by Oracle Real Application Clusters for local site management, it is an excellent example of the level agility and flexibility that enable a full-featured Database as a Service deployment.

Wednesday Nov 12, 2014

Compare and Contrast (and mix-n-match) Oracle's SPARC V12N choices

new white paper from Oracle's Elite Engineering Exchange team provides an excellent guide to the different virtualization technologies available on SPARC platforms, including guidance on when to employ each - either alone, or in combination with another technology.  PDoms, LDoms, and different flavors of Solaris Zones are evaluated in terms of

  • Security Isolation
  • Resource Isolation
  • Efficiency
  • Availability
  • Serviceability
  • Flexibility
  • Agility


Although the paper is not specific to database deployments, the key points apply to all workload tiers.  And while the discussion is on SPARC technologies, many points apply to all virtualization technologies.  For example, from our DBaaS perspective, the following quote from the paper couldn't say it better:

"When a traditional  monolithic virtualization approach is taken where machines are mapped one-to-one to virtual machines, there is no overall reduction in the operational complexity of the system, because there are still the same number of entities to be managed ... the aim should be to consolidate workloads, not simply to consolidate machines, because it is workload consolidation that will drive the operational efficiencies of the data center."

 This summary from the paper shows the full scope of the discussion - the paper looks at each of these rows in detail, and finishes with an evaluation of the combinations that make sense (and when they are indicated).  Great reading for anyone looking to consolidate workloads onto SPARC platforms.



Tuesday Sep 30, 2014

Oracle Database Learning Steam Video - DBaaS Service Catalog

I recently had the good fortune to record a video on Service Catalogs for Oracle University's Oracle Database Learning Streams series. The video is roughly 30 minutes long and covers the basics of catalog and service definitions, and introduces our standardized service offerings for Oracle DBaaS in a private database cloud.

The video is one of many which you can view in its entirety simply by registering with Oracle University.

All the Database Streams videos are located here.

Wednesday Sep 10, 2014

A new guide to Database as a Service

A new two-part "workbook" is now available to guide your journey to delivering a private database cloud.  Insights from IDC, e-DBA, KPN and the State of Texas provide real-life counsel from seasoned experts at the forefront of the industry's shift to cloud.


Transforming Your IT Environment with a Database Cloud Delivering Database as a Service to Your Organization


Enjoy the read and if you have follow-up questions or comments, you know where to find me ...

Friday Sep 05, 2014

New whitepaper: Database as a Service Reaches New Heights of Efficiency

An IDC research vice president, senior Oracle product managers and a solution provider's technology director explain how Database as a Service Reaches New Heights of Efficiency by leveraging the latest technologies in Oracle Database 12c. 

Thursday Aug 28, 2014

Focus On Documents for DBaaS topics at Oracle OpenWorld 2014

The speaking sessions and hands-on-labs for this year's Oracle OpenWorld are now scheduled, and a good way to find the items you're interested in is to check the FODs that cover your areas of interest.  Two are especially relevant for Database as a Service in private clouds -

 Database as a Service

 and

EM 12c Private Cloud and Lifecycle Management

There is some overlap between the two lists since the topics converge at several private database cloud requirements.  But make sure to check both so you don't miss anything that can help you in your journey to cloud.


Wednesday Jul 23, 2014

Rapid Home Provisioning Simplifies Oracle Database Estate Management

Provisioning, patching and upgrading databases across an enterprise is often performed individually on each database in the estate.  As the estate grows, this becomes a time-consuming and error-prone activity. 

Rapid Home Provisioning, one of the many new features and improvements in the just-released 12.1.0.2 version of Oracle Database, addresses this problem by simplifying and streamlining database maintenance.  With RHP, you create a single standard Oracle home by applying a new patch level once. This reference home can then be used to rapidly deploy new databases and to easily update hundreds to thousands of existing databases with a single command, without the need to apply the patches to each.  Optimizations for networking and storage use make this a very fast and efficient solution.

Learn more in the Clusterware Administration and Deployment Guide and in the OOW 2014 speaking session.


Wednesday Jun 18, 2014

A Thought Experiment Showing the Value of Separating the Business and Technical Catalogs

One common error when creating a business catalog is to expose the underlying technologies that should be mentioned only in the technical catalog.  For IT professionals whose day-to-day lingo is based on products and features, this is an understandable mistake.  And from their perspective, perhaps not at all noteworthy.

Imagine a large enterprise's business catalog which covers all the different types of workloads and storage models the enterprise deploys - OLTP, Data Warehouse, batch and real-time analytics, structured and semi-structured data -- so far so good.  Now suppose that the business catalog exposes the database and analytic engines delivering each type of data source.  This might look OK if the expected vendors and products appear in the appropriate slots.   But what happens when a vendor takes a big leap forward and is now the new best choice to deliver a given service?  Once IT is ready to make that shift in their delivery model, they will need to update the business catalog accordingly.   This is typically not the kind of the change consumers are eager to see.  Instead, they should only see the lower costs and higher SLAs that IT can now provide - without being led to worry about the changes behind the scenes.

This is exactly the scenario that a product-centric business catalog might be facing soon, thanks to some upcoming releases at Oracle, namely, Oracle Database In-Memory and the Big Data Breakthrough.  And the innovation won't end there.  So make sure your business catalog takes the future in to account with the right structure (and of course the right products to support the business services!)


Sunday May 18, 2014

IOUG Webcast recording posted: How to Create a Service Catalog for DBaaS

In case you missed the 6 May 2014 webcast sponsored by the IOUG, you can now view the recorded webinar.

If you have any problems viewing the webcast in Firefox, give IE a try - that worked best for me.

Comments?  Questions?  Leave a note here on the blog, or on the IOUG Cloud SIG forum!


Tuesday Apr 22, 2014

IOUG Cloud Computing SIG Techcast: Database as a Service (DBaaS): How to Create a Database Cloud Service Catalog

Please join us on Tuesday 6 May 2014 at 10:00 am PT for an IOUG-sponsored webcast on Service Catalogs for Oracle Database deployments.  Our audience is anyone interested in providing Oracle Database as a service to their consumers.

A good service catalog is essential for IT service delivery.  We will give an overview of service catalogs, and explain what makes a good catalog in general, and specifically for DBaaS.

We will then present a standardized set of service offerings for Oracle DBaaS which providers can use as-is, or tailor to their needs.  Our goal is for providers to leverage these details to jumpstart their DBaaS initiatives on the right path.

Register here ... and watch for the replay if you're not able to join live.

Thursday Jan 02, 2014

Some light reading while the clouds lift

In case you took a break over New Year's and aren't quite ready for "real" work, but still feel obligated to visit sites such as this one, here's a reward for your efforts.  (If you're ready for serious work, the following may disappoint you.)

I've been working in this database cloud / DBaaS area for a few years now.  One of the perks is the term itself:  adding cloud images to presentations is pleasing, exchanging meteorological puns and banter is entertaining,  etc. etc.  I do have one issue with the term though - it's too close to my last name.  And thanks to my poor typing skills, plus autocorrect, plus inopportune inattention, it's not unusual for me to swap "clouse" for "cloud" - such as when registering for an event last year.  When I approached the check-in table to get my expo badge, it took three registration workers to eventually figure out that I had registered as "Burt Cloud".  It was nice to see the harried staff have a good laugh, but when they insisted I present an ad lib keynote I had to flee to the booth.

But back to the positives.  Being associated with 'cloud' encourages friends and colleagues to share anything about moisture in the air, such as this amazing video.  Enjoy and Happy New Year!


Monday Dec 30, 2013

New Year's Resolution: learn more about Oracle Database 12c

 Interested in learning more about Oracle Database 12c's Multitenant option?  Here's a great opportunity to help kick off the new year:

Independent Oracle Users Group (IOUG) Oracle EM Techcast: DBA Best Practices for Performance Tuning in a Pluggable World

Thursday, 9 January 2014, 10 am PT

In Oracle Database 12c, a container database (CDB) can host up to 252 pluggable databases (PDBs).  This presentation look at the performance aspects of this deployment option:

• Best practices for DBAs
• Tuning and configuration tips
• New features

Featured Speaker: Julian Dontcheff(*), Head of Database Management & Exadata Lead for EALA (Europe, Middle East, Africa and Latin America), Accenture
*Oracle Certified Master and an Oracle ACE Director

Sunday Dec 08, 2013

Why DBaaS will be one of 2014's technology headliners

As you settle in to some holiday reading and prepare for 2014, a recent blog and several blogs it connects to will be of interest.  Check out this OracleVoice blog on Forbes.com:  "Why Database As A Service (DBaaS) Will Be The Breakaway Technology of 2014".

From the entry's introduction:

"Database as a Service (DBaaS) is arguably the next big thing in IT. Indeed, the market analysis firm 451 Research projects an astounding 86% cumulative annual growth rate, with annual revenues from DBaaS providers rising from $150 million in 2012 to $1.8 billion by 2016."

 The  article explores the benefits of DBaaS and some of the key enabling technologies, such as Oracle Multitenant, which promises to be a game-changer as Oracle Database 12c adoption rises.


Friday Oct 18, 2013

Service Catalogs for Database as a Service

At the end of last month, I had the opportunity to present a speaking session at Oracle OpenWorld: Database as a Service: Creating a Database Cloud Service Catalog.  The session was well-attended which would have surprised me several months ago when I started researching this topic.  At that time, I thought of service catalogs as something trivial which could be explained in a few simple slides.  But while looking at all the different options and approaches available, I came to learn that designing a succinct and effective catalog is not a trivial task, and mistakes can lead to confusion and unintended side effects.  And when the room filled up, my new point of view was confirmed.

In case you missed the session, or were able to attend but would like more details, I've posted a white paper that covers the topics from the session, and more.  We start with an overview of the components of a service catalog:

service catalog overview


And then look at several customer case studies of service catalogs for DBaaS.  Synthesizing those examples, we summarize the main options for defining the service categories and their levels.  We end with a template for defining Bronze | Silver | Gold service tiers for Oracle Database Services.

The paper is now available here - watch for updates as we work to expand some sections and incorporate readers' feedback (hint - that includes your feedback).

Visit our OTN page for additional Database Cloud collateral.

Sunday Sep 08, 2013

Database Cloud topics at Oracle OpenWorld 2013

It's that time of year again for Oracle OpenWorld, and our team is again involved in several venues where you can learn anything you need to know about private database clouds for delivering Oracle Database as a Service. These include demo booths, hands-on-labs, and speaking sessions.

These events cover a range of topics but the common theme is delivering DBaaS, so you can find all of them listed in this Focus On Document.  We hope to see you there to answer your questions and hear about your experiences.


About

The Database Cloud Architecture Team at Oracle develops and documents best practices for designing and delivering database consolidation and database-as-a-service projects.

Search

Categories
Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today