Tuesday at OpenWorld…

Despite feeling under the weather I managed to get in a pretty full day…

Oracle VM Scalability and Manageability with HP

Takehome messages:

  • Paravirtualization (PVM) works at near base hardware speed.
  • Hardware virtualization (HVM) is significantly slower than paravirtualization.
  • HVM can have up to 8 LUNs, while PVM can have up to 26 LUNs.
  • Oracle VM scales well. In the test shown, 5 VMs give better throughput than 1 large VM.
  • Live migration speed is dependent on the size of the SGA, how quickly its contents are dirtied and the speed of your network.

Deploying High Availability in Virtualized Environments with Oracle VM

Takehome messages:

  • Do any NIC binding and multipath configuration in Dom0 so it is available for all VMs on the server.
  • Clustered active/passive with automatic failover can be configured using Oracle clusterware.
  • Deploy servers in pools, each pool having a master. The VMs are not affected by the VM Manager being down as the master servers can still communicate.
  • OVM 2.1.2 can now have VM Manger database on an external server, not on the OVM Server box.

Some of this talk passed me by as it was dealing with such large amounts of hardware I was starting to get server-envy. 🙂

Current Trends in Real-World Database Performance

This session was an introduction to the two session I’m down to see on Thursday. Nothing new hear, really just a primer. Even so, it was easy listening.

Top 10 Things You Wanted to Know About Automatic Storage Management but Were Afraid to Ask

I don’t use ASM much, so I expected there to be some new stuff here for me. As it happened, the session was a basic primer. It seemed to go down quite well with the audience, many of who I expect are just venturing into the world of ASM. I suppose I should have written down the 10 things so I could post them, but I couldn’t be bothered. I don’t think anything was mentioned that was not already in my 10g and 11g ASM articles. There are also some whitepapers on OTN.

That was it for the talks…

I bumped into Slavik Markovich of Sentrigo towards the end of the day. He used his Jesus phone to get me directions to the Oracle ACE dinner. Nice one!

I was a bit late for the Oracle ACE dinner, but I was glad I made it. It was a good night and I got to talk to a few new people. Big thanks to the ACE program for making the effort!

Cheers

Tim…

Cancelled my Unconference session…

I’ve decided to pull out of my unconference session. The main reason for this is I started to feel a little unwell last night. I got back to the hotel at 19:00, threw up and went straight to bed. I was hoping it was just because I was over-tired, but this morning I have a runny nose and dodgy throat. I’m now on Theraflu, which is similar to Lemsip, and I’m going to play it by ear today. If I feel rough I will head back to the hotel early.

The events, or lack of, last night meant I missed the OTN Night and InstallFest. I’m not sure if I will be up to this evenings stuff. I guess we’ll see.

I place the blame firmly on the recycled air in the aeroplane and the number of people I’ve shaken hands with. 🙂 I’m going to stop touching people… 🙂

Cheers

Tim…

Oracle, Open Source and Virtualization…

Due to other commitments, I only made it to 2 presentations today…

Executive Panel: Oracle and Open Source:

The session was a seeded question and answer session to highlight Oracles commitment to “Free” software downloads, Open Source and Open Standards. If you follow the subject areas, I guess you know the score. The standout points for me were:

  • InnoDB and BerkeleyDB are have continued investment.
  • The linux kernel community is really happy with the work being done by Oracle. Oracle are not considered an evil empire by the inner circle.
  • The new Windows drivers for Oracle VM are currently in use within Oracle. No fixed release date, but they are on their way, so Windows performance under Oracle VM should improve when this is released. The were expected some time ago, but Microsoft have revised a bunch of APIs, so they had to be rewritten.
  • Oracle VM has supported Live Migration of VMs since it was released, but this is a manual process. Something similar to VMwares automated VMotion will be introduced at some point, but it will probably be under the control of Enterprise Manager/Grid Control, not part of the Oracle VM product itself. The impression I got was that this is a feature they want, not one that is in development, so don’t hold your breath.
  • Oracle are continuing to invest in a variety of Open Source products and Open Standards. Obviously they have their own interests at heart, but being open source means it is helping the Open Source community generally. If Linux get’s better, Oracle benefit, but so does everyone else.

Oracle Database in a server virtualization environment

