[MXS-188] Oplog to binlog conversion Created: 2015-06-11  Updated: 2016-10-17  Resolved: 2016-10-17

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None


 Description   

MongoDB's oplog is kind of similar to MariaDB's binary log:

http://docs.mongodb.org/manual/core/replica-set-oplog/

At my last job, we had a project that needed to replicate from MongoDB
to PostgreSQL. To do that, we used a tool called mosql from Stripe
which does that by tailing the oplog and transforming the data to
something usable by Postgres:

https://github.com/stripe/mosql

I don't know how many of our users need to replicate from MongoDB to
MariaDB, but some product ideas are:

1.) A maxscale plugin that tails a MongoDB oplog and transforms and
stores the data in MariaDB.

2.) Some kind of oplog-to-binlog converter (could we also convert in
the other direction?).

3.) A storage engine that keeps tables automatically up-to-date by
tailing a MongoDB oplog.

By the way, the ruby gem that Stripe uses to tail the oplog is
licensed with an MIT license:

https://github.com/stripe/mongoriver



 Comments   
Comment by Johan Wikman [ 2016-10-17 ]

Please reopen or recreate when this feature will be or is close to be added to the readmap.

Generated at Thu Feb 08 03:57:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.