Tuesday Dec 09, 2008

The Next Generation of Internet Applications: Rich Client Interfaces

JavaFX is a hot new technology for building Rich Client Interfaces for leveraging high quality graphical interfaces that easily interfaces with audio and video for social networking and business applications.[Read More]

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]

Monday Nov 10, 2008

Configuration for MySQL Sessions

The MySQL sessions at the Sun CEC will use the Sun Virtual box and MySQL Windows versions 5.1.29 software.

Please follow the following instructions for the MySQL sessions at the Sun CEC:


Go to SWAN and check out a Virtual Image at  http://lomein.red.iplanet.com/sgd

This will give you a clean VM running Windows 2003.

Read the FAQ after checking out a system for complete details. (http://lomein.red.iplanet.com/faq.html)

 2. Go to the MySQL website:  http:/dev.mysql.com

     Click on the downloads tab.

     On the far left, click on Community Server and chose 5.1.

     Chose the appropriate operating system (Windows).

     Click on, No thanks, just take me to the downloads!

     Under Windows Downloads, chose: Windows ZIP/Setup.EXE (x86).

      Chose a mirror close to your geographical region.  Chose HTTP.

Save the file to your local disk.

 The virtual box and MySQL software will be installed as part of the MySQL sessions.



Daily activities at Sun CEC 2008

I will be posting the daily activities and thoughts of the day from the Sun CEC 2008 in Las Vegas at mysql-dba-journey.blogspot.com .  

Monday Oct 27, 2008

MySQL Rocking the House in Las Vegas, Nov 9th - 14th at Sun CEC

MySQL Training Sessions at Sun CEC

I will be delivering 2 - 3 MySQL training sessions a day during the Sun Customer Engineering Conference (CEC).   These sessions are targeted towards Sun employees interested in learning a lot about MySQL, getting certified or getting into MySQL professional services.  Each session will cover key areas of knowledge and certification topics.  Each session will also include tips and information needed to pursue MySQL DBA certification.


These sessions are going to provide an in-depth immersion into the MySQL database server.   We're also going to make these sessions, hands-on, interactive and entertaining.  Attendees will learn the core fundamentals for managing a MySQL database server.  "What happens in Vegas, won't stay in Vegas", attendees will take back a lot of core fundamentals for managing a MySQL database server.   I'm bringing my "A" game to these sessions so I need you to bring yours.  :)

Presenters

Anders Karlsson - MySQL Professional Services
David Stokes - MySQL Certification Manager
Clifford Conklin - Sun Professional Services 
George Trujillo - MySQL Sr. Instructor
Domas Mituzas - Wikimedia

Training Environment

Materials used for the course will be the MySQL 5.0 Certification Study Guide. Students will need to take notes from the lectures and use the Certification Study Guide book during lectures.  Sun Rays will be provided using Windows 2003.   Students that have a Windows or Windows VM are welcome to bring their laptops and do the installs and hands on work with their own machines.  We are planning on using MySQL 5.1.29 for the sessions.

Objective

Build core fundamental knowledge in MySQL and show attendees the path to certification and where to find things so they can get certified. 


Intended Audience

Sun employees with some database experience (SQL, Oracle, Postres, SQL Server, etc) that want to get into delivering MySQL certification and consulting.

Session Agenda

This agenda may change slightly as we get closer to the CEC. 

Monday        November 10, 2008

1:00 pm - 3:00 pm    - Session 1  - Positioning MySQL and MySQL database installation
5:00 pm - 7:00 pm    - Session 2  - Understanding the MySQL architecture


Tuesday       November 11, 2008

9:00 am - 12:00 pm    - Session 3 - Starting, stopping and configuring MySQL
1:00 pm -   3:00 pm    - Session 4- Client programs and MySQL Administrator
5:00 pm -   7:00 pm    - Session 5 - Storage engines and table/index management

Wednesday November 12, 2008

9:00 am - 12:00 pm    - Session 6 - INFORMATION_SCHEMA, admin logs and diagnostics
1:00 pm -   3:00 pm    - Session 7 - Locking and transactions
5:00 pm -   7:00 pm    - Session 8 - User management and security

Thursday     November 12, 2008

9:00 am - 12:00 pm    - Session 9   - Optimizing queries, database and the server
1:00 pm -   3:00 pm    - Session 10 - Backup and Recovery
5:00 pm -   7:00 pm    - Session 11 - Managing multiple servers and replication

Friday           November 14, 2008

The assessment will be made up of 40 questions designed to test for knowledge gained during the sessions and to verify you have all information needed to pursue a path for certification. 

10:00 am - 12:00 pm  - Session 12 - Assessment

Friday Oct 24, 2008

Taking the MySQL DBA Certification Test

I'm always getting asked how to prepare and get ready for taking and passing the MySQL certification test.  Here are some things to consider:

  1.  Dave is the MySQL Certification Manager for Sun Microsystems.  There are some good hints at David Stokes blog at dave-stokes.blogspot.com.
  2. Read the questions carefully and answer them quickly to the best of your knowledge, do not over analyze the questions.
  3. The book MySQL 5.0 Certification Study Guide is a well written book that will help you get ready for the certification test.  There are also some sample test questions at the back of this book.
I'm also going to be doing an interview of a Sun engineer that has recently passed the certification test.  He is going to talk about how he prepared and got ready for the test and his insights.


Friday Oct 10, 2008

Launch of Solaris Campus

I'm sitting here attending the launch of the Solaris Campus in SL.  Some hints for attending any SL meeting:

  • Make sure you have toggled your microphone off.  (bottom right hand screen)
  • Go to Edit | Preferences | General | Show Names and toggle to Never.  This can be nice if your screen gets too busy showing name tags.
  • Use camera controls to zoom in and zoom out.

Greylin has done a great job in designing and laying out the Solaris Campus. Enzo excellent job managing the launch of this campus.  Sidifen Yiyuan (Stephen Mohr)  is delivering a presentation on Solaris 10 updates.  Great presentation, the theatre is standing room only.  Presentation can be downloaded at http://blogs.sun.com/solariscampus .  There is a Solaris certification center where you can get more information on Solaris certification.

 

 

 

Sunday Sep 28, 2008

Oracle versus MySQL

 Looking at Oracle versus MySQL Environments

After coming back from Oracle Open World in San Francisco,  the differences between Oracle and MySQL stood out more than ever.   The Oracle and MySQL database environments are completely different.   Both databases can be used in lots of different environments and they are both fantastic solutions for the right situation.  I've always used the comparison of Oracle being an aircraft carrier and MySQL being a fast fleet of speedboats.  This difference is more apparent than ever.  Now when I think of Oracle I think not only of Oracle but of the supporting aircraft carrier force around it.  

Oracle

The environments for Oracle are getting more and more complex.   There are just tons of products supporting the Oracle environment with lots of different options.  I really think Oracle needs to stream line its message.   I heard a lot of feedback from numerous individuals that were just completely overwhelmed with all the options and products.   There is a lot of innovation and tremendous activity around products and features.  For large enterprise business applications Oracle appears to be dominating the market.

MySQL

MySQL does not come close to all the features of Oracle.  However, this is why so many people love MySQL.  MySQL is fast, easy to work with, streamlined and has a significantly reduced cost of ownership.   I am seeing MySQL significantly increasing in popularity everywhere I go.  The LAMP stack is also growing in popularity at ever increasing rates.  Developers building web applications don't care about all the features in a database.   .NET, PHP, Java and Ruby developers want a fast database server that is easy to work with.  That is why MySQL is so popular in web based environments.   Developers don't care about database features, they care about a fast database server that meets the needs for their web applications that is easy to use.

Friday Sep 26, 2008

George Trujillo Oracle Open World Summary - My Four Takeaways

From my perspective, my four big take aways from Oracle Open World 2008 are:

  1. Evolving role of the traditional DBA.   You finally see great changes in automation, management of data centers, increasing skills for managing complexity of Oracle environment and the increasing needs for DBAs that can manage Oracle business applications.
  2. Increasing demand for Oracle Fusion Middleware skills.  Learning the right tools for managing Oracle Fusion middle is going to be a very serious transition for some developers.   You'd better get started learning the technology.
  3. Increasing demand for BI, Hyperion and Stellent.
  4. Oracle environments are significantly increasing in complexity, products, integrations and the need to understand how to work with all the pieces.
Lots of people felt completely overwhelmed with evolving complexity, volume of new products and features.  Steve Lemme from CA had an excellent presentation on successful Oracle Fusion Middleware implementations from a project management perspective. There are going to be lots of money made by individuals that see this growing demand.

 

Thursday Sep 25, 2008

George Trujillo at Oracle Open World - Day Five

Well the big event at Treasure Island I thought was a big success.   It was a very festive atmosphere and the concert was outstanding.  Although its been a great conference, I'm looking forward to finishing up and going home.

I deliver my final presentation for the conference at 1:30pm.  It's on Demystifying Oracle Fusion Middleware.  It's the last presentation of the conference but when I checked the room its completely full.  It was really a different presentation for me.  I was presenting in a room that had a 4 foot wide about 10 feet from the presenter's audio mike.  Which cut off half the room to the presenter.  I tried a number of ways to work around this but for some reason  the layout of the room made it difficult to me to connect to audience because no matter where I moved, I cut off a third of the audience visually from me.  It was quite the learning experience for me.   

My final thought on the conference.  It's the best conference Oracle has every put on.   Everyone is pretty energized by all the activity going on at Oracle with products, features, etc.

Safe travels everyone!

 

Wednesday Sep 24, 2008

Is solid state the solution for running Oracle?

I'm hearing a lot of discussion of running solid state for Oracle databases.  The consensus seems to be that it has the potential to be a great solution for hot data to reduce latency.   However a lot of debate about running solid state for core data.  I'm definitely going to have to look at this in more detail.

Solaris Containers big success stories at Oracle Open World

It was really exciting to hear about some great success stories of very successful implementations of Solaris containers using Oracle.  Heard consultants literally raving about how successful containers were in some very large Oracle implementations.

 One was with Oracle Data Guard an they were very happy with how containers were a great solution for failover and backup and recovery. 

George Trujillo at Oracle Open World - Day Four

Today started with an IOUG board meeting.    The directions and the activities of the IOUG Oracle's users groups at Oracle Open World are very exciting.  

Today there are a lot of meetings on the Oracle Beta program and Oracle Fusion Middleware.  Meeting with senior Oracle product leaders in the different Oracle products has been invaluable.

I can't remember when I've seen the energy and enthusiasm higher at an Oracle conference.  Everyone is fired up on the new products coming out of Oracle.  There is going to be a lot of new business in the Oracle community and money made in the next few years related to Oracle Fusion Middleware, BI, Hyperion, Stellant, Essbase, etc.  I think everyone smells money and opportunity and its more energizing than the oxygen that gets pumped into the systems in Vegas. :)