A general run through current support/certification of virtualization by Oracle. Standout points include:

  • In addition to Oracle VM, Oracle support a variety of hardware partitioning and OS partioning methods provided by the big UNIX vendors. There was a URL of a certification matrix on OTN, but I can’t find it now. 🙁
  • Oracle support dynamic resource configuration in single instance databases. So you can alter the number of CPU’s and amount of memory allocated to a VM and Oracle will notice and work with it. Some of this was possible since 9i, but there were issues. It’s now solid for 10.2.0.4 (+ patches) and 11.1.0.7.
  • Oracle support RAC on Oracle VM, but the configuration is quite limited at the moment. The RAC must be 10.2.0.4 on OEL 5.1 or above and be running on OVM 2.1.2. In addiiton it must be paravirtualized and is only supported in static mode, so there are no dynamic changes to CPU or memory and no live migrations. I assume over time some of these restrictions will be lifted and 11g support will be added.

As far as best practices go, I guess most of it was pretty standard:

  • Don’t overcommit resources. You can’t expect good performance if you have 1 core running 5 VMs.
  • Standard CPU, memory, I/O and network sizing/thoughout considerations still apply.
  • RAC should use dedicated NICs, not shared ones.
  • NIC bonding best done at hypervisor level (Dom0), not at the VM level.
  • All VMs, especially RAC, need time synchronization (NTP).
  • Use native physical devices and multipath or NFS. This will perform much better than virtual disks.
  • Oracle still recommend consolidation of databases, rather than many small databases/instances. Only split things into multiple VMs, database or instances when it is necessary, otherwise you are wasting resources.
  • Expected performance will depend on platform, application type, workload type and resource allocation.

The licensing issue will no doubt catch many people out. Oracle doesn’t recognize software virtualizations ability to limit processing to specifc processors or cores, so by default you must license the Oracle software for all cores on the system when using software virtualization. Those platforms which support hard partitioning (big UNIX vendors) can use per-core licensing. If you plan on using a server just for VMs running the database, this is fine, but if you want to run half database and half app server you will be buying double the CPU licenses that you are using. Bummer. 🙁

Update: A talk this morning says pinning the VMs to specifc cores is within the spirit of the licensing agreement. Nice to see a consistent message… Not! 🙂

Cheers

Tim…

OpenWorld Unconference Session…

Update: I had to change the time slot… 🙂

I’ve signed up to do an Unconference session on Wednesday 10:00 in Overlook C. The session is called, “Virtualization: What is it and why should you care?

It will be about 30 minutes presentation, then a discussion. It’s an overview session and not product-specific. Hopefully it will generate some interest. 🙂

Cheers

Tim…

Oracle ACE Directors Meeting…

Today was the Oracle ACE Directors meeting from 10:00-16:00.

Database:

As far as the database was concerned, I was hoping we would get a sneak preview of the much hailed “Big Announcement” planned for Larry Ellison’s keynote speech on Wednesday. Unfortunately all attempts to draw something out of Mark Townsend resulted in phrases like, “Wait until Wednesday!”

This is certainly increasing the intensity of speculation. I just hope it lives up to the hype. At least it’s hype about the database I suppose. 🙂

There wasn’t much on a technical level I’ve not already covered as part of my 11g OCP notes, but there were a few things that helped me understand the bigger picture of what Oracle 11g is trying to achieve. It just puts things into context a bit, rather than thinking of things as individual features.

Other snippets include:

  • The 11.1.0.7 patchset comes with a little something extra. The Graphical Explain Plan Monitor from Grid Control is now part of Enterprise Manager. Mark did a demo of this feature and it looks really neat.
  • The 11gR2 beta program is just about to start. I was kinda expecting an announcement about 11gR2 during the conference, but it seems this is a little way off yet.
  • There were a multitude of, “we may or may not be announcing this feature this week”, statements. I’m not sure what can be published, so I’ll just point you to Lewis Cunningham, who has already listed some of them. 🙂

Middleware and Apps

As far as the middleware and applications were concerned, I’ve come away feeling more confused than when I went in. The recent aquisitions mean there are a whole bunch of overlapping products and it is not always clear which you should pick. All products will eventually have a smooth transition to 11g Fusion Middleware, but that is some way off. Currently, it feels safer to keep your head in the sand and wait for 11g Fusion Middleware. That said, I think what they will end up with will be a killer app server… probably…

