MySQL
Monitor 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 moreWhen (n) counts?
I have seen on many engagements the column data type is defined as INT(1). People have the misconception that this numeric integer data type is of the length of one digit, or one byte.
Read moreThe minimum testing for a shared disk MySQL environment
Recently I was asked to provide guidelines for testing fail over of a MySQL configuration that was provided by a hosting provider. The first observation was the client didn’t have any technical details from the hosting provider of what the moving parts were, and also didn’t have any confirmation other then I think a verbal confirmation that it had been testing.
Read more