Re: [GENERAL] Question about load balance

2012-06-12 Thread Condor
On 2012-06-12 10:48, John R Pierce wrote: On 06/11/12 11:29 PM, Condor wrote: I think I'm trying to learn information what is the technique for managing large databases not to philosophize what was my server. you handle large databases with a lot of fast disk, and memory, this gets you into t

Re: [GENERAL] Question about load balance

2012-06-12 Thread John R Pierce
On 06/11/12 11:29 PM, Condor wrote: I think I'm trying to learn information what is the technique for managing large databases not to philosophize what was my server. you handle large databases with a lot of fast disk, and memory, this gets you into the terabytes. clustering/load balancing

Re: [GENERAL] Question about load balance

2012-06-11 Thread Clemens Eisserer
Hi, > I think I'm trying to learn information what is the technique for managing > large databases > not to philosophize what was my server. In this case it starts to get very specific about what you are trying to accomplish. Transactional databases offer a lot guarantees, which makes it hard to

Re: [GENERAL] Question about load balance

2012-06-11 Thread Tatsuo Ishii
> My question was how stable is pgpool, what problems I can > expect, and pure curiosity what is the technique for managing large > databases. > CPU and memory to the second coming or are there other techniques for > scattering > applications on other servers. > > > --- cut --- > > I think I'm

Re: [GENERAL] Question about load balance

2012-06-11 Thread Condor
On 2012-06-11 22:47, John R Pierce wrote: On 06/11/12 12:17 PM, Condor wrote: May be because some times when some one start a new business does not have 20k $ for a new server and resource of the server is enough for the moment and as I planed is enough for this year. and when you start a ne

Re: [GENERAL] Question about load balance

2012-06-11 Thread Chris Angelico
On Tue, Jun 12, 2012 at 5:17 AM, Condor wrote: > On 2012-06-11 21:03, John R Pierce wrote: >> >> On 06/11/12 2:11 AM, Condor wrote: >>> >>> Yes, I now but these parameters can't be increase forever. It's can but >>> isn't cheep. >>> For that reason I looking some other ways. >> >> why don't you wo

Re: [GENERAL] Question about load balance

2012-06-11 Thread John R Pierce
On 06/11/12 12:17 PM, Condor wrote: May be because some times when some one start a new business does not have 20k $ for a new server and resource of the server is enough for the moment and as I planed is enough for this year. and when you start a new business, you don't lease a campus large

Re: [GENERAL] Question about load balance

2012-06-11 Thread Condor
On 2012-06-11 21:03, John R Pierce wrote: On 06/11/12 2:11 AM, Condor wrote: Yes, I now but these parameters can't be increase forever. It's can but isn't cheep. For that reason I looking some other ways. why don't you worry about that when you get there, rather than before you even start?

Re: [GENERAL] Question about load balance

2012-06-11 Thread John R Pierce
On 06/11/12 2:11 AM, Condor wrote: Yes, I now but these parameters can't be increase forever. It's can but isn't cheep. For that reason I looking some other ways. why don't you worry about that when you get there, rather than before you even start? I've got a 2U dual xeon X5660 server w/ 4

Re: [GENERAL] Question about load balance

2012-06-11 Thread Condor
On 2012-06-11 10:23, John R Pierce wrote: On 06/11/12 12:11 AM, Condor wrote: I seek advice if the server load is too much what I could do to it landed. I recommend a faster server for this. more CPU cores, more memory, faster storage. that will take you a LONG ways, much simpler than compl

Re: [GENERAL] Question about load balance

2012-06-11 Thread John R Pierce
On 06/11/12 12:11 AM, Condor wrote: I seek advice if the server load is too much what I could do to it landed. I recommend a faster server for this. more CPU cores, more memory, faster storage. that will take you a LONG ways, much simpler than complex and fragile database cluster schemes

Re: [GENERAL] Question about load balance

2012-06-11 Thread Condor
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 mechanis

Re: [GENERAL] Question about load balance

2012-06-10 Thread John R Pierce
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 onc

Re: [GENERAL] Question about load balance

2012-06-10 Thread Condor
On 2012-06-08 08:39, Craig Ringer wrote: On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load averag

Re: [GENERAL] Question about load balance

2012-06-08 Thread René Romero Benavides
Am 08.06.2012 00:39, schrieb Craig Ringer: On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load aver

Re: [GENERAL] Question about load balance

2012-06-07 Thread Craig Ringer
On 06/07/2012 10:26 PM, Condor wrote: Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load average ? Im looking for something multi master

[GENERAL] Question about load balance

2012-06-07 Thread Condor
Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? What load average ? Im looking for something multi master solution. Thanks, Hristo -- Sent via