MySQL Journal

I recently finished Stanford’s excellent free on-line course Introduction to Databases with Jennifer Widom. The course is a broad survey of database technology including XML, Relational Database Management Systems (RDBMS) from many angles (SQL forms the centerpiece of the course), OLAP (OnLine Analytical Processing) and NoSQL. I was very impressed with the breadth of Widom’s approach to the subject: it was a major reason I decided to spend time on the course. Another strength is its nuts-n-bolts approach: some theoretical topics are covered but for the most part this is a course for practitioners. Finally, I particularly appreciated the extensive use of FOSS (Free and Open Source Software) in the course. Why study databases? I will merely say that data is a core tool pervading the information resources of modern civilization. Databases are where data is housed. Fo... (more)

Top 10 Open Source eCommerce Software (Joomla and Drupal)

This is the second of two articles about open source ecommerce software that we hope will help web developers and system administrators in selecting what is best for their needs. The first article Top 10 Open Source eCommerce Software (Joomla and Drupal) reviewed: HikaShop, SimpleCaddy, OpenCart, redSHOP and RokQuickCart. The following article details our own analysis of the last 5 vendors in our article series. 6.   VirtueMart – http://virtuemart.net/ Founded in 2005, the company VirtueMart has developed a free and open source shopping cart software as an extension for Joomla.... (more)

Connectria Hosting Achieves "Off the Chart" Operational Efficiency With Cloud-Based Storage Solution From Nexsan and CommVault

THOUSAND OAKS, CA -- (Marketwire) -- 01/26/12 -- Nexsan®, a leading independent provider of disk-based data storage systems, today announced that Connectria Hosting, a global managed hosting company, has deployed the Nexsan Flexible Storage Platform™ in support of the company's cloud-based backup and recovery services for enterprise clients. In combination with CommVault® Simpana® data and information management software, Nexsan's storage systems have dramatically improved Connectria's backup and recovery efficiency when compared to the previously deployed solution. Connectria H... (more)

Viper Networks and LEDs America Announce New LED-O® Product to Replace Standard 100W Incandescent Bulbs

Viper Networks, Inc. (Pink Sheets: VPER), in conjunction with LEDs America, Inc., is pleased to announce the forthcoming market introduction of the 9W LED, their latest incandescent replacement lamp, which targets the replacement for 100W incandescent bulbs. The 9W LED bulb from LEDs America (replaces 100W incandescent bulbs) will join the other two similar products, including the 5W LED (replaces 60W incandescent bulbs) and the 4W (to replace 40W incandescent bulbs). The 9W LED lamp is just the newest product in a series of LED lights from LEDs America, to provide consumers a su... (more)

Basic Apache and MySQL Performance Tuning

Apache and MySQL make up the backbone of many Linux based web servers. According to the August 2011 Web Server Survey by Netcraft, Apache currently runs on 65.18% (or 301,771,518!) of web servers.  Similarly, MySQL is the most popular open source database and holds a significant portion of the market share – especially for web content.  This article will detail how you can get at the ‘low-hanging fruit’ in order to make some simple changes that will yield big performance gains. Apache Tuning If your system is running httpd, the Apache web server, it will definitely benefit you t... (more)