The latest from the MySQL community

I have recently added some features to Maatkit’s mk-table-checksum tool that can make it easy to checksum the relevant parts of your data more frequently (i.e. continually, but not continuously). This in turn makes it possible for you to find out much sooner if a replica becomes different from its master, and then you can take action before the differences affect more of your data.

Zembly team has deployed a new application on Zembly called myPicks U.S. Election 2008.

Use this to voice your opinion on the campaign issues being debated in the U.S. Presidential Election - wherever you are in the world.

You can launch the game from: http://zembly.com/mypicksus/

While the frontend is running on Network.Com, the backend including the MySQL server is running on EC2 and data resides on S3

The game is available as a Facebook and MySpace App.

Some cool mashup. They use Dapper to convert some Election related URLs into a API and feed it into the Zembly code/widgets.

Good CloudComputing stuff, check it out!

I’m just back home from Brazil, where I went last Sunday in order to launch MySQL’s presence in Brazil and meet with MySQL users, developers, Sun customers, the press as well as with numerou Sun colleagues. “Is this your first time in Brazil?” was a frequent question (as one could expect), and I was happy to respond that it wasn’t. In fact, I have particularly fond memories of my first visit to Brazil in 2001, as that was the trip when I decided to join MySQL AB.

They say Rio de Janeiro is one of the most beautiful cities on the planet. Whoever “they” are, they’re right. The cone in the middle is Pão de Açúcar (Sugarloaf Mountain, der Zuckerhut, Sockertoppen).

As a European, I again noted …

A project I have been working on for a while just hit a significant milestone.

Pluggable Query Logging has just been merged into the main Drizzle development.

The plan is that quickly this will replace the existing query log and slow query log that Drizzle inherited from MySQL.

The legacy logging system is more than a bit byzantine, is full of a lot of complexity to try to get incremental performance with complicated buffering, and yet has several completely unnecessary locks.

In the new plugin logging system, there is a callback right after a query is parsed but before it is executed, and another one right after it is done executing. A plugin registers itself, and will be called at those two points, and is passed the THD, from which it can learn everything about the query that will be / has been executed, and then do whatever it …

Bom dia!

On Monday and Tuesday this week, a team of MySQLers (”Sun Dolphins”) and Sunnies (”Sun Classics”) launched the commercial presence of MySQL in Brazil.

This means we have now have ambitions well beyond the growth of the MySQL user base in Brazil, which already is in the top five countries of the world when it comes to downloads. In other words,

• we have a senior sales person assigned, with a sales goal for Brazil
• we are recruiting sales engineers for Brazil
• we are recruiting Support Engineers, who will deliver MySQL support in Portuguese
• we are recruiting Consultants, who will deliver MySQL professional services in Portuguese

During the Sun Tech Days in São Paulo, we …

I've taken some time out of writing my book to get some coding down, and I'm pleased to announce the release of the Memcached Functions for MySQL, version 0.6. This release includes:

* Complete rewrite of error handling
* Build configuration fixes/improvements from Trond Nordby (Thanks!)
* Fixed memc_server_count
* More tests

You can find the release information-- repository and source at:

http://tangent.org/586/Memcached_Functions_for_MySQL.html

As well as

http://patg.net/downloads/memcached_functions_mysql-0.6.tar.gz

Have fun! More to come...

I spoke at the MySQL Conference and Expo this year about the architecture we have here at dealnews.com.  After my talk, Jimmy Guerrero of Sun/MySQL invited me to give a webinar on how dealnews uses memcached.  That is taking place next week, Thursday, October 09, 2008.  It is a free webinar.  We have used memcached in a variety of ways as we have grown. So, I will be talking about how dealnews used memcached in the past and present.

For more information, visit the MySQL web site.

I've been doing an informal poll recently of open-source companies, asking them how the tight economy is affecting their sales. In every single case, these companies are recording record sales.

It's perhaps not hard to find an answer: open-source solutions tend to cost a lot less than their proprietary counterparts, and provide equal or better functionality.

Open source is not merely about lower software price tags, however. As CIO.com highlights with the Oregon Department of Human Services' attempt to find a new CRM system, the cost of product discovery and implementation also favor open source, in this case SugarCRM: …

Welcome to the 117th edition of Log Buffer, the weekly review of database blogs.

For those of you who don’t know me, my name is Nicklas Westerlund, and I’m a MySQL DBA with The Pythian Group. This is my first time writing Log Buffer, and I hope I’ll do it right.

Let’s start off with SQL Server, where Simon Sabin asks if you know what concurrency is and how to improve it. And on SatisticsIO, Jason Massie focuses on the …

You can now download cmon 1.2.2 at www.severalnines.com/cmon
Thank you everyone for your feedback.
Bugs fixed in cmon 1.2.2:

• https://bugs.launchpad.net/cmon/+bug/281184 (wrongly used index in ops_node.php)
• This means that CMON is actually working now :) !
  

Bugs fixed in cmon 1.2.1:

• Fixed a number of issues with building cmon on Solaris.
  
• Updated the compile instructions adding a note how to build it on Solaris.
  

Bugs fixed in cmon 1.2:

• --logfile - specifying a custom logfile was not working earlier and cmon exitted. Now this is fixed!

Features:

• new configure option (--with-wwwroot): ./configure …