Last year O’Reilly released the 2nd Edition of the  MySQL Cookbook by Paul DuBois.  You can read my review here.

Whenever a publisher releases a 2nd Edition of a book, you know it was well received the first time around.  So that’s a good sign that the material has gotten people buying.  I would say in the computer reference and howto market, that’s a very good indication that the material is well written and relevant.  I certainly found it to be the case with this title.

If you’re looking for a quick & no nonsense howto book on MySQL development, look no further.  The book focuses on Ruby, Perl, PHP, Python and Java as examples.  So if you’re doing development, specifically web development, you’ll get a …

This document here details on how you can do a checkout and build the MySQL codebase from the Bazaar repository.

Some additional points for OpenSolaris 2008.11 :

When you execute $ BUILD/autorun.sh, you might get errors complaining of 'aclocal' and 'automake' not found:

BUILD/autorun.sh[23]: aclocal: not found [No such file or directory]
Can't execute aclocal

Checking for the autotools, I found that 'aclocal' and 'automake' was installed in /usr/bin, as the following binaries:


/usr/bin/aclocal-1.10: executable /usr/perl5/bin/perl script
/usr/bin/aclocal-1.9: executable /usr/perl5/bin/perl script

and similarly for 'automake'.

To get around …

This document here details on how you can do a checkout and build the MySQL codebase from the Bazaar repository.

Some additional points for OpenSolaris 2008.11 :

When you execute $ BUILD/autorun.sh, you might get errors complaining of 'aclocal' and 'automake' not found:

BUILD/autorun.sh[23]: aclocal: not found [No such file or directory]
Can't execute aclocal

Checking for the autotools, I found that 'aclocal' and 'automake' was installed in /usr/bin, as the following binaries:


/usr/bin/aclocal-1.10: executable /usr/perl5/bin/perl script
/usr/bin/aclocal-1.9: executable /usr/perl5/bin/perl script

and similarly for 'automake'.

To get around …

So the good news is that the inaugural OpenSQL Camp is going to be an awesome event with mouth watering sessions by noted experts. The bad news (for me) is that I won't be attending it, which makes me sad. I cannot leave my town because my wife can go into labor anytime now.

The session list looks great! Congratulations and thanks to Baron, Sheeri, Ronald, all the sponsors and contributors for organizing the first OpenSQL Camp.

I will be watching PlanetMySQL closely for juicy blog posts. Hopefully, the one and only Sheeri is taking her camcorder!

Are you interested in testing your Solaris application with MySQL, but don't have the time or resources to setup an environment locally?  Today, Dan Powers reminded me that Sun has made it easy to get pre-configured environments.  The first is via the EZQual Virtual Lab, which allows partners access to secure, no-cost, test environments.  The second is through Amazon EC2 with OpenSolaris.  More details can be found at Dan's blog here.  And, if you need some help, let us know.

There are a couple of easy ways to test your Solaris application with MySQL ("the world's most popular opensource database").   Of course, you can always setup a Solaris or OpenSolaris environment and download it (70-80MB) and then install/configure locally.   However, if you don't want to go through the hassle of setting up the System, OS, & database yourself, Sun has made it easy to get your hands on pre-configured bits in a couple of other efficient ways.

Use the EZQual Virtual Lab.  Sun Partner's can get access to secure, no-cost, test environments (within Solaris containers/zones).  Here's the information directly from the program:

We've set up a secure, …

This week we had a very interesting problem at a customer: They complained, that their MySQL Cluster takes about 1 hour for a --initial start-up. After some tuning on the hardware and the config.ini they brought it down to around 40 minutes. But this is still unacceptable long...

This sounds a little strange to me. But let us have a look at their config.ini first. It looked more or less like the following (which is already tuned!):

#
# config.ini
#

[NDB_MGMD DEFAULT]
DataDir                      = /localdisk/cluster

[NDBD DEFAULT]
DataDir                      = /localdisk/cluster
NoOfReplicas                 =     2
LockPagesInMainMemory        =     1
DataMemory                   = 12000M
IndexMemory                  =  2000M

FragmentLogFileSize          =   256M
NoOfFragmentLogFiles         =    42

DiskCheckpointSpeedInRestart =   100M …

This week we had a very interesting problem at a customer: They complained, that their MySQL Cluster takes about 1 hour for a --initial start-up. After some tuning on the hardware and the config.ini they brought it down to around 40 minutes. But this is still unacceptable long...

This sounds a little strange to me. But let us have a look at their config.ini first. It looked more or less like the following (which is already tuned!):

 #
 # config.ini
 #
 
 [NDB_MGMD DEFAULT]
 DataDir                      = /localdisk/cluster
 
 [NDBD DEFAULT]
 DataDir                      = /localdisk/cluster
 NoOfReplicas                 =     2
 LockPagesInMainMemory        =     1
 DataMemory                   = 12000M
 IndexMemory                  =  2000M
 
 FragmentLogFileSize          =   256M
 NoOfFragmentLogFiles         =    42
 
 DiskCheckpointSpeedInRestart =   100M
 ODirect                      =     1
 
 BackupMaxWriteSize           =     1M …

As I mentioned earlier this week, I did a presentation on MySQL in OpenSolaris today.

The presentation (audio and slides) is now viewable online (and downloadable), and you can also get hold of the transcript of the questions: here (or download). The original presentation is here.

One minor difference from the presentation is that we …

Today, Martin "MC" Brown gave an overview of MySQL on openSolaris. Due to Yours Truly arriving late MC had to start a new Dimdim session (sorry for that!). So MC was the host and the presenter at the same time.

Interestingly (and annoyingly), this seemed to have a bad effect on sound quality. To most attendees, MC's voice sounded garbled. To me, he sounded like at least one octave too low. The sound recording, though, sounds all fine. I suspect that being the host of a Dimdim session has a bad effect on voice quality (the same thing has happened to me regularly, but I thought it was due to packet loss over my wifi or something). So, for the next MySQL University session on …