Master/Master Replication with SQL Replication on both nodes?

[Michael McRorey]

We are running RavenDB version #30037 on Windows 2012 R2.  We have Master/Master Replication setup as well as SQL Replication.

The question I have is, do we setup the SQL Replication on both nodes?  I would assume yes, because if one master is down, then there would be no SQL Replication at all.  I just wanted to make sure that if both are running, they aren't both submitting SQL inserts about the same data.

[Oren Eini (Ayende Rahien)]

You cannot set it up on both nodes, no.

The typical setup is that the secondary node is the one replication to SQL.

Note that if the secondary is down, it will catch up (and replicate to SQL) when it is up.

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

On Thu, Apr 28, 2016 at 3:53 PM, Michael McRorey <mike.m...@gmail.com> wrote:

We are running RavenDB version #30037 on Windows 2012 R2.  We have Master/Master Replication setup as well as SQL Replication.

The question I have is, do we setup the SQL Replication on both nodes?  I would assume yes, because if one master is down, then there would be no SQL Replication at all.  I just wanted to make sure that if both are running, they aren't both submitting SQL inserts about the same data.

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Oren Eini (Ayende Rahien)]

Technically speaking, both of them _can_ write to the same db, and since they are running in transactions, it will have the same end result, but that will be double the work for SQL.

And I'm not sure if the isolation level on the db will allow this interleaving or not.

[Michael McRorey]

Thank you very much.  This has helped me decide on the next step.