Open Source
Free 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 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 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 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 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 moreCompiling libdrizzle
Compiling libdrizzle is a rather trivial task. The following are the steps I undertook on Ubuntu 8.10 Intrepid 32 bit. There was one pre-requisite from the most basic installed developer tools.
Read moreDrizzle/bzr dependency
A number of developers had problems on Friday at the Drizzle Developer Day with compiling bzr . The distro in question I was helping with was CentOS 5 32-bit. I had no issues on CentOS 5 64bit.
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 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 moreWhere is the MySQL in Sun’s announcement
I find it surprising that in the official Sun Announcement there is no mention of MySQL for two reasons. Firstly, this was Sun largest single purchase of $1 billion only 12 months ago.
Read moremysql.com search is so broken
Today, while on the MySQL manual page , I typed in ‘select’ in the search manual box to confirm the SELECT syntax. The result was not what I expected, the “SELECT” command.
Read more