The latest from the MySQL community

In a few weeks I'm headed out to my 4th MySQL Conference. Typically I get all my travel/lodging set up way in advance but this year is different and I just got the last piece into place today. Yikes!

I haven't had much time this year for pre-conference MySQL posts, which tend to get more frequent leading up to the conference. I guess there is still two full weeks to get back into groove before I head out.

I'm looking forward to the conference for a few reasons (in no particular order):

• 
  
• Presentations: I'm excited for a number of presentations on the schedule. As I look back over the years I think the thing I've enjoyed the most in presentations is hearing how other folks are using MySQL to solve their data storage/access problems. My first conference in (Orlando, 2004) very heavily featured the work …

We've been working on automatic master promotion for MySQL using lbpool and I'm reminded of a few ideas we had after reading about MMM.

The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available.

Few months ago we were asked to implement such solution for one of the customers and they kindly agreed to let us release things under GPL2 License, and we gave them reduced rate for being Open Source friendly.

We actually considered a dual master approach but abandoned because it was non ideal. …

We’ve been working on automatic master promotion for MySQL using lbpool and I’m reminded of a few ideas we had after reading about MMM.

The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available.

Few months ago we were asked to implement such solution for one of the customers and they kindly agreed to let us release things under GPL2 License, and we gave them reduced rate for being Open Source friendly.

We actually considered a dual master approach but abandoned because it was non …

I've just released three updates to tools in MySQL Toolkit. The updated programs are MySQL Query Profiler (major new features and helper script), MySQL Table Sync (bug fixes, documentation, features), and MySQL Table Checksum (minor sanity check enhancement).

So, I’s been a long time since I wrote my last post here. Lots of work and almost no new interesting technologies in my work caused such delay. But today I’m proud to announce release of really interesting project: MySQL Master-Master replication manager - set of flexible scripts for management different MySQL deployment schemes with master-master replication involved.

More information about this software could be found in detailed announce in Peter Zaitsev blog (actually this software was created by me for his company’s client) or at project page. All your questions and suggestions welcomed in …

UDF_LUA

You are tired of writing your UDFs for MySQL in C or never wanted to write them in C at all ? How about writing them in lua ?

LUA is - easy to learn - easy to embed - easy to use

and not to forget lua has extensions for everything: - LuaSocket - how about some HTTP requests ? - LuaSQL - connecting back to the MySQL Server ? - ...

UDF_Lua is registered in the MySQL Forge.

functions

As example we want to read the real startup time of the errorlog.

-- we are run with the permissions of the mysqld
-- …

The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available.

Few months ago we were asked to implement such solution for one of the customers and they kindly agreed to let us release things under GPL2 License, and we gave them reduced rate for being Open Source friendly.

So what does this tool do and how it works ?

Currently it is implemented based on Linux IP management tools and LVM for snapshot creation but we hope support for other operation systems added in the future.

It can manage master-master pair as well as other configurations such as master-master and bunch of slaves.

Typically you would define "roles" for example READER and WRITER roles for most simply case and …

Jonathan Schwartz said something very interesting on his blog today. (I wish he blogged more, and with fewer happy Sun employee faces in his blogs, but this one was good.) He was talking about Sun's licensing of its Neptune ASIC to Marvell, and made this comment:

For years we were called proprietary - a moniker that did more damage to Sun than any market downturn. And frankly, we've spent years recovering. But at this point, my hope is we've completely turned that slur on its head, that we've come to define open - more open than any other vendor, more open than open itself. From silicon to systems, software to storage and services.I get a lot of grief for being an open source bigot. Few that make that claim seem to understand that I spent my years in the "hybrid" wilderness. It didn't work. That's why I've increasingly opted for a pureplay open source view. …

I'm in the middle of finalizing Alfresco's (for the Americas) sales compensation plan. It has been one of the most difficult things I've ever done. You'd think it was just a matter of setting commission percentages and accelerators, but it's harder than that. It's very difficult to fine-tune incentives so that nomads work for the group.

One of the aspects of creating the plan was what to do with renewals. Some of Alfresco's peers comp renewals - others don't. Some give full commission and booking credit in the first year, and then 50% commission credit (and no booking credit) thereafter.

I've opted to fully comp and credit renewals. Why? Because it aligns interests between the salesperson and the customer. (One large open source company has apparently adopted this model recently, having started with a "no reward for renewals model," so companies of any size can adapt to it.) …

Not sure if you saw this from yesterday's Champions League match, but the Roma riot squad went wild on the visiting Manchester United fans. (You can see it in action here.) Apparently (and I'm sure this is true), the ManU fans weren't pleased when they went down 1-0 before half, and started throwing objects at the home Roma supporters. (Note to ManU fans: 4,000 against 50,000...you don't want those odds.)

Manchester United is denouncing the "indiscriminate beatings." Roma, no doubt, believes they were simply containing the British hooligans. For those beaten, it really doesn't matter. They're bleeding.

Beauty is in the eye of the beholder. Thuggery is in the eye of the club-holder.

I'm constantly surprised by how many in the proprietary space believe that they're being beat up by open source. Billion-dollar companies whining about open source …