While using the latest MySQL 5.1.20 yesterday I came across another situation that was not expected as with previous editions of MySQL. The background is experimenting with DRBD. When I configured MySQL to startup with a /etc/my.cnf file with data on a DRBD partition I got a failed startup error message with mysqld_safe.

$ bin/mysqld_safe &
[1] 12615
070720 10:10:42 mysqld_safe Starting mysqld daemon with databases from /drbd/data
070720 10:10:42 mysqld_safe mysqld from pid file /drbd/data/newyork.localdomain.pid ended

Ok. Well this happens so I went to the data directory to look for `hostname`.err.

$ cd /drbd/data
$ ls -l

What the! There is no error log. Then the discussion started about this. Apparently mysqld_safe now uses syslog (e.g. /var/log/messages) for logging messages. Ok, but where is the line between mysqld_safe and mysqld. …

The next couple days are gonna be a busy time here @ Zimbra.

July 22 - Ubuntu Live :: Collaboration in an Open World
"This session will explore the current problems with enterprise email, how the community can help fix it, how to leverage open source in mobilizing corporate email, and what's in store for the future of email."

http://www.ubuntulive.com/cs/ubuntu/view/e_sess/13492
Speaker: J.J. Zhuang, Server Architect


July 26 - The AJAX Experience :: Taking Large Browser-based Applications Offline
"How Zimbra managed to integrate several open source projects, including Tomcat, Jetty, Jakarta, MySQL and Firefox, to create an architecture for offline Ajax applications. "

…

No matter what system you run there are areas that just don't make any sense.  I love Visual Studio and will argue with anyone that it's the best way to develop traditional platform applications.  That being said, it's help system is quite ridiculous.

You would think that a company that is so focused on developer productivity would make it trivial to integrate third-party documentation.  The pages of the documentation are all just HTML files.  Each documentation package might contain some indexes but on the whole it's just HTML.  Here's an idea.  Just make the help format a zip archive and inside this zip you layout the HTML in whatever tree structure you like.  Include whatever scripts, CSS, or binary content you like.  Any top level pages that should not appear in the TOC can be listed in some .exclude file.  There can be a file that lists the name to file indexes.  All of this could then …

The 54th edition of Log Buffer, the weekly review of database blogs, has been published by Paul Gallagher on Tardate 10.2. Jeremy Schneider and the Ardent Performance Computing Blog take over next week. After that, the schedule is open, so please get in touch if you’d like to edit and publish a Log Buffer [...]

I have officially moved my blog from www.bytefx.com/blog to www.reggieburnett.com.  Please update your links, bookmarks, readers, etc.  I have attempted to preserve as many of the old dasBlog URLs as I can but I know of at least 3 URL types that are not working currently.  I'll try to get those working over the weekend.  If you find any old URL that is not working, please drop me a line so I can fix it.

Thanks!

I had been thinking of moving my blog for some time now.  I started my blog back when I was self-employed and operating under the corporate name ByteFX.  I have been employed by MySQL now for more than 3 years and been blogging about all things .NET and MySQL at my ByteFX site.  While technically there is nothing wrong with this, it always felt wrong to me to blog about my efforts at my current employment under a different corporate website.  The domain name 'reggieburnett.com' was available so I jumped.

GoDaddy.com offers some very cheap Windows hosting so I decided to host my new site and blog there.  They offer a very professional setup and the only real hang up was that my site had to be medium trust compatible.  dasBlog, my current blog software of choice, is not.  So I made the move to Subtext, a BSD-licensed fork of .Text.  It's simple, SQL-based (soon to support MySQL), includes a photo …

This function is useful for control of master/slave synchronization. It blocks until the slave has read and applied all updates up to the specified position in the master log. The return value is the number of log events the slave had to wait for to advance to the specified position. The function returns NULL if the slave SQL thread is not started, the slave's master information is not initialized, the arguments are incorrect, or an error occurs. It returns -1 if the timeout has been exceeded. If the slave SQL thread stops while MASTER_POS_WAIT() is waiting, the function returns NULL. If the slave is past the specified position, the function returns immediately.

If a timeout value is specified, MASTER_POS_WAIT() stops waiting when timeout seconds have elapsed. timeout must be greater than 0; a zero or negative timeout means no timeout.



This is great for applications which …

I've just released changes to two of the tools in MySQL Toolkit. MySQL Table Checksum got some convenient functionality to help you recursively check slaves for bad replicated checksum chunks. MySQL Archiver got statistics-gathering functionality to help you optimize your archiving and purging jobs, plus a few important bug fixes.

MySQL recently released 5.1.20 beta. I just ran into another gotcha, which prompted me to post this draft I’ve had for a while.

rbradford@newyork:/opt/mysql51$ scripts/mysql_install_db
Installing MySQL system tables...
070709 23:24:08 [Note] Plugin 'InnoDB' disabled by command line option
OK
Filling help tables...
070709 23:24:08 [Note] Plugin 'InnoDB' disabled by command line option
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h newyork password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd …

I’m at some internal MySQL training today at our US HQ. In a room of 11 people we are all using our laptops for access to additional machines. The beauty of this is we have Linux (Ubuntu 5.10, 6.10, 7.04, Red Hat Fedora), Mac OS/X and Windows Operating Systems on various staff machines. It’s great to realize we are not locked into just one infrastructure, and we have the ability to all do our work effectively and MySQL works just as well across these technologies. I can’t however SSH from my iPhone yet, unlike my previous Nokia E62 PDA.