On 10 October 2016 21:14:55 CEST, Periko Support
wrote:
>I'm trying to get better numbers, is a option in the table.
>Meanwhile I reading some system performance numbers.
>Yes odoo is strange sometimes.
>But a cluster will be good for HA.
>Thanks.
>
>
Please identify the problematic queries (
I'm trying to get better numbers, is a option in the table.
Meanwhile I reading some system performance numbers.
Yes odoo is strange sometimes.
But a cluster will be good for HA.
Thanks.
On Mon, Oct 10, 2016 at 11:12 AM, Pavel Stehule wrote:
> Hi
>
> 2016-10-10 17:20 GMT+02:00 Periko Support :
>>
Hi
2016-10-10 17:20 GMT+02:00 Periko Support :
> I have done some tuning for psql base on odoo, but I want to know if a
> cluster can help to get a better performance, this why I ask here in
> the community who has experience with clusters.
> Appreciate your help Pavel.
>
It is hard to say if cl
I have done some tuning for psql base on odoo, but I want to know if a
cluster can help to get a better performance, this why I ask here in
the community who has experience with clusters.
Appreciate your help Pavel.
On Sun, Oct 9, 2016 at 9:29 PM, Pavel Stehule wrote:
> Hi
>
> 2016-10-10 6:22 GMT
Hi
2016-10-10 6:22 GMT+02:00 Periko Support :
> Hi.
>
> We are searching for a cluster solutions for postgresql, we need to
> increase our current psql server performance running under ubuntu 14
> v9.3.
>
>The db is for odoo 7.x
>
I have some experience with odoo 7.x - there are lot of p
Give a look to PEN, it is a load-balancing daemon :)
Luis Daniel Lucio Quiroz
CISSP, CISM, CISA
Linux, VoIP and much more fun
www.okay.com.mx
Need LCR? Check out LCR for FusionPBX with FreeSWITCH
Need Billing? Check out Billing for FusionPBX with FreeSWITCH
2015-06-27 9:32 GMT-04:00 Gerdan Rezen
>
> because you quickly get trapped into OS specific quicksand with these
> features.
>
Isn't that an issue with just about every feature? Besides the issues
have already been solved mostly. Pgpool already exists. Tatsuo Ishii
says porting a windows is just a resource issue as he doesn't have the
On 01/17/12 12:33 PM, Tim Uckun wrote:
I think I am probably going to explore this option first. I don't
know why automatic failover, failback, etc are not built in already. I
guess even connection pooling ought to be built in. Seems like
everybody would need that no?
because you quickly get
>
> I have a few clusters running on EC2 using DRBD to replicate between
> availability zones. It's not fast, but it works. If your write load is under
> 30MB/sec it's definitely an option. I run DRBD over SSH tunnels to get around
> the random IP address issue. I use heartbeat on top for resource
On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> http://www.drbd.org/ ??
> Built in hot standby and hand rolled scripts.
>
I have a few clusters running on EC2 using DRBD to replicate between
availability zones. It's not fast, but it works. If your write load is under
30MB/sec it's d
On Tue, Jan 17, 2012 at 12:31 PM, David Morton wrote:
> Have you looked at a 'shared storage' solution based on DRBD ? I configured
> a test environment using SLES HAE and DRBD with relative ease and it behaved
> very well (can probably supply a build script if you like), there are lots
> of peopl
On Tuesday, January 17, 2012 10:34:54 AM Tim Uckun wrote:
> Hey Guys.
>
> It's been a while since I looked into this and it seems like new
> options have cropped up for postgres HA and scalability. Is there a
> consensus on the "best" way to achieve HA. My primary concern is HA
> but of course a
gresql.org
Sent: Tuesday, 17 January 2012 12:21 PM
Subject: Re: [GENERAL] HA options
>
> I wonder. If its a write heavy database, I totally agree with you. But if
> its mostly read-only, and mostly fits in ram, then a pgpool of servers
> should be faster.
>
> Be nice to kno
>
> I wonder. If its a write heavy database, I totally agree with you. But if
> its mostly read-only, and mostly fits in ram, then a pgpool of servers
> should be faster.
>
> Be nice to know the usage patterns of this database. (and size).
>
In this case the databases are small to medium and the
On 1/16/2012 4:13 PM, Andy Colson wrote:
On 1/16/2012 4:09 PM, John R Pierce wrote:
On 01/16/12 2:04 PM, Tim Uckun wrote:
I realize that. Eventually we might have to go to physical machines
but for now we are using virtual servers and I have to make it work
within that structure.
quite the ca
On 1/16/2012 4:09 PM, John R Pierce wrote:
On 01/16/12 2:04 PM, Tim Uckun wrote:
I realize that. Eventually we might have to go to physical machines
but for now we are using virtual servers and I have to make it work
within that structure.
quite the catch-22. a single well built dedicated serv
On 01/16/12 2:04 PM, Tim Uckun wrote:
I realize that. Eventually we might have to go to physical machines
but for now we are using virtual servers and I have to make it work
within that structure.
quite the catch-22. a single well built dedicated server likely would
be MORE reliable than a c
>
> virtual servers tend to have lousy storage performance, for what thats
> worth. the actual physical resources are being shared by who knows what
> other workloads, and they tend to be higher latency than direct-attach
> storage, or proper SAN.
I realize that. Eventually we might have to go to
On 01/16/12 1:34 PM, Tim Uckun wrote:
the servers will be virtual on either rackspace or amazon so that's
possibly a complication.
virtual servers tend to have lousy storage performance, for what thats
worth. the actual physical resources are being shared by who knows what
other workloads,
On Tue, Jan 17, 2012 at 10:47 AM, David Morton wrote:
> Is shared storage an option for you ? We've had a fairly pleasant experience
> with shared storage partnered up with SLES and its HAE (high availability
> extension) suite using a Pacemaker cluster for resource control. On top of
> this we re
Is shared storage an option for you ? We've had a fairly pleasant experience
with shared storage partnered up with SLES and its HAE (high availability
extension) suite using a Pacemaker cluster for resource control. On top of this
we replicate to a hot standby server offsite, however used for re
On Monday 17 January 2011 5:43:19 am Jaiswal Dhaval Sudhirkumar wrote:
> http://wiki.postgresql.org/wiki/Streaming_Replication
>
> I have gone through the above link. Current streaming replication provides
> Asynchronous based solution & synchronous solution will come with version
> 9.1
>
> Can som
ease?
--
Thanks & Regards
Dhaval Jaiswal
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Mon 1/17/2011 1:41 AM
To: pgsql-general@postgresql.org
Cc: Jaiswal Dhaval Sudhirkumar; John R Pierce
Subject: Re: [GENERAL] HA solution
On Sunday 16 January 2
On Sunday 16 January 2011 7:19:49 am Jaiswal Dhaval Sudhirkumar wrote:
> Thanks for your great comments.
>
> I have gone through suggested link & the streaming replication with 9.0+.
> (We are using PostgreSQL 8.4. Not to worry I will migrate it to 9.0+)
>
> It seems to me that if i will go with th
Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Sun 1/16/2011 1:28 AM
To: pgsql-general@postgresql.org
Cc: Jaiswal Dhaval Sudhirkumar; John R Pierce
Subject: Re: [GENERAL] HA solution
On Saturday 15 January 2011 10:07:14 am Jaiswal Dhaval Sudhirkumar wrote:
> Thanks for your
On Saturday 15 January 2011 10:07:14 am Jaiswal Dhaval Sudhirkumar wrote:
> Thanks for your support.
>
> We have power full HP servers with lots of CPU cores, I/O bandwidth and
> memory too.
>
> Actually I will give you the environment details, which will help you to
> understand.
>
> It is a huge
houghts/comments/help from experts.
--
Thanks & Regards
Dhaval Jaiswal
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of John R Pierce
Sent: Sat 1/15/2011 12:23 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] HA solution
On 01/14/11 9:4
On 01/14/11 9:47 PM, Jaiswal Dhaval Sudhirkumar wrote:
Hi,
I am looking for active-active clustering solution.
best of luck.active-active is fraught with complex hard-to-solve
problems.
I have one SAN box and two separate NODES, where I need to create
active-active cluster. My data
On January 14, 2011, "Jaiswal Dhaval Sudhirkumar"
wrote:
> Hi,
>
> I am looking for active-active clustering solution.
>
> I have one SAN box and two separate NODES, where I need to create
> active-active cluster. My data directory would be one and mounted to the
> SAN box for both the nodes. (
cr...@postnewspapers.com.au (Craig Ringer) writes:
> OpenLDAP is a pretty solid LDAP server these days, and I highly
> recommend it for use as an authentication database. By default it uses
> Berkeley DB as a backend, which is quite acceptable with newer versions
> of Berkeley DB that provide decen
On 24/06/10 17:27, Michelle Konzack wrote:
> in my enterprise I have an Intranet-Server with NFSv4, Courier, Apache
> and PostgreSQL and if this Server goes down, nothing will work anymore.
>
> OK, I replicate the WHOLE server all 6 hours, but my PostgreSQL give me
> a bunch of headache, becas
On Wed, Jun 18, 2008 at 10:36 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> . . . SQL permissions should be all you need.
>
> -Doug
~
What about the security implications? Is the J2EE server enough to
control access to the DB?
~
Java does not allow for buffer overruns and such hacking venues,
On Wed, Jun 18, 2008 at 8:44 PM, Albretch Mueller <[EMAIL PROTECTED]> wrote:
> ~
> I am developing a J2EE application that needs for users to only read
> DB tables. All queries are select ones, no updates, no inserts, no
> deletes for web users, so I keep this ro DB tables in certain
> partitions
Andrew Sullivan wrote:
On Mon, Dec 03, 2007 at 04:16:04PM +0100, Pascal Cohen wrote:
needs fast connections like fiber channels ? What is the impact on I/O
and general DB perfs ? - Sorry if my question is stupid - not an expert
on such things.
And I suppose it is not very cheap ;)
We
On Mon, Dec 03, 2007 at 04:16:04PM +0100, Pascal Cohen wrote:
> needs fast connections like fiber channels ? What is the impact on I/O
> and general DB perfs ? - Sorry if my question is stupid - not an expert
> on such things.
> And I suppose it is not very cheap ;)
Well, if you think you're goi
Andrew Sullivan wrote:
On Mon, Dec 03, 2007 at 09:57:30AM +0100, Pascal Cohen wrote:
What kind of hardware solutions do you know ? - I will look on my own
what I can find.
Have a look at the discussion in the 8.3 manual, about shared disk and block
level replication:
http://w
On Mon, Dec 03, 2007 at 09:57:30AM +0100, Pascal Cohen wrote:
> >
> What kind of hardware solutions do you know ? - I will look on my own
> what I can find.
Have a look at the discussion in the 8.3 manual, about shared disk and block
level replication:
http://www.postgresql.org/docs/8.3/static
On Mon, Dec 03, 2007 at 09:16:40AM +0100, Pascal Cohen wrote:
* For High-availability, I mainly studied PgPool and Log-shipping (and
in fact forgot Slony).
Until now I feel more comfortable with Log-shipping because it seems
safer (I am not sure I can't get some problems with sequences and
curr
On Mon, Dec 03, 2007 at 09:16:40AM +0100, Pascal Cohen wrote:
>
> * For High-availability, I mainly studied PgPool and Log-shipping (and
> in fact forgot Slony).
> Until now I feel more comfortable with Log-shipping because it seems
> safer (I am not sure I can't get some problems with sequences
On Fri, Nov 30, 2007 at 10:30:47PM +0100, Pascal Cohen wrote:
I am facing a probably very common problem. I made a search in the
recent archives and could find many posts related to my issue. But I did
not get exactly "the answer" to my question.
No, and I doubt you will.
I don't
On Fri, Nov 30, 2007 at 10:30:47PM +0100, Pascal Cohen wrote:
> I am facing a probably very common problem. I made a search in the
> recent archives and could find many posts related to my issue. But I did
> not get exactly "the answer" to my question.
No, and I doubt you will.
> But I don't kn
By the way I found also another tool called CyberCluster that will
probably not make my choice easier ;)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I will have to look into slony.. not much into db admin yet...
OK.. so
1. lets stick with complete duplicates in each region
identical
2. what opensource/free rdbms are there that can do this better?
Hmm got an answer from Ben but didnt see my post on the list...
B
Single master point subsets wasn't the plan but is doable. Each
geographic region should have a local read copy.
Ben wrote:
> Are those geographical copies, or geographical subsets? Multi-master
> replication is hard with postgres (read: probably not going to happen)
> but if you can partition yo
Are those geographical copies, or geographical subsets? Multi-master
replication is hard with postgres (read: probably not going to happen) but
if you can partition your data up so that you have one writer for a
subset of records, that could work quite well. Especially if you have rich
clients
45 matches
Mail list logo
