PDA

View Full Version : Scaling out the HEM database, options?



Verbatim
04-07-2011, 10:20 AM
Are there any options available to scale out the HEM database across multiple computers?

There seem to be some options (Replication, Clustering, and Connection Pooling - PostgreSQL wiki (http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Poolin g)) available, but I'm having a hard time deciphering that page.

Ideally a system where you can just hook up new computers as you need and the DB would span out onto them. So you could effectively have a HEM database of any size without any performance hit so long as you continue to add new computers.

Has anyone done this with a postgres database, or have any suggestions?

Sarek
04-07-2011, 11:35 AM
Please read all this http://faq.holdemmanager.com/categories/Frequently+Asked+Questions/PostgreSQL/Run+PostgreSQL+Over+a+Network/

Verbatim
04-07-2011, 11:38 AM
Please read all this http://faq.holdemmanager.com/categories/Frequently+Asked+Questions/PostgreSQL/Run+PostgreSQL+Over+a+Network/

Read, thank you. I am attempting to go one step further and shard/cluster the database across multiple database servers.

Sarek
04-07-2011, 11:45 AM
He-he, then you will meet other problem, even if it will work: this can be against rules stated by rooms, because this practically means sharing hand history between many players.

Verbatim
04-07-2011, 12:02 PM
He-he, then you will meet other problem, even if it will work: this can be against rules stated by rooms, because this practically means sharing hand history between many players.

I think you misunderstand my question. The content of the database(s) will be the same regardless of sharding/clustering. Where the hand histories come from will not change regardless of the technology behind the database.
This is simply a measure to increase the performance of a postgres database.

netsrak
04-08-2011, 03:39 AM
We are only the holdemmanager support :)
What you are asking for is a clustered database. This is something you should look for in postgresql related forums.

Verbatim
04-08-2011, 04:41 AM
We are only the holdemmanager support :)
What you are asking for is a clustered database. This is something you should look for in postgresql related forums.

Sure, I don't _expect_ any help from the support staff. This definitely lies outside the normal usage of HEM :)

But if any HEM users have done this I'd love to hear about their experiences.