Friday Oct 16, 2009

This blog has moved to Trubix.blogspot.com and may not be actively maintained until the direction of Sun blogs is defined for the future.

George's Blogs:

MySQL-dba-journey.blogspot.com MySQL
Trubix.blogspot.com
Oracle DBA and industry perspective
FusionInsidersEdition.blogspot.com Oracle Fusion Middleware
blogs.sun.com/GeorgeTrujillo
Sun perspective
web.me.com/George.Trujillo  Personal
twitter.com/GeorgeTrujillo  Twitter







Wednesday Aug 26, 2009

I recently received the Socrates award from the MySQL education team.   As a "maven"  I took special pride in the award.


Thursday May 14, 2009

At http://trubix.blogspot.com I've written a blog on the importance of peripheral DBA skills. In the Solaris world, the following peripheral skills are very helpful for managing database environments:
  • Solaris administration.
  • ZFS.
  • Containers and Zones.
  • Dtrace.
  • Application Servers - knowledge of Oracle, Apache, JBoss, LightHTTP, connection pooling, etc.
  • Monitoring skills - OEM, Enterprise Monitor, Nagios, Cacti, etc.
  • Ability to support developers - PHP, Java, .NET.
  • Networking skills.
  • Storage.
From my perspective, the one area DBAs should learn more about is in storage.  It's not about being a storage expert, its about understanding the basics and being able to communicate with storage teams and system administrators.

The MySQL training team I would challenge as being one of the best training teams in the IT industry.  In terms of experience, communication skills, camaraderie, focusing on team goals and building a great working team they are incredible.   This team grew out of the MySQL and open source culture that was built with great management and a very profitable training model.  This culture was based on working together, sharing and being humble.    It's been great to see in today's wild corporate world that there are still companies out there that can build a culture than can bring out the best in individuals and teams.

It's been an amazing run of putting together a Swedish corporate culture with team members from Germany, Sweden, Finland, United States, China, etc. to build one of the best teams in the industry.

I would highly recommend any organization focused on building a highly profitable training organization look at the training model that was put together by MySQL.  This model shows that putting a very heavy emphasis on building a quality organization versus just trying to deliver training at the lowest price still makes a difference to customers.


Here are some outstanding blog sites that I would highly recommend for DBAs to visit.  Thanks Rick, Yousuf, Satyajit and everybody for sharing.


Friday May 08, 2009

An Oracle DBA's Future is So Bright They've Got to Wear Shades

As an Oracle DBA (18 years) focused on enterprise management (OEM) across the Oracle Infrastructure  (Database Server and Fusion Middleware) I ventured into open source with MySQL and joined MySQL AB.   With the Sun acquisition of MySQL and the possible Oracle acquisition of Sun I will have come full cycle.  I am so excited about the potential merging of Oracle and Sun technologies. In terms of sharing knowledge  I feel it is important to write some white papers on performance tuning Solaris platforms for database servers.  Solaris has a number of very cool features for optimizing and diagnosing database servers.

So my continued journey into the Sun is going to take into some areas that maximize my background:

  • Unix/Solaris/Red Hat administration for 20 years back to the SunOS days.
  • Oracle Database Server High Availability (RAC, Data Guard, Streams).
  • Oracle Fusion Middleware (J2EE, BPEL, SOA, XML, Web Services, Oracle Business Rules).
  • Oracle Enterprise Manager (Grid Control).

So I plan on writing some white papers and blogs focusing on the following areas of Sun technology:

  • Containers and Zones.
  • Solaris optimization for Oracle.
  • ZFS best practices for Oracle.
  • Dtrace for DBAs.
If anyone has any additional areas they would like to learn about related to Solaris and database servers let me know.


Wednesday May 06, 2009

 I am excited about joining a 3D teaming event on how teams work in Second Life.   I have been teaching technology classes for over 12 years and was amazed with how much I learned in our first event meeting.   A lot of great things stood out in this event that I will be able to take about to my professional job.

I thought this event by Duke was extremely well organized.  I was very impressed with the professionalism and skill of our facilitators and coaches.


Tuesday May 05, 2009

Most of my blog entries this week are going to be at http://web.mac.com/george.trujillo  since I'm at the Collaborate 09 Users conference.

Thursday Apr 30, 2009

