From: | Periko Support <pheriko(dot)support(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [Bucardo-general] doubts about target db? |
Date: | 2016-10-14 16:20:03 |
Message-ID: | CAK2yrTa+oEwc=0zf3R4mP-q=WS4d4MBosOoMCGrUyRNvrUtvEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Rakesh.
Let me explain my reason to have a replica server.
We run odoo server 7.x with ubuntu 14.
But we are working on a BI system right now(Pentaho), them we want to
run those heavy reports on the replica and let the current production
system on the master.
This is why I was thinking on a M-S setup.
Why don't u use PSQL built in replica tools? We try but exist a lets
behavior of odoo that if u run a report he try to update some internal
tables and won't allow us to run our reports in the slave(streaming
replica).
Because the slave is in a ReadOnly mode.
Them we start searching for a solution and we came to bucardo.
Now, the BI server will just for that.
What setup guys recommend, M-M or M-S for my solution?
Now let me think in the future, I can think on a M-M-S, If the
master-1 fails we have the 2nd and nothing happen right and our
current S will continue running, bucardo let me do this?
Now let me back in the setup of bucardo, we u are in the setup, how
can I told to bucardo is a M-M or M-S?
Sorry for to much question, I want to understand all this and make my
own manual, I see a lot of settings of bucardo in the man page but not
to much examples.
youtube and google are giving me a lot info.
Thanks for your time and help!!!
On Fri, Oct 14, 2016 at 8:54 AM, Rakesh Kumar
<rakeshkumar464(at)outlook(dot)com> wrote:
>>Other thing, with bucardo what is the difference between in a
>>master-master replica vs master-slave, at the end in both ways the
>>user has a 2nd DB with R/W permission?
>
> I think in a M-M mode, updates from both dbs will be replicated to the other db.
> In other words they will be eventually consistent.
> In a M-S mode, even though Slaves can be updated by the app, its updates will
> not be replicated back to the master. While updates from M->S will happen all
> the time, updates from S will not go to M.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-10-15 05:52:04 | Re: journaled FS and and WAL |
Previous Message | Rakesh Kumar | 2016-10-14 15:54:56 | Re: [Bucardo-general] doubts about target db? |