| As we started the project of our electronic | | | | not the most popular Open Source Code |
| auction, we knew that the proprietary | | | | database. A matter of marketing ? Probably. |
| software costs would be too high for our | | | | |
| financial resources. Our only option then was | | | | As for the programming language PHP, we had |
| to make use of Open Source Code softwares. | | | | to use an object oriented application |
| | | | structure. There are many PHP application |
| However, within the Open Source Code there | | | | structures being offered with Open Source |
| are lots of softwares to choose from, and | | | | Code license. Object oriented application is |
| it´s up to the system analyst/programmer | | | | very important, because it makes programming |
| to pick the ones that best suit the project | | | | very easy and scalable up to the point where |
| goals. | | | | the system may grow without many problems. |
| | | | Also, it helps to keep PHP code separated |
| In our case, we picked Linux as our operating | | | | from HTML, with the help of some specific |
| system. However we faced a big question: | | | | libraries, such as Smarty. We make use of |
| Which Linux distribution ? There are dozens | | | | Smarty library and we believe that it is a |
| of linux distributions, each one with | | | | very important resource, which can even make |
| specific advantages, sometimes with or | | | | web pages faster thru the use of its cache |
| without paid services. | | | | functions. |
| | | | |
| We chose linux Slackware because we thought | | | | Also a very important set of libraries worth |
| that it would suit better our needs, in terms | | | | mentioning for PHP systems, is the PEAR |
| of stability and reliability. Slackware is a | | | | libraries. In PEAR web site, among the many |
| conservative distribution, meaning that it | | | | libraries being offered, there are the |
| only offers in its distribution package | | | | database interface DB and the MAIL_QUEUE, |
| kernel versions and third party libraries, | | | | which sends emails thru the use of database. |
| once it´s been proved to be stable and | | | | |
| reliable. As a result, Slackware is one the | | | | As we came to the end of our web site |
| most stable Linux operating system on the | | | | project, we had to use some sort of real time |
| market. If the user wishes the most recent | | | | database replication. For that we chose the |
| Linux kernel and libraries, we recommend to | | | | DRBD and Heartbeat libraries. The use of |
| look for a different distribution. | | | | database replication is very important and |
| | | | should not be postponed. Just after 3 months |
| Another reason for us picking Slackware, was | | | | our system got into production, our server |
| because of its text interface, which at the | | | | hard disk became bad. Thru the use of DRBD |
| beginning may become a bit difficult, in the | | | | Heartbeat we were able to put the system back |
| long run however it offers a better | | | | into production within seconds, without |
| understanding of the Linux environment. This | | | | loosing any data. DRBD/Heartbeat replication |
| way most of Slackware configurations are done | | | | is done thru the use of a lan network between |
| thru text scripts. | | | | the server and slave nodes. |
| | | | |
| Once it was set the operating system, we | | | | Our project also makes use of ImageMagick |
| picked Apache as our web server. Apache is | | | | (enlarge and reduce images), Iptables |
| one of the most popular web server in the | | | | (firewall), Tsearch2(text search in |
| internet. For server programming language, we | | | | portgresql) and Mon (linux monitoring tasks). |
| chose PHP. Also, a very popular programming | | | | |
| language. Our experience with Apache/PHP | | | | Also a very important library worth |
| proves that this setup is very reliable, | | | | mentioning is the pseudo APC compiler for |
| working extremely well in our production | | | | PHP. Speed is always a critical factor for |
| environment. For workstation programming | | | | internet sites. |
| language, we chose javascript, which besides | | | | |
| of having a simple syntax, it offers lots of | | | | Our web site is already in production and |
| resources. | | | | based upon our experience we can say that the |
| | | | Open Source Code softwares we picked, proved |
| Apache web server is really a complete web | | | | to be extremely reliable and stable. Open |
| server. Also, it can become very complex with | | | | Source Code softwares can certainly be an |
| many configuration setups. | | | | excellent option for developing web sites. |
| | | | |
| For our database, we picked Postgresql. This | | | | Roberto Sedycias |
| database has been made available to the | | | | |
| public for more than 15 years, and besides of | | | | IT Consultant |
| being well debugged, it offers so many | | | | |
| resources that it has become one of the best | | | | This article is under GNU FDL license and can |
| database options from Open Source Code | | | | be distributed without any previous |
| softwares. Extremely reliable, Postgresql has | | | | authorization from the author. However the |
| reported cases where there have been | | | | author´s name and all the URL´s (links) |
| databases in production with over 4 | | | | mentioned in the article and biography must |
| terabytes. Besides all of that, Postresql is | | | | be kept. |