pg_chameleon: MySQL to PostgreSQL Replication Tool
pg_chameleon is a powerful tool designed for replicating MySQL databases to PostgreSQL, leveraging Python 3 for efficient data handling. It supports multiple MySQL schemas and offers robust features for data integrity, monitoring, and error management during replication.
Features
Read and replicate from multiple MySQL schemas to a target PostgreSQL database.
Support for enumerated and binary data types, with basic DDL capabilities.
Automatic exclusion of tables generating errors, ensuring a conservative replication approach.
Possibility to refresh individual tables or schemas as needed.
Integration with Rollbar for enhanced error tracking and reporting.
Minimal locking during the initialization of the replica for transactional engines.
Support for geometrical data types, requiring PostGIS on the target PostgreSQL database.
Daemonized processes for efficient management of replication tasks.