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 smaller most actively used tables.
Optimized Penny Auction Structure
All data required for fast processing of the auction gathered together in one optimized record. When any data changed in another tables, data is subsequently copied into auctions table. It allows to 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 stored separtely from bids of the active auctions 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 most greedy 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 server only can 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 absolutely critical for performance dependent website
Manual Check of SQL queries
After the website had been 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 had been 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 and to hold bigger amount of simultaneous users
MySQL server optimized settings
MySQL server setting are set by a specialists to have best combination of cache and memory.
Apache server optimized settings
Apache is configured to handle maximal number of short connections.
Cacti.net Installation
Cacti.Net, leading open source solution for tracking server load installed to provide visual presentation of the compter load during peak hours. Multiple views provide detailed information which components are
While most of information too technical for business owner, presence of the tool has double role: it provides basic indications to the business owner where the bottleneck (memory, MySQL capacity etc) and it 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 on a hardware by a special needs of penny auction scripts