Larry Ellison's keynote is going to be the buzz of all afternoon and evening events.

Later this evening there is the IOUG Appreciation party and the big event at Treasure Island.   

Oracle Open World - Larry Ellison's Big Announcement "Extreme Performance"

I highly recommend you attend or listen to Larry Ellison's keynote today at Oracle Open World.   It's going to be a "big" one!

 You can visit this website trubix.blogspot.com  for more details of the Oracle's Exabyte Server and the "Extreme Performance" solution by Oracle.

Tuesday Sep 23, 2008

Oracle Open World - A Great Oracle Conference!

I think this Oracle Open World (OOW) conference is the best that Oracle's ever done.  Why is it better?

  • Great management of a large conference with over 43,000 people.
  • Scheduler builder makes a complex and large conference easy to manage.  Email notifications have been great of all the events and activities going on.
  • Tons of great networking being sponsored by Oracle.  Oracle Aces, bloggers, OTN lounge, open lounges and networking areas.
  • SIG day - having top presenters from different Oracle user groups present for the entire day.
  • Unconference - a big success.
  • Oracle Develop - excellent hands on workshops.
  • Lots of energy and enthusiasm throughout conference.
  • Lots of great evening events.

Probably my only complaint is the lack of power cords throughout conference.  I need a USB that can recharge my laptop battery. Maybe I'll find one in the vendor booth area.  :)

