Despite my best intentions, I haven't posted on this blog for a while, which is a shame! I've become busy writing on so many other places since I moved into my new role in the Oracle Linux product management team in April. I've learned a lot and I am feeling quite at home here! The team is excellent and very nice to work with — I am slowly getting the "Big Picture".

But even though I've been neglecting this blog, there are a lot of things that are publicly visible and document some of my activites:

I've created two podcasts for the Oracle Linux podcasts:

• OCFS2: Features and Benefits
• …

Download PDF Presentation
Download Audio

There are a number of significant new features in MySQL 5.5 including semi-synchronous replication, SIGNAL and RESIGNAL, the PERFORMANCE_SCHEMA, additional STATUS variables, new partitioning options, different default storage engine, better UTF8 support and removal of deprecated functions just to list key considerations.

However some of the performance improvements are worth the investment of time. For a high concurrency InnoDB environment one new configuration alone can provide a …

On July 12th at 9 AM PST I will be giving a webinar about performance implications for Hibernate and Connector/J. If you cannot attend at this time, a recorded session will be available soon after the webinar.

MySQL is not only about LAMP, and a lot of people use it from Java apps. For some of those, Hibernate is the persistent framework of choice. This webinar will discuss the performance implications of using Hiberate to manage persistence with a MySQL backend, and also some more broad implications for Connector/J  that will apply for anyone using MySQL from Java.

Topics will include:
* Very brief overview of ORMs and Hibernate
* Fetch strategies
* Lazyness
* Manually written SQL
* Concurrency
* Concurrency-related config options for Connector/J

You may register …

fisl12 is likely the largest free and open source software event in Latin America. This year, it takes place in Porto Alegre, Brazil, from June 29th to July 2nd. Oracle is a gold sponsor of the event and I will attend it as a speaker. I feel honoured and excited to be there – for me it will be the first visit to the South American continent.

They already have over 3000 registered attendees, so this definitely is going to be a great conference. There is quite a number of well-known names on the speaker roster and I look forward to meeting a lot of familar faces there.

The agenda is still under development but quite impressive already – …

Download PDF Presentation

Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema significant improvements in performance can be achieved by creating better indexes.

This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply better indexes and provide even greater performance gains.

This presentation includes:

• 6 steps to successful SQL review
• Effective …

Linuxtag is likely one of the oldest and largest Linux/OSS events in Germany. I remember having been there to represent SuSE Linux while it still took place at the University of Kaiserslautern, using tables and chairs from the lecture rooms as exhibition stands (this must have been around 1998 or 1999). This year it will take place in Berlin again, and the session schedule looks very promising. I'll be there from Wednesday till Friday and I feel that I will have a hard time deciding which presentations I should attend...

I'll be speaking about What's new in MySQL 5.5 on Friday, 13th of May, at 15:00. If you haven't updated to MySQL 5.5 yet, stop by to hear what new …

Download PDF
Presentation Part I
Download PDF
Presentation Part 2

Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Learn what subtle differences between Oracle and MySQL are essential to understand in order to maximize the benefits of MySQL. We will be covering the ideal means for writing SQL statements, documenting your SQL, analyzing your SQL, MySQL software installation, configuration and maintenance best practices.

This new …

Download PDF Presentation

The most common mistakes are easy to avoid however many startups continue to fall prey, with the impact including large re-design costs, delays in new feature releases, lower staff productivity and less then ideal ROI. All growing and successful sites need to achieve higher Availability, seamless Scalability and proven Resilience. Know the right MySQL environment to provide a suitable architecture and application design to support these essential needs.

• The different types of accessible data (e.g. R/W, R, none)
• What limits MySQL availability (e.g software upgrades, blocking statements, locking etc)
• The three components of scalability – Read Scalability/Write …

Download PDF
Presentation

Can database performance improvements be achieved with zero code changes? Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema as shown in our 10 table join example, significant improvements in performance can be achieved.

This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply better indexes and provide even great performance gains.

This presentation …

In a few weeks, I will be on the road, for an intense set of presentations in the USA.

San Francisco, April 7thI will start the tour at the San Francisco MySQL User Group. On April 7, at 6pm I will talk about Advanced MySQL replication for the masses. This talk will explore topics such as bi-directional replication, multiple sources, parallel replication, seamless failover, with the help of Tungsten replicator.




Santa Clara, April 11, 12The MySQL conference starts on Monday, April 11th, with several three-hour tutorials.

• April 11, 9:00amMySQL Replication Advanced Techniques. This will cover MySQL replication beyond the basics. Everything you can do with replication, …