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 …

Many of you who use MySQL replication have requested that we do more to assist you in monitoring and troubleshooting issues with various replicaton topologies. Right now, we’re in the process of designing replication monitoring enhancements for our current Monitoring and Advisory Service so I thought I’d request your input on what you’d like to see.

The most common questions I hear that come up with respect to replication monitoring are these:

- Are there any global replication issues in my monitored replication topologies?
- Do I have any down master servers?
- Do I have any down slave servers?
- Are my SQL and I/O slave threads running on my slaves?
- Is the replication latency between any master and slave too high?
- What are the top ?N? worst performing (highest latency) slaves?
- Have any slaves experienced a replication-specific error?
- What are the last ?N? errors in a …

When I wrote my first article on algorithms to compare and synchronize data between MySQL tables, Webyog's Rohit Nadhani left a comment on the article mentioning the SQLyog Job Agent, which has a similar function. Although I have been developing MySQL Table Sync essentially in isolation, I have been meaning to give SQLyog Job Agent a try. I recently did so, and then followed that up with an email conversation with Rohit. This article is about my experience using the SQLyog Job Agent from the command line, some thoughts on the algorithm as best I can deduce it, and benchmark results against MySQL Table Sync.