Skip to main content
Help us improve PyPI by participating in user testing. All experience levels needed!

MySQL to PostgreSQL replica and obfuscation

Project description

pg_ninja is a tool for replicating and obfuscating the data in real time from MySQL to PostgreSQL, compatible with Python 2.7. 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.

Project details

Release history Release notifications

This version
History Node


Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page