On 2012-06-11 09:35, John R Pierce wrote:
On 06/10/12 11:26 PM, Condor wrote:
Im not sure, just looking how to make load balance. I have a small
database around 20 gb,
but I expect to join another database on different scheme and Im
looking for solution
about load balance or some cache mechanism. Bad part is one row from
db is read once
in a month, in worst scenario 3-4 times in month and I think cache
is not good option,
but I don't have idea how will work.
whats the problem you're trying to solve? so far, doesn't sound
like you have anything that a decent database server couldn't handle
easily.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
Maybe my fault that I have divided the issues into two separate e-mail,
one for load balance and one bound by rules on how to bind together
two bases of different schemes.
As I wrote my base is small, and the server keeps a small load average,
but if bind together the two databases since
both must use the recording and reading 3-4 tables only, I seek advice
if the server load is too much what I could do to it landed.
If I run load balance with pgpool how stable will be my system, I run
stream replication but I see when master send data to
slave and in this time I query slave server, slave server break query.
Did I will have same problems with pgpool.
Basically I want to be prepared what options I have if this happens.
H.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
