semvec/pypi-packages huggingface dataset:
pg_ninja 2.0.0a1
MySQL to PostgreSQL replica and migration
License: Apache 2.0 License
Requires Python: >=3.3
Keywords: postgresql mysql replica migration database

pg_ninja is a tool for replicating from MySQL to PostgreSQL compatible with Python 3.3+.
The system use the library mysql-replication to pull the row images from MySQL which are transformed into a jsonb object. 
A pl/pgsql function decodes the jsonb and replays the changes into the PostgreSQL database.

The tool requires an  initial replica setup which pulls the data from MySQL in read only mode. 
This is done by the tool running FLUSH TABLE WITH READ LOCK;  .

pg_ninja can pull the data from a cascading replica when the MySQL slave is configured with log-slave-updates.

The tool supports real time obfuscation.