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.
>