Skip to main content

MySQL to PostgreSQL replica

Project description

Pg_chameleon is a replication tool from MySQL to PostgreSQL developed in Python 2.7 and Python 3.3+ The system relies on the mysql-replication library to pull the changes from MySQL and covert them into a jsonb object. A plpgsql 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; .

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

Project details


Download files

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

Source Distribution

pg_chameleon-1.0a4.tar.gz (30.0 kB view details)

Uploaded Source

File details

Details for the file pg_chameleon-1.0a4.tar.gz.

File metadata

  • Download URL: pg_chameleon-1.0a4.tar.gz
  • Upload date:
  • Size: 30.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for pg_chameleon-1.0a4.tar.gz
Algorithm Hash digest
SHA256 1d646f897a7c73dd359da936fb86bfaf79aa33b65e74d68b891a868c06e55b76
MD5 93faf517059f910967dd4c28224f6232
BLAKE2b-256 4de141cc91fe946ae862d9618e6970f3bd366cde348321da8d1d4d88e17c8d13

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page