MySQL to PostgreSQL replica and migration
Project description
pg_chameleon is a tool for replicating from MySQL to PostgreSQL compatible with Python 2.7 and 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_chameleon can pull the data from a cascading replica when the MySQL slave is configured with log-slave-updates.
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_chameleon can pull the data from a cascading replica when the MySQL slave is configured with log-slave-updates.
Release history Release notifications | RSS feed
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.1.tar.gz
(40.6 kB
view details)
File details
Details for the file pg_chameleon-1.1.tar.gz.
File metadata
- Download URL: pg_chameleon-1.1.tar.gz
- Upload date:
- Size: 40.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
458f46466755fffdfd2a8758f1ae4ace249c22039e7f45a09d1abcaff5c3c547
|
|
| MD5 |
f22dfd79c7903dfa8d8f473d2d0d10c6
|
|
| BLAKE2b-256 |
a5f355ee2049e25b2206c5b453bc52d861b807a800213e1405241b21d8276339
|
