MySQL
Choosing MySQL 5.1 over 5.0
I have been asked twice this week what version of MySQL I would choose for a new project. As with most questions in life the answer is: It Depends? In general I would now recommend for a new project to select 5.
Read moreWhat are the best MySQL Design Practices?
Tonight I provided a scope in Best Design Practices for MySQL Applications – Part A of just how much there is to consider with a successful application. I only scratched the surface in some detail, a topic one could easily write a book on, and definitely provide a number more presentations.
Read moreMonitor and Optimize Your MySQL, Microsoft SQL Server and Oracle Databases 24×7.
I came across another MySQL Monitoring product today, DBTuna. I’ve got a trial license of this commercial product so I’ll be looking into its installation, options and support and will be reporting back.
Read moreUsing consistent data types for columns
I came across this error recently when trying to modify the data type of a column. ERROR 1025 (HY000): Error on rename of './sakila/#sql-1d91_5' to './sakila/inventory' (errno: 150) Not the first time, and not the last time.
Read moreMySQL involvement in OSCON opening keynote
Before I get to post my OSCON reflection I see I didn’t post this (which I reference). At OSCON opening keynotes Tim O’Reilly Interviews Monty Widenius & Brian Aker . This provided some interesting answers in a Q & A session.
Read moreDrizzle needs you
Use MySQL, but want to follow the new kid on the block? Want to help contribute to Drizzle? We are seeking help in compiling across different platforms. Please help us by becoming a buildbot slave .
Read moreMySQL Proxy lua scripts from presentation
The following Lua scripts are the examples are from my MySQL Proxy @ OSCON 08 presentation. analyze_query.lua MySQL Proxy Analyze Query . Requires MySQL Proxy Logging Module . What is released is the Version for MySQL 5.
Read moreMySQL Proxy @ OSCON 08
Today I presented with Giuseppe Maxia of Sun Microsystems Inc at OSCON 08 on “MySQL Proxy: From Architecture to Implementation”. I was surprised to find that MySQL has a strong showing with a number of presentations this week.
Read moreThe fast paced open source ecosystem
This morning at <a href=““http://en.oreilly.com/oscon2008/">OSCON 08, Tim O’Reilly’s opening keynote Open Source on the O’Reilly Radar included a slide on Drizzle, giving this new project maximum exposure to the Open Source community.
Read moreThe new kid on the block – Drizzle
Before today, Drizzle was known as a light form of rain found in Seattle (among other places). Not any more. If you have not read the news already today, Drizzle, Clouds, “What If?
Read moreAn East Coast option
Within the present MySQL ecosystem, there are limited options for dedicated MySQL Consulting in the US. Outside of the official Sun/MySQL Consulting , Percona and Proven Scaling both based in Silicon valley are the only options generally known and accepted by the MySQL Community.
Read moreYour data and the cloud
I will be speaking on July 29th in New York at an Entrepreneurs Forum on A Free Panel on Cloud Computing . With a number of experts including Hank Williams of KloudShare, Mike Nolet of AppNexus, and Hans Zaunere of New York PHP fame is should be a great event.
Read more