I’m feeling relatively in the swing of the SF timezone, which is a big improvement from last year. So it’s out to meet the bloggers later. A couple of years ago this was a small affair. It seems like this year half the conference will turn up. 🙂

Cheers

Tim…

Stuck in Frankfurt…

I’ve not made my connection to San Franciso. 🙁

What seems to have happened is when Oracle Travel booked the flight with Star Alliance, they booked the first leg with Lufthansa and the second leg with United via Lufthansa. Lufthansa had me on list of passengers, but United didn’t. It was a United plane and I wasn’t on the list so they wouldn’t let me on and it went without me. I’m now sitting in Frankfurt airport waiting for Oracle Travel and United to work out what happens next. I was told by one of the booking desk guys that the flights tomorrow are already fully booked, so I might be here for a couple of days… 🙁

If you were expecting to meet up with me at OpenWorld, don’t hold your breath…

Cheers

Tim…

I’m leaving on a jet plane, don’t know when I’ll be back again…

Actually I do know when I will be back, but I wanted to carry on with the line from the song. 🙂

Just thought I would write to say article production and forum duties will probably be very limited over the next couple of months as I’m doing a bunch of conferences. Sorry if this inconveniences anyone, but you get what you pay for… 🙂

My family will be reading the blog to check I’m still alive, so there will be lots of, “I’m still alive”, type posts. I’m sure most of you out there are used to my off-topic ramblings by now anyway. 🙂

So it’s off to OpenWorld first…

Cheers

Tim…

Oracle ACE Office Hours in the OTN Lounge…

There are going to be even more ways to meet Oracle ACEs at this years OpenWorld. The OTN Lounge is going to have some time slots where you can meet and chat with Oracle ACEs about any subject you want. See here:

Some Oracle heavyweights have already signed up for the sessions. If you’re and ACE, sign up. It’ll be fun.

Of course the most important thing is that people turn up with questions. Don’t be shy… 🙂

Cheers

Tim…

Quick life and presenting update…

Just a quick post to let people know what is going on in the next few weeks/months…

UKOUG DE SIG

I’m speaking at the UKOUG DE SIG on the 10th July. Andrew Clarke had a free slot so I offered to speak to help him out. I owe him a few favors and it is on my doorstep.

I had a bit of a panic last night while I was rehearsing the talk. My laptop died and I ended up having to uninstall and install VMware Server. Not what you want to happen the week before a talk. As a backup, I’m going to use PortableApps to have my talk on a USB stick just in case. I won’t be able to run the demos, but I will have expected output ready to go just in case. Hopefully, the laptop will be fine and I won’t need it. 🙂

OpenWorld 2008

I’m speaking at OpenWorld 2008 as part of a group presentation organised by Lewis Cunningham. The lineup is Lewis Cunningham, Eddie Awad, Mark Rittman, Arup Nanda, Rich Niemiec, Bradley Brown, Hans Forbrich and myself. As you would expect with so many speakers, it’s a panel format, not a formal presentation. Should be fun.

I’m not sure if I’ll do the Unconference this year. I would like to, but I think it’s a bit unfair of me to hog a slot that someone new could use. If the uptake is slow I’ll jump in there.

I’m registered for OpenWorld and I’ve reserved my hotel room. I can’t book my flights until I know what’s happening with the AUSOUG and NZOUG events.

AUSOUG & NZOUG

I’m waiting to hear if I’ve been accepted to speak at the AUSOUG and NZOUG events this year. I’ll post more about this when I know. If I do it’s going to be a pretty hectic schedule. One of the percs of quitting your job is you have lots of free time to do conferences. 🙂

Life Update

The last person from my office quit work on Friday, so I’m now alone in the dungeon for a couple of months before I leave. I’ve been taking servers out of racks and rebuilding them for deployment in a new site. I can do RHEL, DB and AS10g installations in my sleep now. Yesterday I was setting up a system consisting of a database, two middle tier app servers and two front end web servers. It’s all sitting on the desk next to me making an awful noise. It was overloading my air con, so it was kinda tropical in here. 🙂

Today is the start of my final year of being 30-something. Happy birthday to me. How am I going to celebrate you ask? I’m teaching two Yoga classes to cover for someone who’s ill. Not exactly what I had in mind. 🙂

Cheers

Tim…