One interesting solution to scalability and HA is to implement a circular master-master replication setup directly on the frontend servers. Obviously there is a reasonable limit as to how many servers you can have in such a ring, since the lag with which changes propagate will increase linearly as you add more servers to the ring. However according to an article by Giuseppe a 10 server ring is reasonable. Especially if you make your sessions sticky on a per frontend server basis, you actually have an elegant solution against the old issue of replication lag, where a user does not see changes he has made in subsequent requests, since his changes were written to a remote master server which have not propagated to the slave he is reading in the subsequent request. Latency should also improve as you do not have to open up a remote connection in the …

So, how do you get more free time? Simple, you quit your job. I did. Yes, seriously.
Well, I was employee#25 at MySQL AB (from August 2001), that's nearly 6 years - I reckon I've done my time ;-)

What's next? That's not really the point, I haven't taken another job elsewhere.
For starters I'm taking a few months off, spending more time with my wife and daughter, getting more exercise, and catching up on some other stuff.

Here's a three interesting interviews with Marten Mickos, Brian Aker and Gary Whizin, all from MySQL.  Marten is the CEO, Brian is Director of Architecture and Gary is Director of our Enterprise tools team. 

It's an interesting juxtaposition to see the range of topics across all three.  Marten talks about the business model, Brian's focused on storage engines and Gary is all about building the right team.  But the common thread across all three is how important open source is to what we're doing at every level. Here's a quick test... see if you can match the quotes below with the right person.  No matter how varied the …

MySQL Toolkit distribution 620 updates documentation and test suites, includes some major bug fixes and functionality changes, and adds one new tool to the toolkit. This article is mostly a changelog, with some added notes.

Many of the tools have matured and I just needed to make the documentation top-notch, but there's still a lot to be done on the crucial checksumming and syncing tools. Time is in short supply for me right now, though. In fact, I actually finished this release on June 22, but wasn't able to release it till just tonight!

Just a quick heads-up - I just commited a change to the Planet MySQL code that slightly modifies how the RSS feed is being created: now the author name is put in front of each posting's title, similar to how many other feed aggregators mark the different articles. I hope you find this change useful, let me know if you experience any problems or have any other suggestions for improvements. Thanks!

What does working with large data sets in mySQL teach you ? Of course you have to learn a lot about query optimization, art of building summary tables and tricks of executing queries exactly as you want. I already wrote about development and configuration side of the problem so I will not go to details again.

Two great things you’ve got to learn when working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data sets - it can take hell a lot of time to deal with. This may sound obvious if you have some large data set experience but it is not the case for many people - I constantly run into the customers assuming it will be quick to rearrange their database or even restore from backup.

You need …

Currently I need to move a bit of data around. I like to use Kettle for this type of work rather than writing custom scripts for a number of reasons (which I won't discuss here).

Anyway here is a quick tip I want to share with whomever it may concern. It is not rocket science, and many people may go "duh!" but I hope it will still be useful to others.

Quite often, you need a batch task, like truncating a set of tables, deleting data, dropping constraints etc. In kettle, you might model this like a job. In this case, each separate action can be modelled as a step of the job.

The following screenshot illustrates this approach:

So here, each step is just an SQL statement that performs exactly the task you want and the steps are connected in order to …

I just wanted to point everybody at a recent blog post by Konstantin. In the post he discusses a solution for dealing with cache invalidation issues of very large caches under heavy load. He points out that cache invalidation can severely bog down the system. The general solution he proposes is to simply deactivate the query cache entirely during invalidation. I think this is an important caveat to be aware of and actually he is asking for feedback if this "solution" is acceptable. I think its awesome that MySQL engineers are giving us the opportunity to provide feedback on such changes. Maybe there should be a dedicated "pipeline" where such requests could be found?

We next go "In the Trenches" with Kevin Henrikson of Zimbra. Zimbra wasn't the first to build a slick email system with a strong AJAX feel, but it has clearly taken the lead among its peers. The backbone of that position is its engineering team, with Kevin at the heart of the organization.

As it turns out, regardless of all the "sex appeal" that Zimbra has in the market (and it has plenty), Kevin's comments reveal that it's community feedback that makes the company tick. Community feedback and an active engineering team that solicits and acts on that feedback, often in real-time. This is the heart of a successful open source business, and Kevin shows us how it's done.

Name, company, title, and what you actually do

Kevin Henrikson, director of Engineering, Zimbra. I currently manage our client engineering team which develops the Zimbra Advanced Client (AJAX based) and Standard Client (JSP/HTML based), the latter …

It has become obvious that there are just too many people to meet up with, and too many locations to travel to, with so little time to do them all. So setting up temporary office, seems to make the most sense! Those that have emailed me, have also received the following in their email.

Where?
Lobby Lounge Restaurant/Cafe
Grand Copthorne Waterfront Hotel
392, Havelock Rd
Singapore

When?
Thursday, July 5 2.30pm - 6pm
Friday, July 6 8am - 11am

What to do if I’m not there?
Just drop me an SMS or a quick call to +6-012-204-3201.

This is in addition to the meetup we’re having. Depending on how my meetings on Friday go, there might be yet another afternoon session available.

Technorati Tags: …