The latest from the MySQL community

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 …

As part of an internal programme at Sun, I am a “SEED mentor” for another Sun employee (not a former employee of MySQL, but what we Sun Dolphins call Sun Classics). He is called Alok and lives in Bangalore, and sadly, our schedules crossed so that I couldn’t meet him when I was at our Bangalore offices in July. So I am mentoring someone I’ve met only over phone — but we’re getting along just fine.

Two of the topics we’ve discussed recently are blogging and books. So after hanging up after our 9 CET 12:30 Indian time mentoring session, I got the idea to combine the two: write a blog entry about the books I recommended Alok.

One thing Alok is contemplating at the moment is the degree to which he should spend time on developing his business skills vs his engineering skills. That’s a familiar topic for many of us in …

CIO published an article highlighting 5 cheap (or free) software that can be afforded during financial crisis. Their recommendations are:

• Open Office ($0) instead of Microsoft Office ($110 for basic version)
• Mozilla Thunderbird ($0) instead of Microsoft Outlook (lots of security issues)
• GnuCash ($0) instead of Quicken ($30 for starter edition)
• Alfresco ($0) instead of Sharepoint ($5K for five licenses)
• …

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!