Archive for February, 2009

MySQL review in FriendFeed

February 27, 2009

As you know, social media content aggregator FriendFeed pulls together content from over 40 Websites like YouTube, Flickr, Twitter and more. Needless to say, the service manages a large quantity of information. Sun MySQL
Today Bret Taylor — the co-founder of FriendFeed — has published a review of MySQL on his company blog stating, "We have optimized our primary indexes quite a bit in this new [MySQL] system, and we are quite pleased with the results."

The review has gotten attention from FriendFeed’s strong advocates among the online/social media community. Robert Scoble already posted to Twitter about the post being included on top tech news aggregator Techmeme.

In the review, Bret described how the company looked to manage the rapid growth of content they’re experiencing, with their service currently storing over 250 million entries as well as other comments and data.

Bret said that FriendFeed uses MySQL for storing all of this data, and the company was looking for ways to scale and manage indexes more quickly. Regarding background research, Bret said, "In the tests we read about and ran ourselves, none of the projects were stable or battle-tested enough for our needs… MySQL works. It doesn’t corrupt data. Replication works. We understand its limitations already. We like MySQL for storage, just not RDBMS usage patterns." This lead the team to implement a "schema-less" storage system on top of MySQL rather than use a completely new storage system.

The majority of the review includes the actual high-level architecture FriendFeed employs, and follows with some graphical representation of the success they’ve seen. Bret said, "In particular, the latency of our system is now remarkably stable, even during peak mid-day hours."

In conclusion, Bret noted, "the system has been really easy to work with so far. We have already changed the indexes a couple of times since we deployed the system, and we have started converting some of our biggest MySQL tables to use this new scheme so we can change their structure more liberally going forward."


OpenOffice reviews and how-to articles

February 25, 2009

1. OpenOffice – the free office suite — Bukisa, 2/17
The blogger provided an overview of including its history of origin, community surrounding this free open source software product and its different features. He recommended trying the product as " you could replace Microsoft Office and Adobe Acrobat – saving hundreds of dollars."
2. OpenOffice 3: Useful, Compatible – and Pretty — My Mp3 Player, 2/17
Touting OpenOffice as the "initiate spring challenger to Microsoft Office," the blogger announced that the looked bigger than ever. According to him, 3 was the "best, clever and most widely compatible software ever."

3. Taking Your Microsoft Office Templates, and Making Them Available in or StarOffice — Training, Tips, and Ideas, 2/16
An and StarOffice instructor showed multiple ways of using Microsoft Office templates in and StarOffice.

4. How To Install An OpenOffice Dictionary Manually — Xual – dedicated to users, 2/11
Sometimes the wizard to install dictionaries did not work for Xual, so she went ahead and presented a step by step guide on how to manually add a dictionary in

5. OpenOffice is the best free open source Microsoft Office alternative — Using Windows Blog, 2/10
The blogger was very frustrated with Microsoft Word’s drawing capabilities. She tried OpenOffice Draw, and felt "an all new appreciation for the OpenOffice suite." The blogger found it a very well put together application and recommended trying this office suite.

