Ayende @ Rahien

Hi!
My name is Oren Eini
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

, @ Q c

Posts: 18 | Comments: 82

filter by tags archive

RavenDB 2.1 Features: Robust SQL Replication

time to read 2 min | 241 words

We had the ability to replicate things to SQL for a long while. But I was never really happy with the implementation. It was awkward, hard to use/configure/setup and didn’t really give us a lot of options in general.

After we finished working on 2.0, I had some free time and used that to create the new SQL Replication bundle, which is much nicer.

Basically, we go from this guy:

image

To those guys:

image

image

And the fun part is that we no longer require to do this using indexing, or have to worry about connectivity issues. RavenDB will automatically handle disruptions in connectivity, and would heal rifts automatically.

But probably the best part is that this is how we define the transformation function between RavenDB and your RDBMS of choice:

image


Comments

Chris Marisic

Can we get auto schema generation and auto healing of schemas?

If a column doesn't exist and you get an exception on insert, I really believe RavenDB should automatically try to resolve that once and if it can't due to permissions then exhaust itself and bubble up.

I really can't think of any use case with replication where fail is preferable to fix the things.

It's also acceptable if the schema feature is Sql Server only. Possibly opt into.

Ayende Rahien

Chris, The code is here: https://github.com/ayende/ravendb/tree/2.01 Pull requests are always welcome.

Paulo Quicoli

Ayende,

does it work with any ado.net supported database?

Moti

Why are you buying bears? arent you scared they might tear up your living room?

tobi

That looks really flexible. It allows for nice, denormalized, calculated values which are never out-of-sync.

Daniel Schilling

I think you mean "eventually not-out-of-sync." ;)

Ayende Rahien

Paulo, Yes, it will work with any ADO.Net provider.

Jiggaboo

Ayende do you know of any good tutorials/books on RavenDB? I don't find documentation that much helpful :)

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

  1. The insidious cost of allocations - 3 hours from now
  2. Buffer allocation strategies: A possible solution - 3 days from now
  3. Buffer allocation strategies: Explaining the solution - 4 days from now
  4. Buffer allocation strategies: Bad usage patterns - 5 days from now
  5. The useless text book algorithms - 6 days from now

And 1 more posts are pending...

There are posts all the way to Sep 11, 2015

RECENT SERIES

  1. Find the bug (5):
    20 Apr 2011 - Why do I get a Null Reference Exception?
  2. Production postmortem (10):
    03 Sep 2015 - The industry at large
  3. What is new in RavenDB 3.5 (7):
    12 Aug 2015 - Monitoring support
  4. Career planning (6):
    24 Jul 2015 - The immortal choices aren't
View all series

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats