Sunday Apr 11, 2010

Virtualization at Collaborate 2010 Oracle Users Conference

Virtualization Bootcamp on Solaris Containers

Virtualization is one of the hottest areas in IT today.  Understanding how to leverage virtualization in database and middleware infrastructures is becoming a fundamental skill for DBAs, Application Server Administrators and System Administrators.  Along with the virtualization events we are hoping to put together an additional expert panel or birds of a feather to see how we can optimize virtualization activities in the user community.  Below are key virtualization events during the week at at the Collaborate 2010 conference.

Sunday April 18, 2010 9:00 - 3:00 pm - Sun Virtualization Technology for Oracle Professionals

Starting virtualization with bang for the conference is this technical deep dive containing key leaders in the user community, Oracle VM and Sun Virtualization groups.  Attendees will learn the benefits of using virtualization to facilitate the management of database and application servers. You will learn the Basic terminology, features, benefits and challenges of virtualization in the Cloud. Key fundamental skills in virtualization through Solaris containers and logical domains. Understanding the new paradigm of virtualization in a database and cloud environment. Multiple demos/labs will develop technical skill and the deep dive will wrap up with a panel of experts.

Key speakers include:

  • George Trujillo - Oracle Corporation
  • Steve Lemme       - Computer Associates
  • Sam Brunacini     - Serverware Corporation
  • Bob Netherton     - Oracle Corporation (Author:  Solaris 10 System Virtualization Essentials)
  • William Leonard - Oracle Corporation (Solaris VM team)


Virtualization during the week at Collaborate 2010

Monday, April 19
10:45 am - 11:45 am     728    Experiences using VM on System z, the Infrastructure of Oracle
10:45 am - 11:45 am     749    Oracle Solaris and Oracle Virtualization

Tuesday, April 20
8:00 am - 9:00 am     1    Oracle RAC on VMware
10:30 - 11:30 am     748    Oracle Virtualization: From Desktop to Data Center
2:00 pm - 3:00 pm     14    Oracle on VMware Customer Case Study
3:15 pm - 4:15 pm     752    Virtualizing Your Application Environment: Which Virtualization Option is Right for You

Wednesday, April 21

8:00 am - 9:00 am     714    Yes, Production Databases Run In Virtualized Environments - Virtualization and the DBA
11:45 am - 12:15 pm     16    Virtualizing your Oracle E-Business Suite Environments
1:00 pm - 2:00 pm     17    VMware and Oracle: A Licensing and Support Overview
2:15 pm - 3:15 pm     432    Virtual Private Database and Using Oracle Application Contexts
4:00 pm - 5:00 pm    732    Understanding, Building and Using Virtualized Oracle/Sun Environments

Saturday Feb 13, 2010

The Journey Continues

I was a leader in the Oracle community who joined MySQL two years ago to learn more about the open source world.  The two years at MySQL were fantastic.   The extraordinary camaraderie, spirit and energy of the company was unbelievable.  I worked with some fantastic people and made a number of life time friends.

On Monday I become a full time employee of Oracle, so I've come full cycle.   Everybody is very excited about the incredible potential of Oracle and Sun and what we are going to accomplish together.   Oracle employees are enthusiastically welcoming Sun and MySQLers into the Oracle family.  

I am really looking forward to continuing my journey.   I look forward to seeing you in RAC, Data Guard, Streams, Oracle Fusion Middlware and MySQL classes.

Tuesday Jan 26, 2010

Oracle Sun Strategy Webcast

IT Superbowl

Today felt like the day before the super bowl.  With the big Oracle Sun Strategy Webinar and Steve Jobs announcing new products, January 27th feels like the IT super bowl.