George Trujillo at Oracle Open World - Day Three

Really enjoying the conference.  I'm cherry picking the presentations I've gone to and have really enjoyed the ones I've gone to.  It just amazes me the level of complexity in Oracle environments and how much someone has to know.  Yet at same time Oracle is telling everyone how easy it all is.

 

I've been involved in a lot of discusses on storage.  Solid state, reducing latency, etc.  It's going to be interesting.  You can put more and more memory in a server and next generation of storage is going to reduce latency of disk access a lot.  

Some interesting conversations of Quest software.

I really like how Oracle has set up the schedule builder and how well it works with helping you manage your schedule and stay clued into everything at OOW.  Very large conference that I think has been extremely well managed.  I do dislike the fact that you have to pay to go to conference and then have to pay to get the presentation slides.  

The Oracle Aces and bloggers are two very cool groups to get involved with.   Any get together with them is worth its weight in gold.   Lots of interesting perspectives and views of the Oracle world.  Going to the Oracle Aces dinner is always one of my highlights of conference.  Today filled with lots of meetings.   I'm always humbled by the amazing, hard working and driven people that make the Oracle environments work (DBAs, develpers, etc).

Users Groups at Oracle Open World 

If you are new to the Oracle conference I highly recommend going to the Users Group Pavilion in Moscone West and visiting the Oracle users group booths.   With todays' Oracle environments you should probably be joining multiple Oracle users groups.  I am very impressed with the role of the Oracle users groups and the great volunteers that make these groups so awesome.   Great job IOUG, OAUG, Quest and ODTUG (these are groups I'm involved with I don't mean to leave anyone out). 

