Logical data replication from PostgreSQL to MySQL

Anastasiya Merenova

This is a Diploma Project provides a possibility to replicate data from PostgreSQL to MySQL database. But approach and IT architecture which Anastasiya selected is completely different like was described in another project.

By the way , this project is actual to apply in production or just make research for particular production IT architecture.

Anastasiya integrated a Message Broker (Apache Kafka) like an Event Bus which provides a few positive cases.

  • Message Broker is another storage can store data during some period of time (to fix something)
  • DataOps engineer can control throughput inside Message Broker by making some configuration changes. It means we can control high load for destination database.
  • …and finally, we can use Message Broker to integrate other sources / destinations

Leave a Reply