Today was an incredibly busy day with all the emails and text messages regarding the Oracle Sun Strategy Webcast tomorrow (Jan 27, 2010).  Lots of energy, anticipation and enthusiasm for the event.  Tomorrow is going to be very busy with Oracle senior management outlining strategic directions with the Sun  acquisition.  I will be online with Skype, IRC, text messages and email with Sun employees, dolphins and customers.  I can't wait to hear the Oracle announcements.  Then from Steve Jobs I will find out if I should be ordering a new Apple.  At end of day I can sit down for some milk and cookies and the US State of the Union.  Definitely a full day. 

 Agenda: Oracle Sun Strategy Webcast

  • 9:00 a.m. Safra Catz: Welcome and Opening Remarks
  • Charles Phillips: Oracle + Sun: Transforming the Industry
  • John Fowler: Hardware Strategy
  • Thomas Kurian: Software Strategy
  • Edward Screven: Operating Systems and Virtualization Strategy
  • Juergen Rottler: Customer Service & Support Strategy
  •  12:15 p.m.  Lunch break  
  • 12:45 p.m.  Safra Catz: Software. Hardware. Complete.
  • Larry Ellison

Tuesday Jan 12, 2010

Sitting in on Sun Exadata Storage Engine Class

I recently sat in on a Sun Storage Exadata Storage Engine class focusing on the Sun hardware.   It was great to sit in on a class where you could listen to Sun SEs talk about the hardware and to get their insights.  As a DBA it always helps to have a deeper understanding of the environment surrounding an Oracle database server.

Everything surrounding this design is about incredible speed and scalability.  Databases in general when they need to get a record, actually load an entire block or page into memory. Each block can range from a 2k to a 16k block.   Letting the storage services load the record needed instead of the entire block it resides in is incredibly important in this age of rapidly growing databases.   A few components and features that stand out:

  • Runs on Oracle Enterprise Linux and Oracle 11gR2
  • Smart Flash Cache
  • Infiniband connectivity
  • Excellent redundancy across ports, power supplies, striping, etc.
  • Impressive hybrid columnar compression
  • Query processes done on storage side instead of server side.  Smart scans and storage indexes greatly reduce I/O.
  • Hybrid columnar compression for 10 to 50 times greater data compression
  • Smart Scans on compressed data for even faster query execution
  • Storage Indexes to further reduce disk I/Os
  • Uses ASM for storage
  • Offloading of query processing to storage using Smart Scans

It was fun to listen to debates and discussions on different topics such  as who should manage the ASM storage: Oracle DBAs, storage team or Unix administrators.  :)   Excellent class and instructor.


Sunday Apr 19, 2009

Oracle agrees to buy Sun!

Today's announcement that Oracle has agreed to buy Sun does not come as a surprise to anyone. 

  • Oracle announcement:  http://www.oracle.com/sun/index.html
  • Sun announcement: http://www.sun.com/third-party/global/oracle/index.jsp

I really can't speculate or offer an opinion at this time.   However, there are a lot of insights offered by the industry analysts that are an interesting read.

For me personally this acquisition is great news if this moves forward.   It brings together the two company's technologies where I have spent most of my career working with.

Wednesday Nov 26, 2008

Second Life: Understanding the Oracle RAC and the MySQL Cluster Architectures

This presentation will discuss key features of the Oracle  RAC and MySQL Cluster architectures.   I have gotten a lot of requests to make this presentation available outside of second life, so I am looking to see what the options are.   I will follow up with instructions if this presentation will be made available outside of second life.[Read More]

Saturday Sep 20, 2008

George Trujillo at Oracle Open World - Getting Started with Oracle Fusion Middleware

 

There is tremendous exposure to Oracle Fusion applications and the underlying technology of Oracle Fusion middleware. Yet very few people really understand what Oracle Fusion is let allow how to get started and what skills are important.   With this presentation I want to guide attendees into the path they need to follow to get them involved in the upcoming demand for Oracle Fusion technology experts.

Session Description 

This session provides direction for anyone interested in getting started with Oracle Fusion Middleware. It presents a fundamental overview of key components of the architecture and the role each component has in the middle tier. Topics include

  • The role of Oracle Application Development Framework
  • Web services
  • BPEL
  • SOA
  • XML 
  • JDeveloper or Eclipse
  • How to get started
  • Skill sets to acquire
  • Knowledge paths