Oracle ACE Dinner 

I thought the Oracle ACE dinner was a big success last night.   Special thanks to Lillian Buziak and the Oracle ACE for continuing to build the Oracle user community through great events and groups like the Oracle ACE program.  It was a great evening of sharing perspectives, ideas and experiences with some of the top Oracle technology leaders.

 

Monday Sep 22, 2008

George Trujillo at Oracle Open World - Day Two

 Today was a busy day full of lots of meetings.  To me the power of the conference is the networking and sitting in on key presentations that stand out to you.  Today really emphasized just how big Oracle is getting.  The keynotes of Charles Phillips, Thomas Kurian and Andy Mendelson were important to understand Oracle strategic directions and getting synched up on new products and production directions.

 

Also enjoyed talking to different Oracle users groups and seeing the growth and evolution of these groups.  I'd definitely recommend joining one or more of these groups. 

Charles Phillips Keynote

Highlights include:

  • Oracle spending  around $3B in research and development.
  • It's been the year of innovation at Oracle.
  • Acquisitions over the last four years is over 50 companies.  They've gone from 40k to 80k employees.
  • Business applications:
    • Applications Unlimited - new features are enhanced with Fusion Middleware.
    • Software as a Service (SaaS) continues to evolve. 
  • Oracle has three key business areas: database, middleware and business applications.
  • Application Integration Architecture (AIA) is the foundation of integrating and packaging applications.
  • Oracle Fusion Middleware is the key underlying technology that drives Oracle Fusion applications.
  • Beehive is introduced as the new collaboration solution.  Integrates Oracle WebCenter, Oracle applications, etc.  Definitely going after the Sharepoint and Exchange markets. It takes the concept of a personal workspace and turns it into a team workspace.  Integrates e-mail, instand messaging, chat, voic mail, calendars, document sharing, multimedia capability and conferencing applications.  Great idea, will have to see if it takes off better than Collaboration Suite.

