Dedicated to Fernando Pedone and other modest and courageous researchers whose work made this possible.

Sysbench Synchrones Transatlantiques

If the curious reader decides to google for "synchronous replication" with the hope to educate himself on the matter, he will be presented with a whole lot of established and not so much expert advice and explanation, most of which turns out to be, well, to put it mildly, wild superstitions rooted in the beginnings of computer era. Basically the consensus among those "experts" would be that "synchronous replication is so problematic that you're better off with asynchronous". Only Microsoft (!!!) honestly admits that, asynchronous replication kinda "sucks and must die". Well, it may be too strong of a statement, but a refreshing point nevertheless.

One of the most widely cultivated myths about synchronous …

One of the best things that I've enjoyed when I've bought an iPhone is the colossal amount of applications available on the App Store. From there I can download as many apps as I like: dictionaries, yellow pages, navigation software, games or anything else.

I was surprised to know that a former colleague decided to apply the same successful approach to business applications. I can clearly see the need for a similar portal, since anytime I look for a potential solution to suite my customers needs I have to search in many places.

Part of Sun Startup Essentials and fully running on MySQL, GetApp.Com is the site that you should take a look at if you are starting a project or searching for a specific solution.
Featuring …

Normally I like to use the OS’s package manager to manage the software on my system. This ensures that things are done consistently. When managing MySQL I’d also like to manage all my instances the same way. That makes life easier for me but also for my fellow DBAs and sysadmin colleagues.

I use CentOS and the rpm packages it provides and these work quite well. However, the MySQL rpms do not allow me to manage single and multiple instances alike and while mysqld runs as the mysql user the instance management needs to be done as root (stopping, starting instances, or default access). If you want to run multiple instances you can also use mysqld_multi, but that’s not the default setup.

So this is not ideal. While this may not be much of an issue if you manage a single server, if you manage tens or …

This post is the second part of my earlier post on How to build a fast, good scaling user notification system where we discussed the problem areas of the said system. This post will be mostly about a strategy on the infrastructure to store all those notifications and retrieve them as fast as possible. The most common approach to store data like user notifications would be to create a table

I've found a great comic regarding the Oracle-Sun-MySQL deal. By the way, where did you get my e-mail address from to spam me?

There's a campaign started by Monty Widenius to save MySQL from the evil clutches of Oracle. You can read about it here.

http://helpmysql.org

Software-as-a-Service (Saas) is one of the main growth areas in modern database applications.  This topic has become a correspondingly important focus for Tungsten, not least of all because new SaaS applications make heavy use of open source databases like MySQL and PostgreSQL that Tungsten supports.

This blog article introduces a series of essays on database architectures for SaaS and how we are adapting Tungsten to enable them more easily.  I plan to focus especially on problems of replication and clustering relevant to SaaS—what are the problems, what are the common design patterns to solve them, and how to deploy and operate the solutions. I will also discuss how to make replication and clustering work better for these cases—either using Tungsten features that already exist or features we are designing.

I hope everything you read will …

Do you want to stay updated with the social news and technical discussions of Kontrollbase and Kontrollsoft’s MySQL software applications? Well, you can now by adding us to your friend list. Our Facebook page can be found here: http://www.facebook.com/pages/Kontrollsoft/262697451356

One of the most widely discussed topics to go around the tech industry last year was the Oracle acquisition of Sun and what this meant for the MySQL database. This topic held up the merger with the US DOJ and currently has it stalled in the EU commission.

One of the primary forces behind these hold ups is a series of FUD articles written by Monty Widenius, the most recent just a few days ago. Monty has a huge following so whenever he writes up one of these articles it gets huge circulation and riles up the Slashdot and LAMP crowds.

I think that the open source community should be very skeptical about anything written by Monty on this topic, and should start looking at the big picture of what this merger means for themselves and the various players involved.

I don’t know why I haven’t been seeing many serious rebuttals to …

It’s about time to add a new major feature to Kontrollbase. I’ve had some great feedback from the user community regarding features and options for improvement. Here’s your chance to get a vote in on the next addition. Vote now!