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.

Changelog from 1.0-alpha.4

• changed not python files in package to work properly with system wide installations
• fixed issue with ALTER TABLE ADD CONSTRAINT
• add datetime.timedelta to json encoding exceptions
• added support for enum in ALTER TABLE MODIFY
• requires psycopg2 2.7 which installs without postgresql headers
• the write_batch function is now using the copy_expert in order to speedup the batch load. The fallback to inserts is still present.

Caveats

• ensure you are running the latest pip version. you can upgrade within your virtual env running pip install pip --upgrade