The goal is to provide attendees with direction and insight for planning and attending Oracle Fusion Middleware presentations and workshops during the week.

Tuesday Jul 01, 2008

BEA Welcome and Oracle's Middleware Strategic Briefing

BEA Welcome and Oracle's Middleware Strategic Briefing 

I just finished listening to the BEA Welcome and Oracle's Middleware Strategic Briefing by Charles Phillips (President) and Thomas Kurian (Senior Vice President) at Oracle.   The BEA acquisition is going to make Oracle's Fusion Middleware stronger for Oracle's next generation Oracle Fusion Applications.  Oracle Fusion Applications are the next generation Oracle E-Business Suite, Siebel, J.D. Edwards, PeopleSoft, Retek, etc. applications.

Key Points in Briefing

The key points that stood out to me on Thomas Kurian's details of the BEA integration into Oracle and how that impacts Oracle Fusion Middleware technology: 


  • Oracle's Application Integration Architecture (AIA) is demonstrating that Oracle picked the right framework for integrating Oracle and standards based solutions into enterprise solutions.  AIA is showing flexibility as Oracle technology evolves.
  • The Oracle Integrated Development Environment (IDE) is still going to have JDeveloper as the key development tool but will also use an Oracle Eclipse Pack that will address all the BEA developers that have worked with Eclipse for years.    This allows developers have have grown up with the Oracle JDeveloper tool and open source developers that use Eclipse to choose their IDE development tool of preference.
  • Oracle ADF will continue to be a key strategic piece of developing web based applications.
  • Oracle BPEL Process Manager will continue its key role in the SOA strategy.
  • Oracle Business Rules and BAM are going to continue their strategic roles.
  • BEA technology in areas where the BEA products or components excel, are going to be integrated into the Fusion Middleware modular components.  Products like JRocket and parts of AquaLogic will strengthen Oracle Fusion Middleware in the future.
  • In areas where there is overlap between Oracle and BEA products, there is going to be some merging of products.  This is something that should surprise no one.  
Summary

Oracle has a major presence in the enterprise business applications space with products like Oracle E-Business Suite, J.D. Edwards, PeopleSoft, Siebel, Retek, etc.  So Oracle's emphasis on middleware technology for enterprise business applications is very strategic.

LAMP and GlassFish focus more on web applications.   There are three key areas of applications, Oracle business applications, SAP and web applications.  It will be interesting to watch as Sun's strategy evolves to increase its presence of web applications.

Oracle's increased presence in the middle-tier should also be a big win for Sun, Oracle's large business applications require powerful servers and storage,  areas where Sun excels.   

Friday Jun 06, 2008

Webinar: Understanding the Oracle Architecture - 2.5 Hours

I have a webinar to immerse attendees in the Oracle architecture, products, terminology and key features.  This fast paced presentation is designed to give someone with a database background, a detailed overview of the Oracle database server.   SQL Server, DB2, MySQL, Postgres, Ingres, SQLLite, etc. DBAs  and developers will get an understanding of how the Oracle database server works as well as key products and features.  At my blog   web.mac.com/george.trujillo, if you select the Oracle database tab, the key slides can be found with descriptions.  You will need to go into the archive to get  some of the podcasts.  As I get time, I will complete the audio podcasts for each slide. 

Topics include:

  • Oracle Architecture
  • Database versions
  • Database products
    • Real Application Clusters (High Availability with multiple servers)
    • Data Guard (Standby databases)
    • Streams (Data Sharing)
  •  Tools
    • Enterprise Manager (Grid Control and Database Control)
    • Data Pump
    • SQL\*Plus
  • Metadata
  • Cost-Based Optimizer
  • Backup and Recovery
    • Recovery Manager
    • Flashback
  • ETL
  • Schemas
  • Database Applications
    • PL/SQL
    • Java
    • XML
    • PHP
    • .NET
  • Fusion Middleware
    • J2EE
    • Web Services
    • Service Oriented Architecture
    • BPEL
    • XML
    • Application Servers
    • ADF
    • Frameworks

 

