pg_ninja


Namepg_ninja JSON
Version v1.0-alpha1 PyPI version JSON
download
home_pagehttps://www.transferwise.com/
SummaryMySQL to PostgreSQL replica and obfuscation
upload_time
maintainerNone
docs_urlNone
authorTransferwise
requires_pythonNone
licenseUNKNOWN
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            pg_ninja is a tool for replicating and obfuscating the data in real time from MySQL to PostgreSQL, compatible with Python 2.7.
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.
            

Raw data

            {
    "_id": null,
    "maintainer": null,
    "docs_url": null,
    "requires_python": null,
    "maintainer_email": null,
    "cheesecake_code_kwalitee_id": null,
    "keywords": null,
    "author": "Transferwise",
    "home_page": "https://www.transferwise.com/",
    "download_url": "UNKNOWN",
    "platform": "linux",
    "version": "v1.0-alpha1",
    "cheesecake_documentation_id": null,
    "description": "pg_ninja is a tool for replicating and obfuscating the data in real time from MySQL to PostgreSQL, compatible with Python 2.7.\nThe system use the library mysql-replication to pull the row images from MySQL which are transformed into a jsonb object. \nA pl/pgsql function decodes the jsonb and replays the changes into the PostgreSQL database.\n\nThe tool requires an  initial replica setup which pulls the data from MySQL in read only mode. \nThis is done by the tool running FLUSH TABLE WITH READ LOCK;  .\n\npg_ninja can pull the data from a cascading replica when the MySQL slave is configured with log-slave-updates.",
    "lcname": "pg_ninja",
    "name": "pg_ninja",
    "github": false,
    "bugtrack_url": null,
    "license": "UNKNOWN",
    "summary": "MySQL to PostgreSQL replica and obfuscation",
    "split_keywords": [],
    "author_email": "info@transferwise.com",
    "urls": [],
    "cheesecake_installability_id": null
}
        
Elapsed time: 0.04590s