Sunday Apr 11, 2010

Virtualization at Collaborate 2010 Oracle Users Conference

Virtualization Bootcamp on Solaris Containers

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

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

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

Key speakers include:

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


Virtualization during the week at Collaborate 2010

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

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

Wednesday, April 21

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

Saturday Feb 13, 2010

The Journey Continues

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

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

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

Tuesday Jan 26, 2010

Oracle Sun Strategy Webcast

IT Superbowl

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

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

 Agenda: Oracle Sun Strategy Webcast

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

Tuesday Jan 12, 2010

Sitting in on Sun Exadata Storage Engine Class

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

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

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

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


Tuesday Dec 15, 2009

Just Got Accepted to the Sun Ambassador Program

Just found out I was invited to join the Sun Ambassador Program.  This is a Center of Excellence group for Sun's application platform that you have to be voted in by your peers, so I am especially excited to be part of the program.

As a leader in the Oracle User Community and an Oracle ACE in the Fusion Middleware area, Oracle DBA for 20 years and MySQL background I hope to use these along with my Sun background in Solaris and Java to provide strong leadership in creating a great environment for exchanging and sharing ideas in Sun Application Platform and middleware space.  Migrations, ETLs, interoperability are all really hot areas among Sun customers and I plan on jumping in with both feet.  :) 

Mission

The Application Platform Ambassadors are chartered with evangelizing the unique value created through our application platform architectures and product offerings. The Application Platform Ambassadors will bring together thought leaders to collect, develop and disseminate content, and provide a formal conduit to share ideas, issues, and opportunities with the Application Platform engineering organization with the singular goal of improving Sun's focus and sales growth in this market area.

Application Platform Ambassador Scope

The Application Platform Ambassadors focuses on the following technologies:

  • MySQL
  • Glassfish
  • Java, JavaFX
  • Identity Management

Saturday Nov 21, 2009

Virtualization Bootcamp at Collaborate 10 - April 18, 2010 Las Vegas

Virtualization Bootcamp for Oracle Technology Professionals

Collaborate 10 - Oracle User Conference  April 18, 2010

Mandalay Bay Convention Center, Las Vegas, NV

Virtualization Bootcamp on Solaris Containers

Presenters: George Trujillo (Sun Microsystems) and Steve Lemme (Computer Associates)


Environment

Attendees can bring their own laptop and use a Sun Virtual Box solution on their own machine to configure and manage a Solaris virtualized environment.  A laptop is not required if an attendee would like to watch the workshop demonstrations instead of doing the hands on labs.

Presentation Abstract

In supporting and managing new technology,  administrators and DBAs are increasing virtualized environment deployments with production applications, web servers and databases being moved into them.  Virtualization is one of the  hottest areas in database environments for reducing the total cost of ownership and optimizing operations.   Virtualization offers, speed, flexibility and agility in managing systems, databases, application servers. and applications.  Beyond the driving factors, what do you need to know to be successful in supporting and managing virtualized environments?   Join your peers in this bootcamp designed to help you increase your skills,  learn virtualization fundamentals as well as management essentials.  Virtualization is increasing its role  and is a stepping stone for cloud computing and automation in the data center.

Outline

  • Virtualization opportunities and challenges
  • Benefits of virtualization
  • Industry terminology
  • Virtualization role in Cloud Computing
  • Types of virtualization technology available
  • Server consolidation
  • Working with virtualization technology such as Sun Solaris Containers, Logical Domains,  Zones, VMware and Oracle VM
  • Virtualization architectures
  • Set up and migration to a VM
  • Configuring a Solaris Zone
  • Zone administration and management
  • Creating backups in zone environments
  • Migrating a zone
  • Installing packages in zones
  • Configuring zone resources
  • Database considerations in a VM environment
  • Database management through virtualization
  • Cloning databases
  • Database backups in a VM
  • High availability in a VM environment
  • Testing and deployment
  • Essential roles and skills for virtualized envionments
  • Virtualization management
  • Virtualization best practices

Learning Objective 1

Industry trends, terminology, features, challenges and benefits of virtualization

Learning Objective 2

Key fundamental skills in virtualization through Solaris containers and logical domains.

Learning Objective 3

The opportunity virtualization and cloud computing provides and how you can take advantage in your own project work

Prerequisites

A background in database and/or Unix operating systems.


Note

Some of the technical topics may be modified as we get closer to the bootcamp start date to make sure the latest information is covered.

Wednesday Apr 08, 2009

Corporate Cultures

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]

Friday Feb 27, 2009

Sun's Strategy is Working and the Growth is Exciting!

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

Wednesday Nov 26, 2008

Why you need to root for Sun, MySQL and Open Source?

As our global world deals with the current economic challenges you will see more and more streamlining and cost cutting by organizations.  Where open source and MySQL make sense, they are going to save organizations tons of money and allow them more operational flexibility.[Read More]

Monday Nov 10, 2008

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 .  

Sunday Nov 09, 2008

Sun CEC 2008: Sun Products Greatly Expand MySQL Capability

I've gotten incredibly excited about Sun products that greatly expand the capability of MySQL. What's been great is the excitement is coming from customers.  If you are using MySQL you really need to take a look about how these Sun products are leveraging MySQL in customer environments.   The powerful features and cost savings are very significant so every customer should be looking at how they can benefit from these products.

ZFS  - fast file system supporting volume management, snapshots and copy on write clones.
Glassfish – Application server
Zones/Containers - isolated virtual servers within a single operating system instance
Zone Cluster  - high availability solution
Dtrace – powerful diagnostics tool
Open Solaris – powerful open source operating system

Sun Storage 7000 series - highly cost-effective storage solution


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

 

 

 

Saturday Sep 20, 2008

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

 

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

Session Description 

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

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

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

Tuesday 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

 

 

 

 

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.  

Wednesday May 07, 2008

Sun: Getting Started with MySQL

A quick getting started guide to learning MySQL.[Read More]
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