By Artur Bergman

What an exciting day, as services for hundreds of thousands of users and millions of readers disappeared from the internet. In a stunning but unsurprising event, a repeated power cycling caused by a blown power station disrupted the 365 Main datacenter, causing them to lose all power to two colocation rooms.

I jokingly refer to 365 Main as the "Web 2.0" datacenter; of course, there is nothing Web 2.0 about the datacenter itself. But it does host a remarkable number of such properties, including Craigslist, Technorati, and Red Envelope. Someone could make a lot of VCs cry by taking it out, or so the running joke goes. And ironically enough, this morning 365 Main (together with Red Envelope) put out a press release announcing 2 years of 100% uptime; one may also note that they have now removed the press release from their …

Looking for documentation for read_rnd_buffer_size you would find descriptions such as "The read_rnd_buffer_size is used after a sort, when reading rows in sorted order. If you use many queries with ORDER BY, upping this can improve performance" which is cool but it does not really tell you how exactly read_rnd_buffer_size works as well as which layer it corresponds to - SQL or storage engine.

Honestly as it had name very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only. But talking to Monty today I learned it is not the case.

read_rnd_buffer can be used for All storage engines not only by MyISAM. It is used for some sorts to optimally read rows after the sort. Here is how it works:

As sort is performed it can be performed having only row pointers together with …

Direct play the episode at: http://tinyurl.com/39576s

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcast@technocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group’s Carnival of the Vanities for the DBA community, published weekly on Fridays.
…

Could not resist the title after reading what Matt wrote. Sexy and exciting, indeed. Most of the crew here have their heads buried with the upcoming releases of Amanda Enterprise and Zmanda Recovery Manager (ZRM) for MySQL. We are continuing to enhance the Management console for Network backup. And with the next release of ZRM for MySQL, backup of MySQL database will never be the same. Dmitri already wrote about how easy it will be to manage MySQL backups from Iphone. Additionally we are fixing stuff in the Management console for ease of use. You can see, touch and feel them at LinuxWorld. …

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcasttechnocation.org">podcasttechnocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group?s Carnival of the Vanities for the DBA community, published weekly on Fridays.
…

Zmanda today announced that its Zmanda Recovery Manager (ZRM) for MySQL is now available with the Zmanda Management Console -- a set of powerful graphical tools designed to simplify and accelerate the complex process of MySQL database backup and recovery. ZRM with the Zmanda Management Console can dramatically reduce the workload of a MySQL database administrator (DBA) while providing enterprise-class, MySQL-specific backup and recovery.

Here is a perfect photo from James Duncan Davidson that illustrates the drive and ambition of Mårten Mickos, our fearless leader, battling with an unfortunate competitor at the Ubuntu Live party on Sunday. Look closely to see the gritty resolve in Mårten's face. Arms outstretched. Teeth clenched. Clearly a ferocious competitor at heart.

In other news, a bunch of us — Kaj, Monty, Brian, Zack, Kelly, and myself — are up here in Portland at OSCON. I gave my tutorial yesterday and it was jam-packed and really a lot of fun. Lots of great questions and laughs. I'll post the tutorial slides, workbook, and the new benchmarking tool …

A few of us from Solid are up in Portland at OSCON. We’ll be showing off a new prototype of our high availability (HA) option for solidDB for MySQL. The HA option allows solidDB for MySQL to act in a hot-standby configuration where there is a primary and secondary server. The data in the primary is automatically synchronously replicated to the secondary. In the case that the primary fails, our HA Manager automatically performs a failover and the secondary server becomes the new primary. The secondary is also always available for read-only requests.

We’ll also be talking about DorsalSource, a community-focused Web site whose goal is to provide developers with easy access to builds of MySQL and related products. Come by booth 820 on Wednesday or Thursday if you want to hear more, …

The Apache Friends team is proud again to announce a new version of XAMPP for Linux and Windows. The new version of XAMPP includes fresh, green and up-to-date versions of: PHP (5.2.3) and MySQL (5.0.45). In case of Linux we also upgraded phpMyAdmin to the recent 2.10.3.

To all beta testers: Thanks so much for all your hard work!

Get XAMPP 1.6.3 here

I've already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we're using this combination to build search against over 1 billion of forum posts totaling over 1.5TB of data handling hundreds of thousands of search queries per day.

The count of forum posts being large, is however not the largest we've got to deal in the project - number of links originating from forum posts is a bit larger number.

The task we had for links is to be able to search for links pointing to given web site as well. The challenge in this case is we do not only want to match links directed to "mysql.com" but links to "www.mysql.com" or "dev.mysql.com/download/" as well as they are all …