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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.