6.12. Deploying MySQL to PostgreSQL Replication

Deployment of a replication to PostgreSQL service operates as follows:

  • 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 PostgreSQL using a standard JDBC driver by constructing PostgreSQL compatible SQL to insert, update and delete the target data.

Figure 6.13. Topologies: MySQL to PostgreSQL

Topologies: MySQL to PostgreSQL

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