Pythian has openings for MySQL and MS SQL Server DBAs in each of our offices in Ottawa, Canada; Boston, USA; Dubai, UAE; and Hyderabad, India. If you are a MySQL and/or SQL Server DBA and would like to evaluate this opportunity, please send us your résumé with an introductory paragraph to hr@pythian.com.

Inside RAC… Toilet Paper

By Alex Gorbachev November 21st, 2006 at 1:39 pm
Posted in Group Blog Posts

It will take me a while to follow up on all the presentations I’ve visited during UKOUG06 and photos I’ve taken. One of the best presentations was Inside RAC from Julian Dyke. You can find it here if you don’t have access to UKOUG06 archive.

However, the fun part you won’t get unless you’ve been on his presentation. It turned out that toilet paper is an integral part of a RAC cluster. Just go to give you an impression (more pictures here):

Inside RAC - toilet paper-8

Inside RAC - toilet paper-10

Inside RAC - toilet paper-3

The performance with participation of few volunteer was great. Cones on the heads indicated the role of the nodes for a certain block during a particular operation. Square label with an SCN number of it is an image of the block. Toilet paper marked the path of the block.

Very quickly the scene became a mess of toilet paper which wasn’t of very high quality. This leads to a real life hint - make your interconnect rock solid and reliable.

Another issue is that some “nodes” were busy quite with several activities and blocks/cones/toilet paper ends were falling out of their hands. This is another lesson - make sure your nodes have enough CPU capacity and not totally occupied with something else (read short on CPU).

All in all it was a great performance. Artists?

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Google
  • del.icio.us
  • Facebook
  • bodytext
  • Technorati
  • TwitThis
  • Reddit

3 Responses to “Inside RAC… Toilet Paper”

  1. Pythian Group Blog » Blog Archive » ORADEBUG TRACE UKOUG_EVENING STATE DUMP, DAY 1 Says:

    […] 2AM and I’m off to bed early — somewhat unusual compare to my past UKOUG experience but hey, I’m presenting tomorrow. My session on RAC Connection […]

  2. Pythian Group Blog » Blog Archive » SELECT * FROM V$UKOUG WHERE DAY BETWEEN ‘04-DEC-07′ and TO_DATE(‘05-DEC-07′)+0.5; Says:

    […] Inside Interconnect. Interesting what it will be this time but last year I really enjoyed his session. I’m also looking forward to deadlocking with Mark Bobak. The last session would be either of […]

  3. Back from UKOUG 2007 « Summersky RAC Notebook Says:

    […] year his presentation focused on Interconnects. Was excellent as usual. Here is a another view from Alex’s blog on this […]

Leave a Reply

Filling out the following captcha not only allows us to cut down on automated blogspam but also helps digitize books. Please feel free to send comments on this approach directly to Paul at vallee@pythian.com.

NOTE: After submitting your comment, verify that it is added to the blog. New comments will be marked as "waiting for moderation" (we only moderate for spam). If the level of spam is as low as we hope, we will bypass this step.