{ "info": { "author": "Transferwise LTD", "author_email": "info@transferwise.com", "bugtrack_url": null, "classifiers": [ "Environment :: Console", "Intended Audience :: Developers", "Intended Audience :: Information Technology", "Intended Audience :: System Administrators", "Natural Language :: English", "Operating System :: POSIX :: BSD", "Operating System :: POSIX :: Linux", "Programming Language :: Python", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Topic :: Database :: Database Engines/Servers", "Topic :: Other/Nonlisted Topic" ], "description": "pg_ninja is a tool for replicating from MySQL to PostgreSQL compatible with Python 3.3+.\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.\n\nThe tool supports real time obfuscation.", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://www.transferwise.com/", "keywords": "postgresql mysql replica migration database", "license": "Apache 2.0 License", "maintainer": "", "maintainer_email": "", "name": "pg_ninja", "package_url": "https://pypi.org/project/pg_ninja/", "platform": "linux", "project_url": "https://pypi.org/project/pg_ninja/", "project_urls": { "Homepage": "https://www.transferwise.com/" }, "release_url": "https://pypi.org/project/pg_ninja/2.0.0a1/", "requires_dist": null, "requires_python": ">=3.3", "summary": "MySQL to PostgreSQL replica and migration", "version": "2.0.0a1" }, "last_serial": 4119580, "releases": { "2.0.0a1": [ { "comment_text": "", "digests": { "md5": "948906f0da653496c4da4629564084e8", "sha256": "7a076610466a9915673681c55854e1971bb2c7f393fa0e687c9638f50d30d19e" }, "downloads": -1, "filename": "pg_ninja-2.0.0a1.tar.gz", "has_sig": false, "md5_digest": "948906f0da653496c4da4629564084e8", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.3", "size": 64805, "upload_time": "2018-07-27T14:03:09", "url": "https://files.pythonhosted.org/packages/4b/9c/e739f9f8d961bf00ac25ced2ba5a93d61cbaaae6bac4bfad808c8c16ab57/pg_ninja-2.0.0a1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "948906f0da653496c4da4629564084e8", "sha256": "7a076610466a9915673681c55854e1971bb2c7f393fa0e687c9638f50d30d19e" }, "downloads": -1, "filename": "pg_ninja-2.0.0a1.tar.gz", "has_sig": false, "md5_digest": "948906f0da653496c4da4629564084e8", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.3", "size": 64805, "upload_time": "2018-07-27T14:03:09", "url": "https://files.pythonhosted.org/packages/4b/9c/e739f9f8d961bf00ac25ced2ba5a93d61cbaaae6bac4bfad808c8c16ab57/pg_ninja-2.0.0a1.tar.gz" } ] }