Wednesday May 28, 2008

MySQL versus Oracle Features/Functionality

I love working with MySQL and Oracle technologies.  Both of them are great solutions.  The point is to find the right environment to leverage what they do well for the best price/performance/scalability you are looking for.

  • MySQL is relatively light-weight, can be extremely fast when applications leverage architecture.  Lots of features stay free as the database servers grow such as replication and partitioning.
  • Oracle offers lots of feature/functionality for solving complex problems.  Supports large OLTP environments as well as VLDBs.

 Here are some of the feature comparisons from a DBA perspective.

Features/Functionality

MySQL

Oracle

Strengths

Price/Performance Great performance when applications leverage architecture.

Aircraft carrier database capable of running large OLTP and VLDBs.

Database Products

Enterprise ($) – supported, more stable.

Community (free) – more leading edge.

Enterprise ($$$$)

Standard ($$)

Standard One  ($)

Express (free) – up to 4GB

Application Perspective

Web applications often don’t leverage database server functionality. Web apps more concerned with fast reads.

More you do in the database the more you will love Oracle with compiled PL/SQL, XML, APEX, Java, etc.

Administration

Can be trivial to get it setup and running.  Large and advanced configurations can get complex.

Requires lots of in-depth knowledge and skill to manage large environments.  Can get extremely complex but also very powerful.

Popularity

Extremely popular with web companies, startups, small/medium businesses, small/medium projects.

Extremely popular in Fortune 100, medium/large enterprise business applications and medium/large data warehouses.

Application Domains

(most popular)

Web (MySQL excels)

Data Warehouse

Gaming

Small/medium OLTP environments

Medium/Large OLTP and enterprise applications.  Oracle excels in large business applications (EBS, Siebel, PeopleSoft, JD Edwards, Retek, ...)

Medium/Large data warehouse

Development Environments

(most common)

1) PHP

2) Java

3) Ruby on Rails

4) .NET

5) Perl

1) Java

2) .NET

3) APEX

4) Ruby on Rails

5) PHP

Note: Oracle focusing on Java for next generation business applications. 

Database Server

(Instance)

Database Instance stores global memory in mysqld background process.

 

User sessions are managed through threads.

Database instance has numerous background processes dependent on configuration.  System Global Area is shared memory for SMON, PMON, DBWR, LGWR, ARCH, RECO, etc.

 

Sessions are managed through server processes.

Database Server

(Physical Storage)

Made up of database schemas.

Each storage engine stores information differently.

Common storage engines:

MYISAM – stores data in .FRM, .MYD and .MYI files.

InnoDB – stores data in a common tablespace or individual tablespaces per table.

 

Binary logs are used for point-in-time recovery

Uses tablespaces for system metadata, user data and indexes.  Common tablespaces include:

SYSTEM

SYSAUX

USER DATA

USER INDEXES

TEMPORARY

UNDO

Redo and archive log files are used for point in time recovery.

Tables

Tables use storage engines.  Each storage engine provides different characteristics and behavior.

A few tables with tons of features.

Partitioning

Free, basic features

$$$ with lots of options

Replication

Free, relatively easy to setup and manage.  Basic features but works great.  Great horizontal scalability.

$$$, lots of features and options.  Much higher complexity with a lot of features.  Allows a lot of data filtering and manipulation.

Transactions

InnoDB and upcoming Falcon and Maria storage engines

Regular and Index only tables support transactions.

Backup/Recovery

No online backup built-in.

Replication

OS Snapshots

InnoDB Hot Backup

Recovery Manager (RMAN) supports hot backups and runs as a separate central repository for multiple Oracle database servers.

Export/Import

Easy, very basic.

More features.

Data Dictionary (catalog)

Information_schema and mysql database schemas offer basic metadata.

