Double Database Architecture Layer
Penny Auction double database architecture layer is a software component that serves to boost performance and save hardware resources on highly active penny auction websites. It includes database modifications that help to manage big amount of users, special database scheme, that duplicates critical data in order to make the most actively used tables smaller.
Optimized Penny Auction Structure
All data required for fast processing of the auction is gathered together in one optimized record. When any data is changed in other tables, it is subsequently copied into auctions table. It allows the server to have very effective SQL queries, resulting in improved performance.
Optimized Obsolete Data Storage
Bid History and other relevant data for old auctions is stored separately from bids of the active auctions in order to minimize size of the database. As a result, database server works faster performing operation with smaller amount of information.
Penny Auction Script accumulates a lot of information writing each bid history into the database.
Optimized Timer Data
Auction timer is the greediest element for hardware resources. Penny Auction Script polls the server each second to get an update, creating almost permanent connection for each user on the website! While most servers can only handle few hundreds connections per second, the speed of the timer becomes the major bottleneck of the website.
Special architecture allows to prepare and keep most of the time in memory list of active auctions and their winners, prices, as well as all other relevant info. The timer is a heart of a penny auction software and its well being is absolutely critical for performance dependent website.
Manual Check of SQL queries
After the website was built there, is a check performed by the specialist to verify that current composition of plugins, modification is optimized.
Manual Check of Memory Consumption
After the website was built, there is a check performed by the specialist to verify that current composition of plugins consumes minimal amount of memory. As a result the website is able to perform better as well as hold bigger amount of simultaneous users.
MySQL server optimized settings
MySQL server setting are set by a specialists to have the best combination of cache and memory.
Apache server optimized settings
Apache is configured to handle the maximal number of short connections.
Cacti.net Installation
Cacti.Net, the leading open source solution for tracking server load is installed to provide visual presentation of the computer load during peak hours.
While most of the information is too technical for the business owner, presence of the tool has the double role: it provides basic indications to the business owner where the bottleneck (memory, MySQL capacity etc) is and also gives a valuable information to programmers and DB administrators to understand the bottlenecks.
Bound together, these tools provide a solid answer to the challenge imposed to a hardware by a special needs of penny auction scripts