Thomas Kurian Keynote

Highlights include: 

  • Talked about BI, Essbase and Hyperion and the increasing role of BI in the middle-tier.
  • Talked about BEA integration into Oracle Fusion Middleware and new products.
  • (I need to come back to this keynote heading over to party at the Hilton)

 

 

Andy Mendelson Keynote

Highlights include:

  • Database replay is a powerful tool for helping organizations upgrade.
  • New Versions of SQL Developer and Application Express (APEX) (new features to convert an Oracle Form to an Application Express).   Also has ability to convert an Access application to APEX.  Being able to convert a Form to an APEX application is very very cool IMO.  The demo by Mark Townsend rocked!
  • MAA - Maximum Availability Architecture - using Oracle Secure Backup, Flash Recovery, ASM, Data Recovery Advisor, Data Guard, Online Upgrades, Flashback and Total Recall. 
  • New Oracle Secure Backup interface allows backing up Oracle database to a cloud.  Will work with Oracle Database 10g and 11g.  They showed a demo of the new interfaces for performing this.  Made it look very easy.
  • Oracle Database Development Cloud
  • Upgrading is getting easier.
  • Database Replay, SQL Plan Management and SQL Analyzer make it a lot easier to upgrade to a new release of the database.
  • Created excitement and enthusiasm by saying during Larry Ellison's presentation he will be showing a new feature coming out "X Performance".

 

 

George Trujillo at Oracle Open World - Day One

Today was a great start to the conference.  Despite hearing there are over 40,000 attendees at the conference I thought everything ran smoothly.  Sunday was SIG day for the Oracle user groups and I attended a number of excellent presentations by highlighted speakers from the IOUG and other user groups.   My day at Oracle open world.

  • Presenting on Oracle Open World at 8:30.  Very happy to see it was standing room only at my presentation.   Some people that it was the line for free breakfast.  :)
  • Breakfast with Mike Ault, one of my favorite database people.
  • Meeting with different Oracle product managers.
  • Bloggers  event.  A very cooool group.
  • Duncan Mills presentations on Web architecture. 
  • I thought Steve Lemme's presentation on Oracle Fusion Middleware was a very unique perspective and enlightening on the roadmap to successful projects using Oracle Fusion Middleware.
  • Hooking up with different leaders from the IOUG and ODTUG, the two key technology user's groups in the Oracle world.
  • Food was excellent at the evening get togethers.

Blogging can save your life!

One of the great stories of the conference was hearing how Debra Lilley (one of my favorite people) was stuck in an elevator at hotel and started blogging on how she was stuck on the elevator.  Someone monitoring the Oracle blog for the conference called the hotel and helped get her out.  Glad you're okay Debra!  :) 

Thought of the Day

Loving seeing that with Oracle highlighting Oracle Open World as a green event once company advertised the green event by handing out advertisements using paper!  :)

 

Quotes of the Day

"Chillaxxxxx"

"He's like a satanic chihuahua under a strobe light" 

Sunday Keynote: Carville and Matalin

Sunday as excellent with  Mary Matalin and James Carville entertaining the attendees with a humorous and enlightening view of world of politics. 

 

Saturday Sep 20, 2008

George Trujillo at Oracle Open World - Demystifying Middleware Technologies

Presentation:  S300046 Demystifying Middleware Technologies by George Trujillo

Thursday 09/25/2008  13:30 - 14:30 pm  Marriott Golden Gage C1

This presentation is designed to demystify popular middleware technologies and explain how these technology components work together. Topics include J2EE, application servers, Web services, XML, application frameworks, WSDL, BPEL, SOA, and business rule engines. Attendees will learn how all of these different middleware components work together in application servers. This is an important presentation for developers and DBAs who would like to learn more about the middle tier and are new to Oracle Fusion Middleware. 

 

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.

George Trujillo Presenting at Oracle Open World 2008 in San Francisco

Presentation:  Getting Started with Oracle Fusion Middleware  by George Trujillo

 S301218    Sunday 09/21/2008   8:30 - 10:00 a.m. Moscone West Room 2005

