Databases
MySQL 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 moreBIGINT v INT. Is there a big deal?
The answer is yes. In this face off we have two numeric MySQL data types, both Integer. In fact MySQL has 9 different numeric data types for integer, fixed precision and floating point numbers, however we are just going to focus on two, BIGINT and INT.
Read moreOff to OSCON
I will be heading to my first OSCON next week where I will be presenting MySQL Proxy: from Architecture to Implementation in conjunction with Giuseppe Maxia . As was written by Colin Charles Our booth is yours… Sun at OSCON , Sun/MySQL would appear to also have a reasonable turnout.
Read moreWhy SQL_MODE is important? Part I
MySQL pre version 5.0 was very lax in it’s management of valid data. It was easy for data integrity to be abused if you knew how. The most common examples were truncations and silent conversions that if not understood could provide a serious data integrity issue.
Read moreSun Stock Prices
Sun Microsystem’s (NASDAQ:JAVA ) hit a low this week of $8.71. There was a stronger rally and a close at $9.16 today. The financial times reports Sun Micro chief sees rays of hope , and Bloomberg Sun Rises After Fourth-Quarter Profit Tops Estimates .
Read moreAuditing your MySQL Data – Part 2
Continuing from my earlier post Auditing your MySQL Data , Roland has accurately highlighted that my initial post leaves out some important information for auditing. As the original charter was only to keep a history, for the purpose of comparing certain columns, a history was all that was needed.
Read moreAuditing your MySQL Data
I was asked recently by a client to help with providing a history of data in certain tables. Like most problems, there is no one single solution, and in this case there are several possible solutions.
Read more