I’ve mentioned a number of times that the documentation repositories that we use to build the docs are freely available, and so they are, but how do you go about using them?

More and more people are getting interested in being able to work with the MySQL docs, judging by the queries we get, and internally we sometimes get specialized requests.

There are some limitations - although you can download and access the docs and generate your own versions in various formats, you are not allowed to distribute or supply that iinformation, it can only be employed for personal use. The reasons and disclaimer for that are available on the main page for each of the docs, such as the one on the 5.1 Manual.

Those issues aside, if you want to use and generate your own docs from the Subversion source tree then you’ll need the following:

• …

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month. The highlights from the talk are listed below that included the architecture of the site infrastructure to scale up to the traffic that is received. They are ranked amongst the Top 10 sites in terms of traffic.

The site runs on the LAMP stack and you know what that is:

• Linux
• Apache
• MySQL from Sun
• Perl/PHP/Python/Pwhatever :-)
  

WikiMedia runs the site on about 400 x86 servers. Of those, about 250 run the webservers and the remaining run MySQL database. Recently they acquired the …

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month. The highlights from the talk are listed below that included the architecture of the site infrastructure to scale up to the traffic that is received. They are ranked amongst the Top 10 sites in terms of traffic.

The site runs on the LAMP stack and you know what that is:

• Linux
• Apache
• MySQL from Sun
• Perl/PHP/Python/Pwhatever :-)
  

WikiMedia runs the site on about 400 x86 servers. Of those, about 250 run the webservers and the remaining run MySQL database. Recently they acquired the …

One of my current MySQL Web Team projects involves the creation of a "Tag" system for the web site. The idea is quite simple, we have lots of different types of content and we want to be able to link it all together by tags. For example, a customer maybe tagged with a specific region or industry and same goes true for a white paper, case study, web page, image and so on.

Hopefully I'll get a chance to describe this tag system in more detail, but in creating some administration pages for it I had to use a bit of SQL that few people talk about. I thought, hey why not throw it out there in case someone is learning SQL and finds it useful. My standard disclaimer: There are many ways to skin a cat as they say, so this is just one take and feel free to post some suggestions. Also this example is not optimized nor performance tuned so you might want to test this carefully on a set of tables …

I just started a new blog on photography, in German. It’s based in http://blogs.arno.fi/foto/ and so far only has just four entries — one on a photo session with fashion photographer Riccardo Desiderio, one on my ensuing autumn portraits of my wife along the Isar here in Munich, one on fun underwater photography ( …

A typical scenario is when a master has a few dozen slaves, and instead of dealing with all of them directly, uses four relay slaves, each one dealing with 6 slaves.
So, where's the trick? The trouble comes if you change replication format after you start the slave.
Example. One master (M), two relay slaves (R1, R2), with four slaves each …

I was booked for keynoting the second MySQL Users Conference in Japan on 30-31 October 2008. Going to Japan is always something I’m looking forward to.

However, I won’t have that pleasure this time. I got requested to keynote a Sun partner event instead, on Tue 28.10.2008 at Kievits Kroon, just outside Pretoria in South Africa.

For Japan, I will be replaced by nobody other than David Axmark. I’m happy he gets the opportunity to do this keynote, transitioning from his current role to a consultant next month. I hope this also gives the press an opportunity to understand David’s motivations a bit better!

This blog is about OurDelta, my visit to PGDay (and resulting quest to search for a good nntp reader for OSX) and my long term search for a good set of bluetooth stereo headsets. So lets start with OurDelta. The other day Arjen pokes me about OurDelta. The idea is to offer a place for distribution of all those tasty MySQL patches that float around the web (like from Mark, the Google guys etc.), that simply do not fit in MySQL's research schedule. Obviously this is awesome. There are packages for all sorts of distros (I am sure Windows will come one of these days too), which takes away some of the scaryness for people not comfortable with building things themselves. Moreover you know that there are other people that are using the same binaries and I guess one of the key things that OurDelta could build is a better way to communicate about success and failure when using some of these patches.

…

This is a short post that might save someone some valuable time, if Google decides to rank it high enough.

I've tried to install a newer version of the MySQL Connector .NET, namely 5.2.3 instead of the old 5.1.3 I had installed.
When trying to install 5.2.3, I got this error message:


Apparently the connector does not support upgrades from 5.1.x to 5.2.x. We should just remove the old one.

Here lies the problem: when I tried removing the old 5.1.3, I got a weird error of which I took no screenshot. It consisted of a blank error message showing a computer screen with a icon of a moon on it. Something resembling a "sleep mode" icon. Huh?

…

To save Solaris from a certain death ?

Reading Planet MySQL the last couple of hours I'm trying really hard to convince myselve the Solaris offensive there is not orchestrated.. but I can't.
It might ofcourse be the fresh MySQL users that Sun brought in on their platform that started out blogging but hey .. I`m paranoia right :)

Are they really trying to get at least a fraction of the MySQL community on Solaris. Do they really think they can ? Yes they lost a zillion of Solaris customers that were running a proprietary database to MySQL on Linux users ,, but why would they want to move back to a semi proprietary setup ?

According to Linuxjournal Alan Cox seems to think that ZFS is the only thing that is keeping Solaris alive. I don't think DTrace was a bigg mass tool that would convince the crowds to suddenly move to an other operating system.

So is Sun trying to Lock In a community ? …