MySQL & Oracle Professional Services, trainer, author, speaker
Areas of Expertise:
- Oracle 9i
- Oracle 10g
- Oracle 11g
- plsql
- dataguard
- logical + physical standby
- high availability
- RAC
- real application clusters
- cost-based optimizer
- bitmap index
- b-tree index
- rman
- partitioned tables
- performance
- data warehousing
- oltp
- Unix
- SQL Tuning
- Troubleshooting
- mysql
- master-master replication
- backup
- transactions
- query cache
- large database
- clustering
- InnoDB
- MyISAM
- memcache
- merge
- federated
- optimize
- security
- join
- lob
- shell scripts
- csh
- perl
- php
- LAMP
- drupal optimizations
- apache
- cpu + IO performance
- 100G+ databases
- automated reports in perl
- query optimization
- index tuning
- consulting
- speaking
- programming
- training
- writing
Biography
Books
|
|
(Blog
http://oracleopensource.com
November 11 2009
In this second part of our piece on scaling, we talk about running more instances of MySQL either on a single server or multiple servers, to get faster overall response for your queries. This will require some work with your application making decisions about where it will find its data… read moreOpen Insights 61 – Medicine of Austerity
November 02 2009
In our latest newsletter we discuss what economists are dubbing the “medicine of austerity” aka paying the piper or tightening your belt. And we think that this medicine will surely include open source technologies. Open Insights 61 – Medicine of Austerity read moreDBJ: Scaling Faster & Stronger MySQL
October 12 2009
Sometimes terms like scaling are - as the brits like to say - bandied about, without everyone agreeing on what they mean. That’s because scaling is an insiders term, a technical term thought to carry great weight, but nevertheless often misunderstood.So I wanted to write an article about this interesting… read moreOpen Insights 60 - Principal Agent
October 01 2009
Issue 60 marks our newsletter’s five year anniversary. How time flies! This month we talk about the very prescient topic of the principal agent problem. If you’ve ever been to the mechanic and wondered about what problem your car really has, and whether the mechanic might be inflating the story to… read moreOpen Insights 59 - Invisibility of Skills
September 01 2009
Our newsletter this month hits upon the topic of skills. How often are skills not obvious upon first observation of someone? We illustrate this point first by looking at some martial arts classes and then some resumes! Issue 59 - Invisibility of Skills addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F09%2F01%2Fopen-insights-59-invisibil ity-of-skills%2F'; addthis_title = 'Open+Insights+59+-+Invisibility+of+Skills'; [...] read moreDBJ: 7 Ways To Crash a Database
August 15 2009
With a tongue in cheek, humorous tone, we turn the tables upside down on database best practices, illustrating all of the things you shouldn’t do, and what might happen if you ignore those important tasks. 7 Ways To Crash A Database addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F08%2F15%2Fdbj-7-ways-to-crash-a-data base%2F'; addthis_title = 'DBJ%3A+7+Ways+To+Crash+a+Database'; addthis_pub [...] read moreWebcast: Step-by-step MySQL Clustering Setup
August 10 2009
I recently did a webcast for O’Reilly and Associates on MySQL Clustering Setup and configuration. Click here to see a clip over at O’Reilly. addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F08%2F10%2Fwebcast-step-by-step-mysql -clustering-setup%2F'; addthis_title = 'Webcast%3A++Step-by-step+MySQL+Clustering+Setup'; addthis_pub = ''; read moreAugust 03 2009
In our latest newsletter we take a trip to the Brooklyn Flea, and talk with the purveyors not of homemade beer, but homemade beer making equipment. We share some insights at how enthusiasts, technology geeks, open source aficionados and passionate detail oriented folks in many niches share a common trait… read moreJuly 10 2009
In this month’s article over at Database Journal we discuss more areas to tune your initial MySQL database setup including InnoDB & MyISAM buffers, hit ratios, index usage and full table scans, security, and logs. With this second article in a two part series we complete our coverage of basic… read moreOpen Insights 57 - Logic Alone?
July 08 2009
In this month’s issue we discuss assessing people, and how we determine qualification. In particular we look at skills and compare the to immeasurables like drive, loyalty, and fortitude as factors which are often more difficult to measure, but perhaps more crucial to success. Open Insights 57 - Logic Alone? addthis_url… read moreJune 12 2009
This month in Database Journal we start a two part article on tuning the dials of your new MySQL database. After you install and setup your first database, you’ll need to set various parameters in your my.cnf file. These control memory, logfiles, temp table usage, sorting, joins, and a whole… read moreOpen Insights 56 - Cui Bono - To Whose Benefit?
June 09 2009
Issue 56 - Cui Bono - To Whose Benefit? addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F06%2F09%2Fopen-insights-56-cui-bono- to-whose-benefit%2F'; addthis_title = 'Open+Insights+56+-+Cui+Bono+-+To+Whose+Benefit%3F'; addthis_pub = ''; read moreOpen Insights 55 - Preserving Optionality
June 09 2009
Issue 55 - Preserving Optionality addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F06%2F09%2Fopen-insights-55-preservin g-optionality%2F'; addthis_title = 'Open+Insights+55+-+Preserving+Optionality'; addthis_pub = ''; read moreDBJ: Getting Started With MySQL Clustering
May 11 2009
If you haven’t worked with MySQL’s NDB Cluster storage engine yet, now is the time to take a peek. There is a sandbox available from serveral nines, which can be installed fairly quickly. This new article over at DatabaseJournal, MySQL Clustering In A Sandbox will have you up and running… read moreDBJ: Five Query Optimizations in MySQL
April 06 2009
A new article is up on Database Journal where I discuss some query optimizations that work well with MySQL applications.Five Query Optimizations in MySQL addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F04%2F06%2Fdbj-five-query-optimizatio ns-in-mysql%2F'; addthis_title = 'DBJ%3A+Five+Query+Optimizations+in+MySQL'; addthis_pub = ''; read moreMultimedia
Webcast - Hands-on: Step-by-step MySQL Clustering Setup
August 04, 2009
Duration: Approximately 60 minutes. Preview Video: Free Full Video: Available on Safari Books Online MySQL's Clustering solution provides some pretty sophisticated functionality. In this webcast we'll take you through getting it up and running on...
Webcast - MySQL Replication: Audit, Test, & Verify
January 22, 2009
Duration: Approximately 60 minutes. Cost: Free Audience: MySQL DBAs and developers MySQL replication is fairly easy to set up, but in the real world many obstacles can get in the way of keeping it up and running smoothly. One problem that seems ...
Also find Sean on:
Recent Twitter posts:
