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 »

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.

There was a blog entry on ZDNet a few days ago regarding JavaDB. JavaDB is a relational database management system written in Java. Apache has its own version named Derby. The JavaDB system will be included in Sun’s Solaris Enterprise System. Read the rest of this entry »

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 »