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
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
Reading on psql doc cluster, exist different solutions like
postgresql-xl, pgpool which are more for clustering.
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
hi, peoples!
Have a way to distribute connections for postgres master x master?
I need something... When i connect my apps, direct thia connections only
one IP, but this ip, automaticaly resolve one of my two masters servers
Example: app <---> ip 10.1.1.1
This 10.1.1.1 see my two masters in
>
> 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
d for reporting and
not failover for us.
From: Tim Uckun
To: pgsql-general
Sent: Tuesday, 17 January 2012 10:34 AM
Subject: [GENERAL] HA options
Hey Guys.
It's been a while since I looked into this and it seems like new
options have cropped up for postg
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 any scalability gains would be more than welcome. All
the servers will
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. (
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. (There will be one sharable data directory for both the nodes) So the
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
Hello *,
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, becasue I use "pam-pgsql" for authentication.
Wh
http://ha-jdbc.sourceforge.net/
Is anyone using this? I'm considering it to handle failover for my
Active/Passive cluster.
(using Postgres + SLES + heartbeat)
Thanks
Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
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
~
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 which I mount as ro
~
For performance reasons I keet the DB in the same box as the ser
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
Hello
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.
How can I chose among the different existing tools to enable High
Availability and Load-balancing/Repli
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
I have some web applications and rich clients that need to
geographically localized copies (for network latency reasons) of a
database (East Coast, Central, West Coast and Japan) These will be
mostly read however there will be full CRUD activities going on. I
think this means that there will be a
54 matches
Mail list logo
