Linux

O’Reilly Twitter Boot Camp a success

The first O’Reilly Twitter Boot Camp – #OTBC was held in New York as a pre cursor to 140 Characters Conference – #140conf on Monday 15th June, 2009. With opening and closing keynotes were like matching bookends of The Twitter Book #twitterbook offered to all attendees and authored by the keynoters @timoreilly and @SarahM .

Read more

Wafflecloud with cream

I have been working recently with Matt Yonkovit to get Waffle Grid cloud enabled with Amazon Web Services (AWS) . An initial version of Waffle Grid Cream – Version 0.5 release is now available.

Read more

multi-threaded memcached

I discovered while compiling Wafflegrid today that by default, the Ubuntu binaries for memcached are not-multithreaded. Following the installation of memcached from apt-get and libmemcached I ran memslap for: $ memslap -s localhost Threads connecting to servers 1 Took 1.

Read more

Problems compiling MySQL 5.4

Seem’s the year Sun had for improving MySQL , and with an entire new 5.4 branch the development team could not fix the autoconf and compile dependencies that has been in MySQL for all the years I’ve been compiling MySQL.

Read more

Understanding your RAID Configuration

For any production MySQL Database system, running RAID is a given these days. Do you know what RAID your database is? Are you sure? . Ask for quantifiable reproducible output from your systems provider or your System Administrator.

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 more

Leveraging 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 more

For 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 more

Basic 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 more

Announcing 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 more

Compiling 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 more

Setting 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 more

Identifying resource bottlenecks – Memory

Continuing on from CPU , we turn our attention to Memory. One of the first steps when addressing a MySQL performance tuning problem is to perform a system audit of the physical hardware resources, then identify any obvious bottlenecks in these resources.

Read more

A beginners look at Drizzle – Getting around with SHOW

Assuming you have successfully compiled Drizzle , and you are ready to start for the first time, here are some beginner differences with those familiar with the current MySQL 5.1 GA version.

Read more