JavaScript is turned off in your web browser. Many features of this website depend on you having Javascript turned on, please enable it in your browser settings.

Register for FREE!


Enjoy full access to the best online poker tools by registering now, no strings attached.









Already a member? Sign in now.

Main » PTR News

Welcome to the Tech Corner!

By dameon - April 21st, 2009

Hey there! My name is Dameon, and I’m the technical director around here at PokerTableRatings.com. I spend most of my time working on the behind the scenes technology that keeps things moving seamlessly, but I also have quite of bit of involvement in the front end stuff as well. In response to the avalanche of e-mails from people interested in the technology behind PokerTableRatings.com I’ve decided to start a technical blog, the Tech Corner! In this blog I’ll periodically go over some of the challenges we’re facing, or even just give a sneak-peak into our operations.

I thought for my first blog I’d start with the heart and soul of our operations, the database. The database is what holds all of the information that is extracted from raw hand histories about players and hands themselves. It is what powers the PokerTableRatings.com player search.

The database isn’t actually any single database, as of this moment it consists of 6 database nodes. For those that are curious, the nodes servers have dual quad core Intel Xeon processors, 32 gb of memory, and a varying amount of disk space between 1.4TB and as much as 14TB configured in raid-10 arrays.

New data that comes in is spread over the database nodes that are currently active for writing. As a node starts to fill up, writing is turned off and it becomes a read only node. Reading is done via a custom application we call the “balancer,” which transparently queries all of the nodes at the same time and assembles the data into a single response.  There will be a blog in the future which goes into more detail about the balancer, as it is a very interesting piece of technology.

This helps explain our recent upgrade which took a few weeks. One of our database nodes became too full before we turned it off as a write node. Since it was so full, even once doing only read work, it still wasn’t fast enough for real time access. So to fix this we had to dump that entire node (about 300 million hands), and reinsert it across 3 new nodes. That was quite a bit of work :)  We were also upgrading a few other servers involved in the process, preparing for the launch of the new PokerTableRatings.com.

As you can see, I love my job around here! I’m happy to discuss our technology and answer any questions I can, just shoot me an e-mail at dameon@pokertableratings.com, make a post in the forums, or even comment on this post.

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • StumbleUpon

Leave a Reply

You must be logged in to post a comment.

Latest News
» Hands Tracked:
5,765,900,109
» Tables Watched:
6,904
By Patrick Wallace 17 hours ago
By Patrick Wallace 4 days ago
PTR_Dameon: Thanks to all the beta applicants!
1 week ago
PTR Wall
BigBlueBonzzzai is down $5,583 today
11 minutes ago
R0b5ter commented on geeforce1
16 minutes ago ·More info
mcbethk commented on Mr Biswas
17 minutes ago ·More info
stekenna commented on nanonoko
22 minutes ago ·More info
S ON MY CHEST won a $8,348 pot
35 minutes ago ·More info
PERSONABLEGUY won a $10,098 pot with 4Club4Diamond
39 minutes ago ·More info
XBLINK won a $13,395 pot with ASpadeAHeart
41 minutes ago ·More info
cro0shisaBOSS on forum topic: I'll Take A Stake, Check Out M…
2 hours ago
Metis II (fast, 6 max) $200/$400 FL (6 max) has opened on PokerStars
2 hours ago ·More info
Marcellio on forum topic: I'll Take A Stake, Check Out M…
3 hours ago
P.P. Obrien on forum topic: I'll Take A Stake, Check Out M…
4 hours ago
 
Home | Tools | Forum | Blog | FAQs | Contact | Advertise | Affiliates
Player Search | Table Selection | Top Winners | Top Losers | Popular Poker Players | Most Commented Players | Biggest Pots | High Stakes | Rakeback | Hand Histories | Buddy List
Copyright © 2010 PokerTableRatings.com. All Rights Reserved.