Second Life Presentation on Sun Solaris Campus 

This virtual world presentation will be delivered at the Sun Microsystems Islands on the Solaris Campus.  Here I'm chilling at the Solaris Campus on one of the Sun virtual islands.

Second Life Presentation on Sun Solaris Campus

The MySQL open source database continues to increase in popularity with usage estimated at 12 million database servers worldwide. This presentation will help Unix/Linux and storage management administrators  understand the reasons for the growing popularity of MySQL.  Topics will include:

  • Positioning MySQL in the database market.
  • How is MySQL different than
  • Understanding the MySQL architecture.
  • Strengths and weaknesses of MySQL.
  • Key features of MySQL.
  • Understanding the storage engine story in MySQL.
  • MySQL strategic directions.

The focus of this presentation is on  helping attendees understand the philosophy, features, benefits and popularity of MySQL.


Second Life Presentation on Sun Solaris Campus  May 5, 2009  9:00 am PDT

This virtual world presentation will be delivered at the Sun Microsystems Islands on the Solaris Campus.   Information on the SL Solaris campus can be found at  http://blogs.sun.com/solariscampus.  The SLURL is:

  •  http://slurl.com/secondlife/Sun%20Microsystems%201/32/231/22

Here I'm visiting the Solaris Certification Center.

Demystifying MySQL for Solaris Administrators

George Trujillo (Ty Valdez) and Steve Jones will be presenting a Demystifying MySQL for Solaris Administrators the week of  May 4, 2009 in Second Life.  This presentation is a very detailed technical presentation designed for experienced Unix/Linux administrators to understand installation, configuration and management of MySQL on Solaris platforms.  MySQL best practices along with Solaris features that can leverage database management such as ZFS will be included.  Topics will include:

  • Strategies for laying out database servers on Solaris (Unix/Linux) platforms.
  • Understanding the MySQL architecture.
  • Installing MySQL using MOCA (GOCA) for best practices.
  • Starting and stopping the MySQL database server.
  • Top ten things to configure after creating a MySQL database server.
  • Using MySQL with ZFS.
  • Managing MySQL on a Solaris platform.



Monday Apr 27, 2009

George Trujillo at Collaborate 09 Week of May 3, 2009

I will be presenting two presentations at the IOUG Collaborate 09 Conference in Orlando FL,  the week of May 3rd 2009.   Here is one I have been asked to present.   This presentation is a very detailed technical presentation designed for experienced Oracle professionals to get an understanding of the MySQL database server under the hood.

Demystifying MySQL for Oracle DBAs and Developers Tues @ 9:45am - 10:45am, 224A

George Trujillo continues his popular demystifying series that started with Demystifying Oracle Fusion Middleware, to now include a MySQL demystifying series.    This presentation will use George's MOCA best practices blueprint for installing, configuring and tuning a MySQL database server.  This fast paced detailed technical presentation will cover:  MySQL Architecture, Installation, Configuration, Key Features, Security, MySQL Tools, Storage Engines, transactional capabilities and strategic directions.  This is a can't miss presentation for any Oracle DBA wanting to understand MySQL.

George Trujillo at Collaborate 09 Week of May 3, 2009

I will be presenting two presentations at the IOUG Collaborate 09 Conference in Orlando FL,  the week of May 3rd 2009.   Here is one I have been asked to present.   This presentation is a non-technical presentation talking about MySQL positioning, strengths and strategic directions.

What every Oracle Professional needs to know about MySQL Mon @ 3:45pm - 4:45pm, 240CD

The MySQL open source database continues to increase in popularity with usage estimated at 11 million database servers worldwide. This presentation will help Oracle professionals who are considering the addition of MySQL or just getting started with MySQL:  how the MySQL database can be utilized, MySQL strategy and architecture, and key functionalities.  Similarities and differences between database vendors and best practices will be included. The focus of this presentation is on  helping attendees understand the philosophy, features, benefits and popularity of MySQL.

Friday Apr 24, 2009

One of the great personal rewards in a career is the ability to work with a great team.   I have been extremely fortunate to work with some fantastic teams in my career, but one of the best teams I have ever worked with is the MySQL training team.  It's hard to describe this team without getting corny.  Our MySQL training team has great leadership, incredible camaraderie, selfless team members always focused on the goals of the team along with incredible and unique talent.  On the business side this team has been extremely profitable and focused on business objectives.

