Dice Server Progress
I’ve been working on the new Dice Server architecture. To that end, and as part of a system-wide project to convert my Perl code to Ruby code and to convert all my text-based database files to actual database tables and records c/o mySQL, I can now boast the following:
- RandomSvce_Seeds
- Database table containing the 32 seeds and modulos for the 32 parallel randomizers.
- RandomSvce_Statistics
- Database table containing service statistics for the 32 parallel randomizers including # bits generated, requested, granted and # requests.
- RandomSvce_BitPools
- Database table containing random bit pools for each of the 32 parallel randomizers, each pool containing 32,768 random bits.
- get_random_bits
- SQL stored procedure to get a subset of random bits out of a specific bit pool.
- update_bit_pools.rb
- Ruby script which will be used by a cron job to create random bit pools for randomizers which run low on available bits. This job will run at 15 minute intervals and will create one random bit pool. Because the random bit pool generator can peg the CPU, I am trying to avoid getting flagged for excessive CPU usage by DreamHost.
- DiceSvce_Dice
- Database table containing the # of random bits needed for accurate probabilistic results for each of a range of possible outcomes (2-255) as well as an error differential state for those outcomes that don’t divide evenly into the randomly generated integer of the associated bit size.
Coming soon: DiceSvce_Users, DiceSvce_Logs, DiceSvce_RequestSpaces, dice service handler scripts and load balancing.