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