When I look at how this great team was created, I have seen a number of very unique events that occurred to create this great team.  It's like building a great sword.  A great sword requires the best materials, the ability to put the materials together in exactly the right way, a love and passion for excellence and a master sword builder to create it.  Our team had all of this.   The ingredients included:

  • A great vision by the MySQL leadership (Marten, Ulf, and Marc).
  • A Swedish culture mixed with cultures from around the world that is humble, believes in challenging the status quo and the importance of speaking up and voicing your opinion.
  • A passion for creating and maintaining excellence (Marc).
  • Great ingredients (unbelievably talented team members).
  • A selfless team that is completely focused on team goals and keeping the focus on team goals and not just individual goals.
  • The ability to excel (extremely high profit margins and one of most successful training models in the technology industry).
  • Tight integration of courseware development, sales and delivery.
  • Constant practices and methods in place to always demonstrate that the company is committed to high quality and excellence.   This I felt was one of the most important ones.  All companies say they are about high quality.  Great teams are part of organizations where they see the commitment to maintaining high quality.

There are great teams in Sun and in other companies.   I would be extremely interested in learning and sharing ideas and thoughts of how great teams are put together and maintained.  During the Collaborate 09 conference next week I plan on talking to a number of user community leaders and getting their insights on great teams and how they were created.

Now that the MySQL conference is over, it's time to focus on the Collaborate 09 Oracle Users conference.   The Independent Oracle Users Group (IOUG) is a user community focused on the technology side of Oracle.   This is an excellent organization to be  a part of if you are an Oracle technology expert.    I will be wrapping up my current term on the Board of Directors after serving two terms.  While serving on the board has been a fantastic experience I am so involved in Oracle HA, Oracle Fusion Middleware, Open Source and Virtual 3D training that my time is being spread too thin so I figured its time to step down from the board.  However, I still plan on staying very involved in the Oracle user community.  I cannot recommend highly enough for someone to get involved in the technology user communities.  In the last few years I have been involved in the following groups and the personal and professional rewards and the ability to give back to the user community has been some of the most rewarding experiences of my career.  These groups include:

  • Independent Oracle Users Group (IOUG)
  • Oracle Fusion Council
  • Oracle Beta Leadership Council

As I step down from the board of directors for the IOUG, I do hope this gives me more time to get involved in the virtual 3D training community, open source user community, ODTUG, Java user community and local Oracle users groups.   My personal interest in Oracle Fusion Middleware that includes Java, Web Services, BPEL, SOA, XML and application servers I am sure is going to take me on some fun journeys over the next year.  Whew, I think I just wore myself out.  :)

As an Oracle DBA for 20 years and an Oracle Ace in the Oracle Fusion middleware technologies I can tell you the IOUG is a great organization to be a part of if you want to maintain your personal technical skills, network with the largest technical Oracle users group and see the top Oracle user community leaders present on Oracle technical topics.

The IOUG at the Collaborate 09 conference is a very important conference for me.   My focus for the last ten years has been focusing on high availability across multiple tiers of the Oracle architecture.  With my background in RAC, Data Guard and Oracle streams and Oracle Fusion Middleware  it is important I maintain my skills and stay in touch with what others are doing.  In the last two years I have gotten involved in high availability across open source tiers of MySQL, Apache and PHP now allows me to talk to customers that are implementing Oracle and open source solutions.  So one of the places I go to sharpen my skills and make sure I am up to speed on what others are doing is to be a part of the IOUG.

I hope to see you at the IOUG conference in Orlando!


Tuesday Apr 21, 2009

The Continuing Disruption in the Database Industry:

Everyone recognizes the tremendous growth and adoption of the MySQL Database Server in the marketplace.   On the second day of the MySQL Users Conference 2009 in Santa Clara, CA , the power of combining Sun expertise with MySQL innovation has been shown to the IT industry.  Today Sun Microsystems introduces the MySQL 5.4 performance release.   Sun and MySQL teams have addressed all the doomsayers and analysts spreading FUD with an exciting new version of MySQL.  This release includes some excellent patches from the user community showing the continuing importance of the MySQL user community.

Key Features of the MySQL 5.4 Release 

