Skip to main content
Pre-release

This release is a pre-release and may not be stable for production use.

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.

Release files for pg_ninja 2.0.0a1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pg_ninja 2.0.0a1
File Size Uploaded
pg_ninja-2.0.0a1.tar.gz 64.8 kB Details

Release files / pg_ninja-2.0.0a1.tar.gz

Download URL pg_ninja-2.0.0a1.tar.gz
Size 64.8 kB
Tags Source
SHA-256 checksum
How to use checksums
7a076610466a9915673681c55854e1971bb2c7f393fa0e687c9638f50d30d19e
BLAKE2b-256 checksum
How to use checksums
4b9ce739f9f8d961bf00ac25ced2ba5a93d61cbaaae6bac4bfad808c8c16ab57
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.11.0 pkginfo/1.4.2 requests/2.18.4 setuptools/28.8.0 requests-toolbelt/0.8.0 tqdm/4.24.0 CPython/3.6.4

Release history Release notifications | RSS feed

This release

2.0.0a1 This release

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page