After I posted my idea about a pure PHP mysqlnd driver, I received an email from Ulf Wendel from the MySQL AB team who works on the mysqlnd driver. He told me I could post his comments since he doesn't have a Blogger account. I'll include his comments below in blockquotes and then I'll comment below that.Ulf Wendel writes:What is "native"?PHP and the Borg[1] seem to be relatives. Whenever a

MySQLers share many hobbies. One of them is running. After the holiday season, I allowed myself to do some statistics on last year’s running, and add some personal reflections, only marginally related to work and MySQL.

Running is often a social event at MySQL, where a sizable portion of my 108 runs last year were with other MySQLers: Six times with Zack Urlocker (EVP Products), six times with Patrik Backman (Dir SW Eng), twice each with Larry Stefonic (SVP APAC) and Clint Smith (Legal Counsel), and once each with Kristofer Pettersson (SW Eng), Saskia Schweitzer (Training coordinator), Mikael Ronstr?m (Principal Engineer/Senior MySQL Architect), and Nicolas Pujol (Sr Director, Alliances & Channels). Running can even be social time spent with non-runners (not just on the phone), as three of my runs were with MySQLers on …

This release contains bug fixes and new features. Click through to the full article for the details. I'll also write more about the changes in a separate article.

My posts lately have been mostly progress reports and release notices. That's because we're in the home stretch on the book, and I don't have much spare time. However, a lot has also been changing with Maatkit, and I wanted to take some time to write about it properly.

A

Maatkit contains essential command-line utilities for MySQL, such as a table checksum tool and query profiler. It provides missing features such as checking replicas for data consistency, with emphasis on quality and scriptability. This release contains bug fixes and new features. Changelog for mk-archiver: 2008-01-05: version 1.0.6 * Made suffixes for time options optional (bug #1858696). Changelog for mk-deadlock-logger: 2008-01-05: version 1.0.8 * Made suffixes for time options optional (bug #1858696).

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

Smaller, 320x240, 293M WMV file for download

References mentioned in the video:
Brian Aker's DBIx::Password

Giuseppe Maxia's article about federated tables -- I think that's the right one, feel free to comment if it's not.

read more

Dear LazyWeb,

No matter how I modify this following code it does not work with Solaris. Solaris always returns "non-recoverable name resolution failure":

     int error;
     char port_buf[NI_MAXSERV];
     size_socket addrLen = sizeof(vio->remote);
     if (getpeername(vio->sd, (struct sockaddr *) (&vio->remote),
                     &addrLen) != 0)
     {
       DBUG_PRINT("exit", ("getpeername gave error: %d", socket_errno));
       DBUG_RETURN(1);
     }

     if ((error= getnameinfo((struct sockaddr *)(&vio->remote),
                             sizeof(struct sockaddr_storage),
                             buf, buflen,
                             port_buf, NI_MAXSERV, NI_NUMERICHOST|NI_NUMERICSERV)))
     {
       WATCHPOINT_STRING(gai_strerror(error));
       DBUG_PRINT("exit", ("getnameinfo gave error: %s",
                           gai_strerror(error)));
       DBUG_RETURN(1);
     }

…

Peter notes that you indeed can find pretty recent Enterprise level MySQL rebuilds over at the CentOSPlus repository.

Good things come to those who wait :)

This week, Daniel Krook brings us the 78th edition of Log Buffer, the weekly review of database blogs. Up next week is Hasan Tonguç Yilmaz for his second LB. You too can do one — send a note to me, the Log Buffer coordinator to get started. It’s fun! Here is Daniel Krook’s Log [...]