In the course of writing my book, I am in the midst of writing about memcached and how it has been used to alleviate the load on MySQL. I'd like to have a section in this chapter called 'Memcached Use Cases' and I was thinking of posting to my blog to see if anyone has some use-cases of how memcached helped their organization or application. Please, if anyone has any stories to tell of how they had a high load on MySQL and in the course of switching to using memcached for tables they were formerly hitting often they solved this problem-- how memcached helped reduce that load, even to what degree it reduced it. I can give attribution to these stories as well.

Thanks for any stories in advance!

krow just asked me to add another plugin type to Drizzle, for pluggable replication, and so I have, and it's pushing up to Launchpad now to merge with the mainline.

The plugin type is actually called "replicator", to avoid conflicts with the existing source files called "replication.*"

The existing replication system in MySQL 5 is... well. Like the old joke about if you like laws or sausages, you probably shouldn't watch them get made, if you need to think that MySQL 5 replication is rock solid, you probably shouldn't read the source code. Heck, a serious bug was discovered in it at OpenSQLCamp a few weekends ago, just by projecting a random page of code on the wall and having a dozen pairs of eyes read it.

So MySQL 5.1 is declared GA, contains enough bugs to make Monty rail against it publically, doesn't (as far as I've been able to gather) have a stable cross-release pluggable storage engine ABI (despite that being a major release feature -- meaning you have to have new plugin releases for each MySQL server release before upgrading anything), and continues the madness of less frequent community releases and less stable enterprise releases …

We have now published presentations from OpenSQLCamp at Percona Presentation pages

Percona MySQL Patches is a great presentation to see Percona Patches for MySQL in action, showing how you can use them to get more understanding of your server load and improve server performance, as well as how they can improve performance all together.

Sphinx full-text search engine is presentation about Sphinx Search Engine …

I don’t like to write blog entries about MySQL.

I doubt that planetmysql.org includes me in our feed anymore, and generally that works out fine for all concerned.  My rantings while quitting smoking were probably at least “a minor contributing factor” in the filtering we now employ.

It’s not for lack of things to write (trust me), so, why the reticence?

I suppose mostly it’s that I don’t like to read blog entries about MySQL.  Every time I dive into Ye Olde Blogosphere I see us revising the 80/20 rule into more of a 90/10 rule, or maybe 95/5, or 97/3.  Or: 3% of everything is Scottish; the remaining 97% is crap.

But the real reason is drama and my fondness for avoiding same.

Being online lost its newness and novelty for me some 26 years ago, so perhaps that causes me to be less inclined to take my 15 nanoseconds of soapboxery seriously.  I am certainly less inclined to …

Ignacio "Iggy" Galarza, Jr. is a developer at the MySQL Connectors Team. Lenz talked with him about working for a distributed company, a team with the interesting acronym "WTF" and other nerdy things.

Real noisy fucker. So loud, that if it’s in the garage but the back door is open, I still hear it.

Being used for drizzle dev on Solaris… although a switch to OpenSolaris or Linux is likely imminent. Straight Solaris 10 is just too annoying.

A Microsoft veteran believes that open source is the future of software. Why is this news? READ MORE

Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.

This release includes some new functionality as well as numerous bug fixes and improvements, most notably:

• Added support for using rsnap as a backup backend (Matt Lohier)
• The documentation is now maintained in POD style instead of asciidoc (Matthew Boehm)
• Support using non-GNU tar and …

Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.

This release includes some new functionality as well as numerous bug fixes and improvements, most notably:

• Added support for using rsnap as a backup backend (Matt Lohier)
• The documentation is now maintained in POD style instead of asciidoc (Matthew Boehm)
• Support using non-GNU tar and …