Have you ever been annoyed about the input and output binding that is part of Prepared Statements? Prepared Statements have their room in PHP and MySQL[i] for some good reasons. Though, I recall that I didn’t like the output binding when I tried them for the first time. I wanted the good old mysqli_fetch_assoc() to be available. Last year in November someone, I think it was Lukas (but don’t blame me, if I’m wrong), suggested to implement mysqli_stmt_get_results() with mysqlnd.

By help of the new function, you can create a …

Have you ever been annoyed about the input and output binding that is part of Prepared Statements? Prepared Statements have their room in PHP and MySQL[i] for some good reasons. Though, I recall that I didn’t like the output binding when I tried them for the first time. I wanted the good old mysqli_fetch_assoc() to be available. Last year in November someone, I think it was Lukas (but don’t blame me, if I’m wrong), suggested to implement mysqli_stmt_get_results() with mysqlnd.

By help of the new function, you can create a …

original post
second post

http://consoleninja.net/code/dpm/rel/dpm-r1.tar.gz - release 1 of DPM, tarballed sources. Also available via cloning git and tracking the 'release-1' tag

git clone http://consoleninja.net/code/dpm/dpm.git - to get the latest code, always
http://consoleninja.net/code/dpm/dpm-export.tar.gz - a tarball of the latest code, for those unwilling to git it.

I'd still call this a preview release, but it's too juicy to not release in some form. Early and often, right?

This is the first …

original post
second post

http://consoleninja.net/code/dpm/rel/dpm-r1.tar.gz - release 1 of DPM, tarballed sources. Also available via cloning git and tracking the 'release-1' tag

git clone http://consoleninja.net/code/dpm/dpm.git - to get the latest code, always
http://consoleninja.net/code/dpm/dpm-export.tar.gz - a tarball of the latest code, for those unwilling to git it.

I'd still call this a preview release, but it's too juicy to not release in some form. Early and often, right?

This is the first …

Sysadmins love top. Now it's time for mod_top. From the homepage:

mod_top is a production monitoring tool for LAMP applications with user interfaces modeled after the popular unix top. mod_top plans to support PHP, Perl, Ruby, Python, mySQL, Postgres, Apache1+2 on Linux.

mod_top is a PHP extension that is able to monitor PHP 4.4.x and PHP 5.x based applications. Sounds cool. Unfortunately it seems there's no source available, but the FAQ says that mod_top is free.

I realized recently from observation that some smaller websites which use MySQL do not have a working backup and recovery strategy. Some may have a backup approach but it will not work in a recovery. As part of a number of discussions on Backup & Recovery here is part 1.

Using straight ‘cp’ for Backup

Using ‘cp’ to simply copy your running database *DOES NOT WORK*. You may be lucky, but in a world of guarantees, this is no guarantee that your can recovery your system. Why is this so.

• The data is not consistent during the backup. If it takes say 5 minutes to copy your files, they are copied probably in alphabetical order, what if data is written during the backup to a table starting with ‘A’ and a table starting with ‘Z’, the A file has already been copied.
• When using MyISAM, Indexes are not flushed to disk unlike Table data. This means that while MyISAM has the facility of recover and …

While MySQL has successfully had a worldwide conference in the US for several years, we've also expanded our efforts internationally.  This fall we're now doing 3 one day conferences in Europe with sessions in London, Munich and Paris in October.  And we also have our first ever MySQL Conference in Japan in September.  Last year we also introduced our first ever MySQL Camp event, and …

Finally got around to reading Brad's article on Social Networks.

http://bradfitz.com/social-graph-problem/

I am not going to comment too much on his ideas. I thought he presented them in a very straight forward manner and I can notfind much of a reason to disagree with what he has said. I have concerns about how to control the information, but part of me just thinks that we shouldn't be too concerned with the privacy issue. Sign up and use it if you want to, otherwise reenter your information into each system you want to use.

Ease of use wins over privacy for a lot of people.

When I implemented Zoo for Slashdot back in 2003 (or was it 2002?) I made a point of making all of the social graph public:
http://slashdot.org/~krow/zoo/

You can …

il corra walks you through building mysql-proxy for ubuntu.

il corra » mysql-proxy on ubuntu 7.04 feisty

First of all, there is not a packetized mysql-proxy for Ubuntu, so the only way to install it is to build it from the source

Which is great. But I'd like to take this opportunity to tell people that I've actually been working on packages for debian/ubuntu. They're almost ready to be released into the wild (I'm waiting on an almost non-related event) If you'd like to play with the packaging stuff before then, check out http://launchpad.net/mysql-proxy

I'll be sure to let everyone know when the packages themselves are in an APT repository.

MySQL data service running on a clustered-server model provide orderly startup, shutdown, fault monitoring, and high availability(failover) mechanism compared to the single server model. It can be free donwloaded, and Sun also released Open HA cluster, derived from the Sun Cluster 3.2 agents including HA MySQL data service. The open HA cluster also provide build tools necessary to develop new features, build and use the code. In addition, Sun cluster 3.2 Data service for MySQL has the advantages including:

• It is easy to install and configure with straightforward GUI and command line interfaces.

• Expanded support for Solaris Containers(Solaris zones)

• Expanded support for SMF

• ZFS is fully supported as a local highly available …