Blog
OSCON 2009 at a discounted rate
OSCON moves this year from Portland to San Jose. As one the community panel for Drizzle: Status, Principles, and Ecosystem I also have a speaker discount which you can combine with O’Reilly having also extended early bird registration until June 23.
Read moreMySQL Book winner – for 5 configuration options
If you had to configure a WordPress MU installation without access to any details of your MySQL Configuration, what would you do? What top five configuration settings would you use?
Read more(Mis)Understanding RAID configuration
Update 8 June 2009 Be sure you to check out some of my research including Understanding your RAID Configuration and Understanding PERC RAID Controllers . Last week I got caught thinking a MySQL production system wasn’t configured with RAID when it actually was.
Read moreLeveraging the power of Twitter
Last week I posted the following twitter request — “Can somebody loan me (or buy me) a Dell 2950 decked out so I can run and publish some benchmarks. Please!”
Read moreFree MySQL Book giveway – Current Progress
I’ve decided to give people two more days for a chance to win a free MySQL Book — Sheeri Cabral’s MySQL Administrators Bible . I have had five people so far provide recommendations for a simple MySQL configuration question as stated in <a href=http://ronaldbradford.
Read moreMore Basic MySQL Security
The reason for yesterday’s Basic OS/MySQL Security was a request to review a system and I was given the production server ‘root’ password in an email. Never email a ‘root’ password, especially including the hostname as well.
Read moreFor MySQL DBA fame and glory. Prize included.
I came across the following configuration today on a Production MySQL system (5.0.67) running 30+ blogs using WordPress MU . $ cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database No I did not truncate the output.
Read moreBasic OS/MySQL Security
If you can do either of these on your MySQL production server, you need to correct immediately. 1. Login directly to your MySQL server as the ‘root’ Linux Operating System user.
Read moreTranscending Technology Specific Boundaries
I had the pleasure to sit on the Performance Panel at the recent Percona Performance Conference . While the panel contained a number of usual MySQL suspects, one person was not familiar, that being Cary Millsap from Method R .
Read moreSHOW 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 more