Re: [Bucardo-general] doubts about target db? - Mailing list pgsql-general

From Periko Support
Subject Re: [Bucardo-general] doubts about target db?
Date
Msg-id CAK2yrTa+oEwc=0zf3R4mP-q=WS4d4MBosOoMCGrUyRNvrUtvEg@mail.gmail.com
Whole thread Raw
In response to Re: [Bucardo-general] doubts about target db?  (Rakesh Kumar <rakeshkumar464@outlook.com>)
List 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@outlook.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.
>


pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: [Bucardo-general] doubts about target db?
Next
From: Michael Paquier
Date:
Subject: Re: journaled FS and and WAL