I'll be presenting at Oracle Open World (OOW) again this year.  OOW just keeps getting bigger and better every year.  I've heard they are expecting around 40,000 this year.   The conference is from September 21 - 25, 2008 at the Moscone Center in downtown San Francisco.  I'm very fortunate to get the opportunity to open and close the conference.  My two presentations are in:

  • Getting Started with Oracle Fusion Middleware  (Sunday September 21, 2008  8:30  - 10:30am)
  • Demystifying Oracle Fusion Middleware   (Thursday September 25, 2008 13:30 - 14:30pm)

It's going to be a great networking opportunity.  Throughout the week I will be meeting with Senior Oracle managers in the server and middle-tier technology areas.   I will also be meeting with leaders from the IOUG, OAUG, Quest and attending Sun Microsystems events.  Getting involved with user groups is one of the best things you can do do further your career in terms of getting into the information stream of industry leaders as well as getting great networking opportunities.

Key areas for me include:

  • Getting the latest information on the BEA integration into Oracle Fusion.
  • Interacting with attendees and seeing what their current challenges are related to Oracle Server technology.  The Oracle DBA is working in an ever increasing level of complexity when it comes to database servers.   Having the typical administration, tuning and backup and recovery skills is no longer sufficient.  Having additional skills in RAC, Data Guard, Streams, Enterprise Manager and storage are very important for production DBAs.   Yet, at the same time DBAs have to start increasing their skills in getting ready for a new level of management of Oracle applications and the upcoming Oracle Fusion applications.
  • Finding out exactly where we are with Oracle 11g Release 2.  The Release 2 of a major version of Oracle has always been the target platform most organizations move to.   As always we can expect a significant amount of enhancements to Oracle 11gR1 as well a new features in the Oracle 11gR2.

 

I hope to see you there!   

Tuesday Sep 02, 2008

Sun and MySQL Cross Pollination

Currently the MySQL database is going through tremendous growth.   MySQL Professional services is encountering significant growth and activity.   With my being on the training side I'd like to find Sun employees that are interesting in helping champion information and knowledge sharing across the traditional Sun Classic areas such as Solaris, Glassfish, Storage, servers, etc.  and Sun Dolphin the MySQL side of the house.

Potential areas of cross pollination:

  • Sun CEC meeting November 9th - 14th.   I will be delivering 2 - 3 training sessions on MySQL targeting Sun employees that have a fundamental database background and are interested in learning more on MySQL and interested in getting certified in MySQL.  I'd love to meet with anyone interested in learning more on MySQL and seeing how the MySQL team can work more with Sun groups.   How can we work together to make sure customers understand all the benefits of MySQL and Sun solutions?
  • Second Life collaboration.  I am on the Sun Second Life Core Team and Sun Mentors groups and want to see how we can show the benefits of MySQL along with Glassfish, storage, software and hardware where it makes sense.  Let me know how I can share information on MySQL and can help with Sun Second Life efforts related to Sun employees and customers.
  • MySQL Information and Knowledge.   What information on MySQL do you need to be more successful?
  • Additional ways of Sun classic and MySQL collaboration.  I'm always open to any discussing ideas on how sharing of MySQL knowledge and information can help Sun be more successful.

 George Trujillo

 

 

 

 

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.   

Wednesday Jun 11, 2008

MySQL and Oracle URLs for Sun Employees

I have some URLs that Sun employees may want to access to learn more about MySQL.  They include. 

 http://mysqlandsun.articulate-online.com/p/0375842911 - Video positioning MySQL.


web.mac.com/george.trujillo - Click on tab on Oracle database and see podcasts and slides on Oracle architecture.  Still working on finishing podcasts that have come in recently.  Contains the slides and topics I will be covering.  You can click on archives to see older slides. 


blogs.sun.com/georgetrujillo  - Shows manual install of MySQL on Solaris using Moca.


mysql-dba-journey.blogspot.com - Personal MySQL blog. 

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.


