This maintenance release improves the support for spatial datatypes.
When postgis is installed on the target database then the spatial data types
geometrycollection are converted to
geometry and the data is replicated using the Well-Known Binary (WKB) Format. As the MySQL implementation for WKB is not standard pg_chameleon removes the first 4 bytes from the decoded binary data before sending it to PostgreSQL.
keep_existing_schema is set to
yes now drops and recreates indices, and primary keys during the
The foreign keys are dropped as well and recreated when the replica reaches the consistent status.
This way the
init_replica may complete successfully even when there are foreign keys in place and with the same speed of the usual
The setup.py now forces PyMySQL to version <0.10.0 because it breaks the python-mysql-replication library (issue #117).
Thanks to @porshkevich which fixed issue #115 by trimming the space from PK index name.
This release requires a replica catalogue upgrade, therefore is very important to follow the upgrade instructions provided below.
chameleon stop_all_replicas --config your_config
sch_chameleonwith pg_dump as a good measure.
pip install pg_chameleon --upgrade
chameleon upgrade_replica_schema --config your_config
If the upgrade procedure can't upgrade the replica catalogue because of running or errored replicas is it possible to reset the statuses by
using the command
chameleon enable_replica --source source_name.
If the catalogue upgrade is still not possible then you can downgrade pgchameleon to the previous version. Please note that you may need to install manually PyMySQL to fix the issue with the version 0.10.0.
pip install pg_chameleon==2.0.13
pip install "PyMySQL<0.10.0"