Tuesday Dec 09, 2008
Wednesday Nov 26, 2008
By George Trujillo on Nov 26, 2008
Monday Nov 10, 2008
By George Trujillo on 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).
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.
Monday Oct 27, 2008
By George Trujillo on 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. :)
Anders Karlsson - MySQL Professional Services
David Stokes - MySQL Certification Manager
Clifford Conklin - Sun Professional Services
George Trujillo - MySQL Sr. InstructorDomas Mituzas - Wikimedia
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.
Build core fundamental knowledge in MySQL and show attendees the path to certification and where to find things so they can get certified.
Sun employees with some database experience (SQL, Oracle, Postres, SQL Server, etc) that want to get into delivering MySQL certification and consulting.
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
By George Trujillo on 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:
- Dave is the MySQL Certification Manager for Sun Microsystems. There are some good hints at David Stokes blog at dave-stokes.blogspot.com.
- Read the questions carefully and answer them quickly to the best of your knowledge, do not over analyze the questions.
- 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.
Friday Oct 10, 2008
By George Trujillo on 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.
Sunday Sep 28, 2008
By George Trujillo on Sep 28, 2008
Looking at Oracle versus MySQL Environments
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 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
By George Trujillo on Sep 26, 2008
From my perspective, my four big take aways from Oracle Open World 2008 are:
- 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.
- 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.
- Increasing demand for BI, Hyperion and Stellent.
- Oracle environments are significantly increasing in complexity, products, integrations and the need to understand how to work with all the pieces.
Thursday Sep 25, 2008
By George Trujillo on Sep 25, 2008
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
By George Trujillo on Sep 24, 2008
By George Trujillo on Sep 24, 2008
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.
By George Trujillo on Sep 24, 2008
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.
By George Trujillo on Sep 24, 2008
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
By George Trujillo on Sep 23, 2008
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. :)
By George Trujillo on Sep 23, 2008
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
By George Trujillo on Sep 22, 2008
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
Thomas Kurian Keynote
- 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
- 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".
By George Trujillo on Sep 22, 2008
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
"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
By George Trujillo on Sep 20, 2008
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.
By George Trujillo on Sep 20, 2008
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.
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
- 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.
By George Trujillo on Sep 20, 2008
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
By George Trujillo on Sep 02, 2008
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.
Tuesday Jul 01, 2008
By George Trujillo on Jul 01, 2008
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.
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 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
By George Trujillo on Jun 11, 2008
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
By George Trujillo on May 28, 2008
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.
Price/Performance Great performance when applications leverage architecture.
Aircraft carrier database capable of running large OLTP and VLDBs.
Enterprise ($) – supported, more stable.
Community (free) – more leading edge.
Standard One ($)
Express (free) – up to 4GB
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.
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.
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.
Web (MySQL excels)
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
3) Ruby on Rails
4) Ruby on Rails
Note: Oracle focusing on Java for next generation business applications.
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.
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:
Redo and archive log files are used for point in time recovery.
Tables use storage engines. Each storage engine provides different characteristics and behavior.
A few tables with tons of features.
Free, basic features
$$$ with lots of options
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.
InnoDB and upcoming Falcon and Maria storage engines
Regular and Index only tables support transactions.
No online backup built-in.
InnoDB Hot Backup
Recovery Manager (RMAN) supports hot backups and runs as a separate central repository for multiple Oracle database servers.
Easy, very basic.
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.
$, 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.
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.
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:
- 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.
- 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.
- 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.
Tuesday May 27, 2008
By George Trujillo on May 27, 2008
Here are ten things to know about MySQL if you are new to MySQL on Solaris:
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- MyISAM tables totally rock when high speed reads are very important. Make sure you understand all characteristics or these tables before using them.
- InnoDB is the transactional storage engine to use through MySQL 5.1.
- New storage engines such as Maria, Falcon and enhancements to InnoDB are going to change the use of MySQL in the enterprise.
- 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.
- 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.
- 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.
- MySQL Enteprise Monitor is MySQL's management and monitoring software for managing MySQL database servers. It contains lots of GUI interfaces and advisors.
- Popular software seen in MySQL environments include memcache, SQLYog, Navicat, Pentaho and Nagios.
By George Trujillo on May 27, 2008
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:
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
By George Trujillo on Apr 30, 2008
- 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
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.
- Virtualization at Collaborate 2010 Oracle Users Conference
- The Journey Continues
- Oracle Sun Strategy Webcast - January 27, 2010
- Oracle Sun Strategy Webcast
- Oracle wins unconditional approval from EU for the Sun purchase
- Sitting in on Sun Exadata Storage Engine Class
- Just Got Accepted to the Sun Ambassador Program
- Virtualization Bootcamp at Collaborate 10 - April 18, 2010 Las Vegas
- Received the Socrates Award
- The Importance of Peripheral DBA Skills