5.3. Deploying MySQL to MongoDB Replication

Tungsten Replicator allows extraction of information from different database types and apply them to different types. This is possible because of the internal format used when reading the information and placing the data into the THL. Using row-based replication, the data is extracted from the MySQL binary log as column/value pairs, which can then be applied to other databases, including MongoDB.

Deployment of a replication to MongoDB service is slightly different, there are two parts to the process:

  • Service Alpha on the master extracts the information from the MySQL binary log into THL.

  • Service Alpha on the slave reads the information from the remote replicator as THL, and applies that to MongoDB.

Figure 5.2. Topologies: MySQL to MongoDB

Topologies: MySQL to MongoDB

Basic reformatting and restructuring of the data is performed by translating the structure extracted from one database in row format and restructuring for application in a different format. A filter, the ColumnNameFilter, is used to extract the column names against the extracted row-based information.

With the MongoDB applier, information is extracted from the source database using the row-format, column names and primary keys are identified, and translated to the BSON (Binary JSON) format supported by MongoDB. The fields in the source row are converted to the key/value pairs within the generated BSON. For example, the row:

The transfer operates as follows:

  1. Data is extracted from MySQL using the standard extractor, reading the row change data from the binlog.

  2. The Section 11.4.8, “ColumnName Filter” filter is used to extract column name information from the database. This enables the row-change information to be tagged with the corresponding column information. The data changes, and corresponding row names, are stored in the THL.

  3. The THL information is then applied to MongoDB using the MongoDB applier.

The two replication services can operate on the same machine, or they can be installed on two different machines.