As the title says, we are attempting to keep our couchbase environment synched with a SQL database. Not the full database mind you.
There is crucial data with entry points both from couchbase and sql that absolutely need to be synched (in real time). We already have synching from SQL to couchbase on the data we need - using triggers (issh, but a contraint we have to work with). Synching from couchbase to SQL however seems to be more complicated as it is pwoering a website and multiple changes can happen to the data we want to keep synched. At the moment we are logging all these changes with AWS SQS so that we can synch the changes down to sql without risking performance losses at peak traffic times etc…
This obviously has the huge downside of creating synching conflicts (change takes a while to come down from couchbase - enough that it is RE-changed before the trigger fires and comes back up, creating an never-ending cycle of doom)
At this point doing it ‘by hand’ is becoming more of a headache than anything else. Does couchbase have any feature that can help with synching in general between a couchbase server and another NON-couchbase server?