MySQL
SHOW WARNINGS woes
Recently on a client site I had to fight the pain of having no way to confirm loss of data integrity when optimizing data types. Due to MySQL’s ability to perform silent conversion of data, when converting a number of columns we enabled sql_mode to catch any truncations as errors.
Read moreThe MySQL crystal ball says …
As the recipient of the 2009 MySQL Community Member of the Year award I received a MySQL crystal ball. While it looks good in my bookcase, unfortunately the best advice I can offer during this time of uncertainty is “watch this space”.
Read moreMySQL for the Oracle DBA Resources
The announcement last month of Oracle to acquire Sun continues to warrant a lot of discussion over exactly what Oracle will do with MySQL. Only time will tell what will happen with the official product, however it is important to remember that MySQL is GPL, there will always be a free version of MySQL available for popular LAMP stack products such as WordPress and Drupal and new and existing startup’s will continue to use MySQL.
Read moreHiTCHO Top tech tips
I recent visit with old Brisbane friend HiTCHO which I met at the Brisbane MySQL Users Group in 2005, has lead to this cool list of some hardware and software technologies he used that I am now considering or have already implemented or purchased.
Read moreDrizzle now available on Mosso
Mosso the Rackspace Cloud now has a Drizzle developer image much like the first Drizzle AMI on EC2 . The Mosso interface is definitely different, it’s a GUI, and I definitely prefer CLI, but it’s a simpler navigation for a new user.
Read moreOne advantage of Oracle/Sun/MySQL
This weeks’ announcement Oracle to by Sun was a major talking point at the 2009 MySQL Conference & Expo . While it is too early to even speculate what the future holds with the official MySQL product, for myself a speaker on MySQL topics, Oracle Open World is now a target market.
Read moreAnnouncing Drizzle on EC2
I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try.
Read moreAdding a Drizzle Plugin
I joined about 50 others including a number of core MySQL developers and MySQL community members today for the 2009 Drizzle developers day at Sun Microsystems Santa Clara campus. In addition to a number of presentations and various group discussions most of my individual hacking time was under the guidance of Drizzle team developer Stewart Smith were Patrick Galbraith and myself started the porting of Patrick’s memcached UDF functions for MySQL .
Read morePercona Performance Conference Talk
My final presentation during the 2009 MySQL Conference and Expo week was with the Percona Performance Conference on the topic of The Ideal Performance Architecture. My talk included discussions on Technology, Disk, Memory, Indexes, SQL and Data.
Read moreMySQL Monitoring 101
At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101 . This presentation focused on the following four goals. Know what to monitor Know how you can monitor Learn practices to diagnose problems Have a foundation of historical information MySQL Monitoring 101 View more presentations from Ronald Bradford.
Read moreA change in the MySQL Binary distributions
Yesterday was the surprise announcement of MySQL 5.4 at the 2009 MySQL Conference and Expo. It was unfortunate that the supporting information was not that forthcoming on the MySQL website. I tried for several hours to try and download, but no mirrors were initially available.
Read moreSetting up MySQL on Amazon Web Services (AWS) Presentation
On Tuesday at the MySQL Camp 2009 in Santa Clara I presented Setting up MySQL on Amazon Web Services (AWS). This presentation assumed you know nothing about AWS, and have no account.
Read moreWhat’s happening with InnoDB
I have moved on to InnoDB: Innovative Technologies for Performance and Data Protection by Ken Jacobs at MySQL Conference and Expo . With a brief history lesson of inception from 1994, inclusion in MySQL in 2000 and acquired by Oracle in 2005.
Read moreSearch at Craigslist
I am now sitting in on MySQL and Search at Craigslist by Jeremy Zawodny at MySQL Users Conference Some of the technical difficulties that required addressing. High churn rate half life can be very short Growth Traffic Need to archive postings, e.
Read more