Data dictionary offers lots of detailed information for tuning.  Oracle starting to charge for use of new metadata structures.

Management/Monitoring

$, MySQL Enterprise Monitor offers basic functionality.

Additional open source solutions.

May also use admin scripts.

$$$$, Grid Control  offers lots of functionality.

Lots of 3rd party options such as BMC, Quest, Embarcadero and CA.

Storage

Each storage engine uses different storage. Varies from individual files to tablespaces.

Tables managed in tablespaces.  ASM offers striping and mirroring using cheap fast disks.

Stored Procedures

Very basic features, runs interpreted in session threads.  Limited scalability.

Advanced features, runs interpreted or compiled.  Lots of built in packages add significant functionality.  Extremely scalable.

 From my perspective, you almost can't compare Oracle and MySQL because they are two different type of products.

  • Oracle has tons of features from XML, user-defined types, lots of database management tools.  Oracle:
    • Can be used with Oracle Express, a database that has tons of functionality for the beginning project to running the largest business applications in the world. 
    • Has tons of features that usually minimize the need for 3rd party software.
    • Oracle is currently placing a major emphasis in two areas: 
      1. Enterprise business applications running Oracle Business Suite, Siebel, JD Edwards, PeopleSoft, Retek, etc.  Oracle's next generation Oracle Fusion Applications are going to have a major impact on business applications in the next few years.
      2. Oracle Fusion Middleware and the technology surrounding the middle-tier with application servers, J2EE, BPEL, SOA, XML, Web Services.  The ability to get disparate applications to work together are a key to Oracle Fusion applications.  Oracle's purchase of BEA shows the emphasis Oracle is placing on the middle-tier to run business applications.
  • MySQL excels when high speed reads can be used for web, gaming and small/medium data warehouses and OLTP systems.   MySQL:
    • Can also be used with startup companies and smaller projects because it can be simple to use at a low cost. 
    • Does not have a fraction of features of Oracle but for the companies using MySQL they are often building most of the functionality in the middle-tier and do not need lots of functionality in the database. 
    • Does not have a lot of the surrounding software to support a MySQL environment.  3rd party software and open software are often used to run MySQL in an enterprise environment.  Nagios and Memcache are used a lot in MySQL environments.
In this blog I am not trying to say MySQL or Oracle is better than the other.  They both have features where customers can benefit.   I enjoy working with both and would highly recommend both database servers.


Wednesday Apr 30, 2008

A DBA's Journey in the Sun

I'm really excited about starting this blog. I've spent my entire career on the leading edge of technology. From Unix, Oracle, C, C+, Java, J2EE, SOA, BPEL, Oracle Business Rules, open source, MySQL and Virtual Reality. Since joining Sun I have been completely re-energized by seeing a lot of the vision of Sun and where it is heading. I have a lot of interest in multi-tiered technologies surrounding databases, application servers, SOA, BPEL, education, training and sharing knowledge.
In this blog I want to share my thoughts and journeys living on the leading edge of technology and enjoying everything that makes life worth living.
    A summary of my background:
    • Oracle DBA - (since Version 5 beta): RAC, Data Guard, Streams, Tuning and B/R
    • Oracle Fusion Middleware (OAS, J2EE, BEA, BPEL, Business Rules, XML)
    • MySQL DBA
    • Oracle ACE
    • Independent Oracle Users Group - Board of Directors
    • International Oracle Users Council
    • Oracle Beta Leadership Council
    • IOUG - Masters Universities
    • Selected to Oracle of Oracles
    • Sun SL Mentor
      Additional Blogs:
      • http://mysql-dba-journey.blogspot.com
      • http://trubix.blogspot.com
      • http://web.mac.com/george.trujillo
        I hope you enjoy the blog.
        George Trujillo, Jr.
        About

        This blog is my perspective of Sun in relation to Oracle, MySQL, Oracle Fusion Middleware, Education and Virtual Reality platforms. The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

        Search

        Categories
        Archives
        « April 2014
        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
           
               
        Today