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
June 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 moreIssue 54 - Path Dependency Avoidance
April 02 2009
Path Dependence is a technical term which basically means the further along a given path you go, the more pressure there is to “stay the course”. In this months open insights issue, we discuss this phenomenon in consulting, and suggest some ways to help eliminate or reduce that dependence and… read moreDBJ: Optimizing the MySQL Query Cache
March 12 2009
The MySQL Query Cache is a powerful piece of engineering that users of the popular open source database can take advantage of to speed up throughput of their applications. MySQL’s cache operates a little bit differently from other database engines. It does not just cache query plans, but the query… read moreDBJ: Optimizing the MySQL Query Cache
March 09 2009
The MySQL Query Cache is a powerful piece of engineering that users of the popular open source database can take advantage of to speed up throughput of their applications. MySQL’s cache operates a little bit differently from other database engines. It does not just cache query plans, but the query… read moreOpen Insights 53 - Focus on Results
March 03 2009
Our latest issue of Open Insights #53 for March 2009, we discuss the idea “focus on results on process”. From buying technology hardware, to buying licenses, hiring consultants, to upgrading enterprise software, this simple maxim can provide some new insights into our decision making processes, and hopefully save us time… read moreDBJ - Advanced MySQL Replication - Improving Performance
February 11 2009
Our latest article over at Database Journal is hot off the presses. Advanced MySQL Replication - Improving Performance discusses some of the best ways to improve the performance of your MySQL slave setup. If the slave is constantly getting further and further behind the master database, we discuss a number… read moreO’Reilly Webcast - MySQL Replication - Audit, Test & Verify
February 03 2009
My O’Reilly webcast is now online at youtube. Comments welcome! addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2009%2F02%2F03%2Foreilly-webcast-mysql-repl ication-audit-test-verify%2F'; addthis_title = 'O%27Reilly+Webcast+-+MySQL+Replication+-+Audit%2C+Test+%26+Verify'; addthis_pub = ''; read moreJanuary 19 2009
MySQL Replication is fairly simple to setup for the first time. However over time maintenance can become troublesome. At times errors show up in the error logs, or it can stop running altogether. In fact MySQL Replication can fail in a much more insidious way, that is silently. So what… read moreOpen Insights 51 - Stretch Your Database Dollar
January 09 2009
Over the holidays I had the chance to catch up on some podcasts I hadn’t listened to. In particular Financial Times has an excellent weekly one called “Digital Business”. In the last one for 2008, Peter Whitehead interviews a few people to get their forcasts for 2009. Of particular interest to… read moreDBJ: Reliable MySQL Replication
December 05 2008
Part II in our series on MySQL picks up where we left off from talking about some of the challenges, and potential issues and problems that come up with MySQL replication after you have it setup and running for some time. DBJ: Fixing MySQL Replication In this piece we talk about… read moreOpen Insights 50 - Do Your Dishes
December 01 2008
Our 50th issue of Open Insights Newsletter is out. We think you’ll enjoy the analogy!! addthis_url = 'http%3A%2F%2Foracleopensource.com%2F2008%2F12%2F01%2Fopen-insights-50-do-your-d ishes%2F'; addthis_title = 'Open+Insights+50+-+Do+Your+Dishes'; addthis_pub = ''; read moreMultimedia
Webcast - Hands-on: Step-by-step MySQL Clustering Setup
August 04, 2009
Duration: Approximately 60 minutes. Cost: Free MySQL's Clustering solution provides some pretty sophisticated functionality. In this webcast we'll take you through getting it up and running on your laptop or single node server, building a sandbox where...
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:
