Monthly Archives: May 2012

WAMP stacks reviewed

From Infoworld:

Review: WAMP stacks for Web developers

Created 2012-05-30 03:00AM

There are two places where I do software development for the Web. The first is “out there,” on the Web server for which I pay my monthly hosting fee. The second is “in here,” right on my own desktop, where I have a stand-alone Web development stack running side by side with everything else.

A stand-alone Web stack is a self-contained way to run the needed components for a Web application without requiring a separate machine or Web account, both of which typically mean extra dollars. Developers can prototype a project locally on such a stack, then deploy the results to a live remote server — or even convert the local stack into a live server, if they’re so inclined and the stack is designed for production use. If you’re a novice Web programmer, a local stack is a handy way to learn the ins and outs of programming for the Web in a controlled environment.

Linux users have the advantage of the Web stack being a native part of their environment, since Linux distributions aren’t as rigidly partitioned into “desktop” and “server” editions as Windows is — except in the sense of which components are installed by default. Windows users, though, have to install the entire stack from scratch. The good news is that all the pieces they’d need — Apache, MySQL, PHP, and so on — are available in Windows editions.

In this article I review five environments — AMPPS, BitNami WAMPStack, Microsoft Web Platform Installer, XAMPP, and WampServer — you can use to set up a local Web development server on a Windows box. These stacks contain all of the above-mentioned components (with IIS and SQL Server Express taking the place of Apache and MySQL in Microsoft’s offering) installed from a single executable or .MSI package, so each piece doesn’t need to be downloaded, installed, and configured separately. These Web server stacks also contain management tools for each separate component and for the stack as a whole, so you’re not stuck with the extra burden of having to manage the whole thing by hand. And they’re all free for the downloading.

Continue reading

10 essential MySQL tools

From Infoworld:

10 essential MySQL tools for admins

Created 2011-08-01 03:00AM

MySQL is a complex system that requires many tools to repair, diagnose, and optimize it. Fortunately for admins, MySQL has attracted a vibrant community of developers who are putting out high-quality open source tools to help with the complexity, performance, and health of MySQL systems, most of which are available for free.

The following 10 open source tools are valuable resources for anyone using MySQL, from a stand-alone instance to a multiple-node environment. The list has been compiled with variety in mind. You will find tools to help back up MySQL data, increase performance, guard against data drift, and log pertinent troubleshooting data when problems arise.

There are several reasons why you should consider these tools instead of creating your own in-house tools. First, thanks to their wide use, they’re mature and field-tested. Second, because they are free and open source, they benefit from the knowledge and experience of the continually expanding MySQL community. Finally, these tools are actively developed, and many are professionally supported (either for free or commercially), so they continue to improve and adapt with the evolving MySQL industry.

Continue reading