Howto forge has another tutorial on setting up LAMP on the latest version of Ubuntu Linux. Ubuntu is definitely my Linux flavor of choice probably because it’s the easiest for me to setup and somewhat resembles my favorite platform of choice Mac OS X. The LAMP stack runs well on Ubuntu and for the most part has gotten a lot easier to install. I no longer have weird issues where I ask myself why is it doing that, and have no explanation. Read the rest of this entry »

For a while I have been using the program Navicat to control MySQL databases and I still use it and will continue to use it. It does a great job and it is really easy to use. The price seems reasonable to me for the features it offers so I can’t really complain. Since I had been working with a lot of AJAX applications and noticed a lot of desktop applications being converted to web applications. Read the rest of this entry »

CNET News.com had a post a couple days ago about LAMP in the industry. For those of you that don’t know LAMP is Linux operating system, Apache Web Server, MySQL database, and a scripting language such as PHP, Perl, or Python. Many times I will use this system on Mac OS X and use PHP as my scripting language of choice. Read the rest of this entry »

I recently blogged on “The Perfect Setup” for SuSE and Howto forge has another tutorial describing the perfect setup using Ubuntu 6.06 LTS Server (Dapper Drake). Since this is the Linux of choice for me, it’s a much better tutorial for me to follow when I create my server installations. I know many people like Ubuntu as well so this should help some. Most people that are doing installations like this already have a pretty good idea on what they are doing, but well written documentation to use as a guide never hurt. Read the rest of this entry »

While my Linux platform of choice is still Ubuntu, there is a pretty good tutorial on Howto Forge on setting up services for an ISP such as web server, mail server, DNS server, FTP server, MySQL server, Quotas, and Firewall. The author of the article chooses SuSE Linux for his installation, but this tutorial with a little bit of modification could be used on any flavor of Linux. If you are looking to use SuSE this may be a good tutorial for you to use to setup your machine. Read the rest of this entry »

For those of you using MySQL databases, Neal Parikh has a page on his site with common MySQL database commands. Although its isn’t as comprehensive as lets say the MySQL manual, it does give quite a bit of information that I would need on an everyday basis. The list covers most of the commands I think developers would need to incorporate into a website so give it a look.

For those of you with high traffic sites or would like to add some redundancy to your MySQL database, clustering is a very good starting point. That is assuming that you have about 4 or 5 machines that you can spare. Howto Forge has a great tutorial on setting this up on 4 machines using MySQL 5 Cluster. The setup requires two storage nodes and one management node and two nodes for load balancing. The example utilizes 4 machines by loading the cluster management server onto one of the load balancing machines. Read the rest of this entry »

MySQL plans to release technical details of its upcoming storage engine and administration tools. The codename for this database engine is Falcon expected to be completed later this year. A user conference will take place this coming week detailing specifics regarding the new engine. Read the rest of this entry »

Solid Information Technology will create the open-source storage engine designed for transactional applications reported by ZDNet as well as CNET News.com. Read the rest of this entry »