Tuesday May 27, 2008

Top Things to Know if new to MySQL on Solaris

Here are ten things to know about MySQL if you are new to MySQL on Solaris:

  1. The default install is simple, easy, takes minimum resources but is not a configuration you should use for production environments.  If new to MySQL use the default install.
  2. To connect to a MySQL database server you need to know the host and the port.   The my.cnf (or my.ini) file is the startup configuration file.
  3. The mysqld background process is the database server that reads the startup configuration file.  The mysqld database server is thread based, so threads start up to manage sessions.
  4. MySQL has unique features just like other relational databases. MySQL database servers need to be configured for performance like any database server if running in a production environment.  You'd better understand these features if supporting MySQL.
  5. Before running MySQL in a production environment, you'd better understand storage engines, SQL Modes, MySQL security and the architecture of the MySQL database server.
  6. As of May 30, 2008  MySQL 5.0 is the GA release,  5.1 RC is about to go GA.  MySQL 6.0 is in alpha.  The goals of MySQL 6.x is adding a lot of online features, new important functionality with increased performance and throughout.  MySQL 6.0 will add significant scalability and functionality to the database server.
  7. Through version MySQL 5.1, there is no hot backup utility.  OS snapshots, replication, InnoDB Hot Backups are popular ways for backing up MySQL databases.  MySQL 6.x will have hot backup capability.
  8. MyISAM tables totally rock when high speed reads are very important.  Make sure you understand all characteristics or these tables before using them.
  9. InnoDB is the transactional storage engine to use through MySQL 5.1.
  10. New storage engines such as Maria, Falcon and enhancements to InnoDB are going to change the use of MySQL in the enterprise.
  11. Replication is one of the most popular features in MySQL.   It is free, relatively simple to set up and performs basic functionality of replication.  Does not contain advanced replication features but it also does not contain the complexity either.  That is what users like about MySQL replication.
  12. MySQL Cluster is a HA (high availability) environment.  MySQL Cluster works extremely well when applications leverage how MySQL Cluster works.  Make sure you understand the characteristics of MySQL Cluster before considering it for an application.
  13. Go to  http:/dev.mysql.com   and then click on Documentation.  Scroll down a little bit and find the Example Databases section.   The World, Sakila and Menagerie gzip and zip files contain SQL code for creating database schemas, building tables and storing them with data.  They provide sample data to play with.
  14. MySQL Enteprise Monitor is MySQL's management and monitoring software for managing MySQL database servers.  It contains lots of GUI interfaces and advisors.
  15. Popular software seen in MySQL environments include memcache, SQLYog, Navicat, Pentaho and Nagios.  

Why MOCA on Solaris?

Installing and configuring MySQL using the packages, RPMs and installers that can be downloaded from MySQL are easy to install. There are also numerous installers like YUM for Fedora that can install an entire LAMP or SAMP stack for you with a simple click. If all these installs are so easy why would you ever want to perform a manual install or use MOCA?

Well, database administration like life comes down to doing things easy and simple or doing things right. If you are going to perform a simple install or just want to learn MySQL, then definitely use one of the very easy install methods mentioned above. If you are concerned about any of the following perform a manual install using some set of guidelines like MOCA:
  • Installing multiple MySQL database servers on the same platform.
  • Installing multiple versions of MySQL software on the same platform.
  • Consistency of MySQL configurations across different operating systems and hardware.
  • Installations and configurations conforming to standards and guidelines.
  • Minimizing pain and anguish in your life as a DBA.
  • Avoiding evenings and weekend work.
  • Minimizing mistakes, downtime and adminstration costs.

  • If installing MySQL for development and in a small shop then simple installs are nice. That is part of the tremendous attraction of MySQL. For production DBAs installing MySQL across multiple platforms at the enterprise level, it is important to use guidelines and standards that your DBA team can control. When a lot younger I didn't mind working late hours and working on an hourly basis. Now, I prefer to minimize administration costs, late hours and minimizing pain. :)

    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