6. Tom’s Budget Software Pick — Tom’s Macs Blog (, 2/7
Tom Nelson noted that the suite had transformed itself into a more pleasant experience by adding a native OS X Aqua interface. Tom also noticed that one of the best things about was that it was a free open source application, thus saving hundreds of dollars to run a fully functional and highly productive office suite on the Mac.

OpenSolaris Tips & Tricks

February 24, 2009
1. Booting OpenSolaris in verbose mode — Levent Serinol’s Blog, 2/17
Levent Serinol presented a step by step guide on how to boot OpenSolaris in verbose mode.
2. Comparing Drobo and DroboShare to an OpenSolaris storage server — Caffeinated, 2/16
Nathan Fiedler replaced his Drobo storage appliance with one he built using OpenSolaris. He noted that "the recent releases of OpenSolaris are remarkably easy to set up and administer," and he found ZFS to be the most "amazing file system on the planet" since it encouraged easy set ups for storage pools and file systems. In his opinion, OpenSolaris was "the best choice" since it supported SMB, NFS, iSCSI, and AFP apart from running reference implementations of ZFS.

3. Mirrored swap with ZFS on OpenSolaris — chrismiles, 2/13
Chris Miles recently installed OpenSolaris 2008.11 on his development server and liked the fact that out-of-the-box it installed with zfs root filesystems. In this post, he demonstrates how to set up a mirrored swap parition using ZFS.

VirtualBox Experiences

February 23, 2009

1. Installing Windows 7 on Mac — Computerize the world, 2/18
The blogger notes VirtualBox is a favorite for many of his colleagues since it is available for free and "will always be fairly robust." The blogger notes that in addition to offering a plethora of novel features, VirtualBox is also compatible with Windows 7 as a guest operating system, thus making the software even more appealing to developers.

2. VirtualBox 2.1.4 – x86 virtualization software — Apple Bloog, 2/16
The blogger notes that VirtualBox comes from a family of powerful x86 virtualization products from Sun. He adds that VirtualBox is extremely feature rich and is also the only professional solution freely available as Open Source Software under the terms of the GNU General Public License. The blogger writes that VirtualBox is being actively developed with frequent releases, boasts an ever growing list of features, supported guest operating systems and platforms that it can ran on.

Sun xVM VirtualBox
3. VirtualBox — Life as a Physicist, 2/11
Blogger Gordon Watts notes, "I’ve recently become a huge fan of VirtualBox." Gordon states VirtualBox has the "nicest user interface" of the three virtualization solutions he tested. Gordon adds that he now uses VirtualBox all the time, mostly to run Linux for work related applications.

4. VirtualBox as a low cost, high quality desktop virtualization client — enVirtua, 2/10
The blogger reviews Sun’s VirtualBox for Windows, Linux, OpenSolaris and Mac platforms. He notes that the software offers some very interesting features such as better modularity, virtual machine descriptions in XML, guest additions for Windows and Linux, shared folder options, remote desktop protocol and virtual USB controllers among others. "Virtual Box may well be an excellent starting point for people in organizations that need a robust product but are not quite ready for VMware Workstation," he adds.

NetBeans Tutorials and Reviews from Developers

February 22, 2009

1. NetBeans = Best Maven IDE? — Java and more, 2/17
Peter Karich showed what is possible with Maven 2.0.9 in NetBeans 6.5 in a step by step tutorial.
2. I love NetBeans 7! — Nice Words, 2/16
The blogger tested a build of NetBeans 7 that according to him was stable, beautiful and really helped him to get his work done. After further testing, he commented, "NetBeans 7 is really going to rock!"

3. NetBeans 6.5, JavaFX 1.0, Groovy and arithmetic training — Kontrawize, 2/15
Anthony Coates strongly suggested the use of NetBeans for JavaFX development since the IDE offered built-in JavaFX support. He also updated developers about the availability of a slim version of NetBeans that offered bits for Java and JavaFX development, though it was much smaller than the "complete" NetBeans version.

4. Enable JSP editor features for Maven webapp project in NetBeans — Messages from mrhaki, 2/14
Hubert presented a step by step guide to enable JSP editing features for Maven using NetBeans 6.5.

5. NetBeans IDE support for python and JPython and its usage — Techtalks, 2/14
Prasanna Seshadri thought NetBeans is poised to become "the best open source IDE for Python and JPython in near future," and presented a tutorial on python and jython projects using NetBeans.

6. NetBeans 7.0 hands-on experience — Juozas devBlog, 2/13
Juozas shared his experiences testing NetBeans 7.0 as well as the differences from NetBeans 6.5.

7. NetBeans, Komodo Edit, and Bespin — Fuzzy Tolerance, 2/13
Tobin Bradley was looking forward to trying some recent IDE releases. After giving NetBeans a solid review, Tobin concluded that the IDE was impressive, intuitive and responsive.

8. The Big PHP IDE Test: Why Use One And Which To Choose — Smashing Magazine, 2/11
The blogger James evaluated popular IDEs and suggested each IDE for different reasons. James concluded that "both PDT and NetBeans are good. … If editing tools and code completion are more important to you, then pick NetBeans. NetBeans is a bit more responsive, too."

PC Magazine’s OpenOffice Tips & Tricks

February 21, 2009

PC Magazine’s Edward Mendelson took a look at 3.0, highlighting "7 Things You Didn’t Know You Could Do" with the open source office suite. He noted, " 3.0 costs absolutely nothing but comes closer than anything else to letting you delete your copy of Microsoft Office (which probably cost you a lot)."
The majority of his list are tips and tricks to get the most out of the application suite, but one item provided an Easter Egg 1990s-era shoot-’em-up Space Invaders game. 😉

Edward’s list also included instructions on how to perform tasks such as editing multiple parts of a document at the same time, using OpenOffice to open legacy documents, saving files in Microsoft Office format by default, automating actions via macros and changing the default single quote character.

Computerworld review of VirtualBox (hosting Windows 7)

February 20, 2009

Steven J. Vaughan-Nichols of Computerworld tested how Windows 7 runs on a virtualized environment, noting he chose to use Sun’s VirtualBox software because it is free and also because it can used as a host for other operating systems.

Steven discussed in detail the installation process for both Windows 7 and VirtualBox, highlighting VirtualBox’s ability to load ISOs over both a network or from a local drive as well as noting VirtualBox Guest Additions. He stated, "They only work with Linux and Windows guest operating systems. But in either case, they’re darn useful."

Steve also noted that unless one wants to run a high-end game, "VirtualBox gives you everything most of you will need to decide for yourself whether Windows 7 will be worth your time. As far as I’m concerned, Windows 7 and VirtualBox are a great combination."

Sun xVM VirtualBox
Following the conclusion of the article, Steven added a section regarding VirtualBox and why it is his virtualization program of choice. He noted, "I’ve been a VirtualBox user for some time, and I really like it a lot. It’s simpler to use than Xen; it’s largely open source, unlike VMware; and it runs on pretty much any desktop operating system you care to name, which is certainly not the case with Parallels or Microsoft’s Hyper-V."

Steven concluded, "There may be better desktop virtualization programs available than VirtualBox, but I haven’t found one yet. Its combination of flexibility, speed and features makes it my PC virtualization program of choice. If you give it a try, I think you’ll find you agree."

Stellar InfoWorld Review of Sun Storage 7210 Unified Storage System (Amber Road)

February 19, 2009

Amber Road Analytics
Real-time analysis screenshot of the Amber Road storage system
Infoworld’s Paul Venezia reviewed the Sun Storage 7210 Unified Storage System (Amber Road) and accompanying FISHworks management platform, rating it a stellar 9.2 out of 10 and noting, "The Sun Storage 7210 Unified Storage System’s combination of 48 drives, SSD log storage, broad protocol support, ZFS, and amazing GUI make for one great filer."

Paul took a comprehensive look at the unit’s management features, including its real-time monitoring and analytics capabilities. After only a few minutes of use with FISHworks he noted, "I was smitten. It’s very attractive and very accessible. In fact, it may be the most complete filer interface I’ve ever seen, blowing the doors off Network Appliance’s Web-based manager." Paul drilled down into the GUI, highlighting its instant feedback on load and throughput as well as the worksheets ability to provide easy at-a-glance status reports.

Turning his attention to the hardware, Paul configured a storage pool and tested performance via a number of access protocols. For NFS access via Linux, he highlighted that creation of a 10GB file performed at near wire-rate over a gigabit NIC. Paul also noted the solid performance of sequential reads and writes to NFS3, NFS4, iSCSI and CIFS, calling out the 55 to 60MBps throughput while under load. "Again, this is very close to wire-rate speeds," he stated.

Overall, Paul was very positive about his experience with the 7210 concluding, "The market for multilingual filers has plenty of players, from NetApp to Adaptec, but in terms of bang for the buck, Sun’s 7210 is in rare territory. Regardless of price, son of Thumper is a uniquely complete representation of what a filer should be."

MySQL wins Database of the Year 2008 award!!!

February 18, 2009

MySQL has been selected as the Database of the Year in the 2008 Members Choice Awards. MySQL got 58.10% of the total votes cast!!!

Congratulations, MySQL team!

MySQL Wins Award

Tips & Tricks from MySQL Experts

February 17, 2009

1. Are MySQL stored procedures slow? — Database Science, 2/13
Brooks Johnson shows MySQL stored procedures are not as fast as equivalent C# and Java codes, and recommends not to implement computationally expensive business logic in the database.

2. Re: Are MySQL stored procedures slow? — Antony’s MySQL bits, 2/13
In response to the post above, Antony Curtis shows that using Perl, a stored procedure will be a lot faster than MySQL’s native SQL stored procedures (though not as fast as bytecode languages with JIT compilers).

3. How much memory can MySQL use in the worst case? — MySQL Performance Blog, 2/12
In a detailed post, Baron Schwartz discusses various memory usage scenarios in MySQL. He concludes that worst case memory usage scenario is not something worth worrying about much. Brian thinks it is far better to use a monitoring tool to watch the actual memory usage over time and see how it varies.

4a. Of MySQL 5.1 and Joomla part 2 – A dirty trick and an idea — Karlsson on databases and stuff, 2/12
4b. Of MySQL 5.1 and Joomla part 1
Anders has developed a site using Joomla CMS and MySQL. He goes over the tricks of overcoming some of Joomla’s shortcomings on MySQL usage.

5. Altering a HUGE MyISAM table in MySQL — Tech Scraps, 2/10
Vivek Jain had to alter a MyISAM table with approximately 300 million records. He found out some nifty tricks that did the job under 5 hours.

6. MySQL Front 5 — Ickokid IT Solution, 2/10
The blogger highlighted MySQL-Front as a "real" application that could offer a more refined user interface to MySQL as compared to systems built on PHP and HTML. "MySQL-Front makes working with MySQL databases a snap without hiding the language from the user," he noted.