The latest from the MySQL community

The problem Hands up those that don’t monitor their production MySQL web server. I’m a little surprised by this, but I’ve visited several clients that have absolutely no monitoring other then “the customers will tell us when something is wrong”.

The problem Hands up those that don’t monitor their production MySQL web server. I’m a little surprised by this, but I’ve visited several clients that have absolutely no monitoring other then “the customers will tell us when something is wrong”.

Over the last several weeks I have been testing out the 2 mtron drives that easy computing company provided me. In fact I have been testing like a madman. Nightly I would kick off a batch of DBT2 tests, sysbench tests, bonnie++, and more. Each test changed something about the environment I was testing. RAID 1, RAID 0, with easy’s MFT, without the MFT, with the logs on SSD, With the logs on a raptor drive, etc. Each test run when it completed successfully would take roughly 12 hours. a typical example of a portion of one of these test runs is:

shutdown mysql
remove the data and log files
wait 5 minutes
startup mysql
wait 5 minutes
load a 200 warehouse DBT2 test
wait 5 minutes after the load is complete
run DBT2 test

rinse and repeat.

Minimally I have been doing a 40 active warehouse dbt2 test and a 60 active …

The slides for today's presentation at Shmoocon are here:

http://technocation.org/files/doc/2008_02_SecuringDBs.pdf

Just a note so folks at the conference can download them whenever they want. Folks not at the conference can, too but the slides don't give away the whole talk so I don't know how useful they're going to be.....

I’m reading the guide, but I’m still too busy with my work to read it proficiently. In order to pass the exam I have to read it again focusing all the details.

But, after reading the first 6 chapters (more then 50% of the entire book) I found the guide useful and simply understandable … and, thanks to lulu.com, it seems to me to be cheapest.
Well done authors!!!