Performance benchmarks have shown  MySQL 5.4 to run up to 60% faster than 5.1. Some of the key new features of this performance and scalability release include:

  • Architecture enhancements to support significant increase in scalability supporting up to 16-way x86 servers and 64-way CMT servers.
  • Improved default configuration out of the box.  Default parameters are much better initial values.
  • Significantly improved locking concurrency capability with InnoDB.
  • Improved metadata with enhancements to INFORMATION_SCHEMA.
  • Key performance additions to subqueries and joins improving performance up to 90% for some queries.
  • Enhanced diagnostics with Dtrace runtime monitoring.
  • Expanded SHOW ENGINE INNODB STATUS output.
  • Performance optimizations to leverage MySQL on Solaris.
  • New performance status variables.
  • Configurable read (INNODB_READ_IO_THREADS) and write threads (INNODB_WRITE_IO_THREADS) allow MySQL to leverage hardware capability.
  • Significantly enhanced I/O with InnoDB.
  • Improvement of stored procedures with SIGNAL and RESIGNAL additions.
Initial releases support Solaris, MacOS and Free BSD.  MySQL 5.4 will be available in the future to Solaris, MacOS, popular versions of Linux, Free BSD, HP-UX and AIX.

Monday Apr 20, 2009

The Oracle announcement to purchase Sun Microsystems makes the  IOUG Collaborate 09 Conference (May 3-7 2009, Orlando FL) a very hot ticket.    The IOUG conference will bring together the top Oracle technology leaders in the user community.    You can expect a lot of great discussions and interactions discussing the potential of the Oracle acquisition with Sun within the Oracle user community.

Oracle and Sun employees cannot discuss the potential of this acquisition, however the top industry leaders in the Oracle user community and Oracle 3rd party vendors and partners will definitely be discussing this interesting news.

The IOUG is the largest Oracle user technology user group in the world.  Whenever you bring the top Oracle technology leaders in the user community you can expect a lot of discussion and interaction between these leaders.   I don't think I've ever gotten more voice mails and emails in one day.   So the buzz is definitely at the highest level.

 This will definitely make the Collaborate 09 conference in Orlando a very dynamic week among the Oracle user community.  The Independent Oracle Users Group (IOUG) can be a very strong  resource to the Sun Microsystems community.  The IOUG focuses on the technology side of Oracle. 

So when you look at some of these areas of the IOUG you can see why the IOUG Collaborate 09 conference just got a lot more exciting:

  • Operating systems, security, storage and all technology components surrounding the Oracle Database Server
  • Oracle Database Server - RAC, Data Guard, Streams, High Availability, Performance Tuning and Backup/Recovery
  • Oracle Fusion Middleware - Java, BPEL, SOA, Web Services, XML, application servers.
  • Identity Management





Oracle's announcement of its intention to purchase Sun Microsystetms definitely started the MySQL Users conference with a bang.    The MySQL conference is always one of the best conferences to attend for the year, so people attending will definitely be having a lot of discussions and interactions. 

It will make it very interesting to have a number of the open source leaders all together for the conference to exchange a lot of ideas.  Some of the most exciting conversations are definitely going to be occurring this week.


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.

Thursday Apr 09, 2009

An organization's corporate culture has a very strong impact on the success of an organization through the values, beliefs, work ethic, camaraderie,  decision making, behaviors and interactions of people.  Through my career I have seen a number of different corporate cultures.[Read More]
Career days for kids can be an incredible experience for all participants.[Read More]

Friday Feb 27, 2009

The potential for Sun's open source strategy has incredible potential if implemented successfully.[Read More]

Wednesday Feb 18, 2009

Sun's activities in Second Life continue to evolve and mature.   Next on the list is a Second Life campus for MySQL.[Read More]

Thursday Dec 11, 2008

Sun's strategy is working with open source.  Open source offers tremendous revenue opportunities for Sun and significant cost savings for customers.   I am seeing a constant explosion of open source everywhere I go.   I not only see more companies looking at using MySQL but lots of organizations are looking at open source solutions for all kinds of areas where they previously used proprietary software.   Here is a great list of open source solutions.

[Read More]

Wednesday Dec 10, 2008

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]

Thursday Nov 27, 2008

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

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.



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 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

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

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.

 

 

 

This blog copyright 2009 by George Trujillo