Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

MySQL to PostgreSQL replica and migration

Project description

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pg_ninja, version 2.0.0a1
Filename, size File type Python version Upload date Hashes
Filename, size pg_ninja-2.0.0a1.tar.gz (64.8 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

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