Metadata-Version: 2.0
Name: pymysql-split-tool
Version: 0.5.3
Summary: mysql spliting/sharding tools
Home-page: https://github.com/echoma/pymysql_split_tool
Author: Echo Ma
Author-email: fatmck@163.com
License: Apache 2.0
Keywords: mysql spliting or sharding tools
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Topic :: Database
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Requires-Dist: pymysql

**What is this?**


Mysql query will become slow when table contains millions of rows. A simple way of solving this probolem is spliting the big table into small ones. We use some method to decide which table each row should be moved into. A widely used method is "modulus", e.g. group rows by [ID mod 100]. This tool will help you to do this job easily.


**Features**

* Move records from one table to another(or other) table(s) according to user specified rules.
* Dynamically create new tables during moving.
* Move records between different mysql servers.
* Check data integrity of the new tables.
* For records who have been moved to new tables, remove them from source table.
* Using it as a python module which means dynamically changing the behavior.

