Skip to main content

mysql spliting/sharding tools

Project description

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.

Check home page for usage and more infomation.

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pymysql_split_tool-0.5.6.tar.gz (8.5 kB view details)

Uploaded Source

Built Distribution

pymysql_split_tool-0.5.6-py2.py3-none-any.whl (12.2 kB view details)

Uploaded Python 2Python 3

File details

Details for the file pymysql_split_tool-0.5.6.tar.gz.

File metadata

  • Download URL: pymysql_split_tool-0.5.6.tar.gz
  • Upload date:
  • Size: 8.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.6.7

File hashes

Hashes for pymysql_split_tool-0.5.6.tar.gz
Algorithm Hash digest
SHA256 c7aa072c7b7c0bbfccc7aac80ad515f18c90d566a1081a5606dd3d924eb4cc5c
MD5 bf8eb191ceb4a9427aa4d96b2ce23371
BLAKE2b-256 02c46b480a640e79953bbacfdafafa662c4ae001678c26d75857591fe98fcff8

See more details on using hashes here.

File details

Details for the file pymysql_split_tool-0.5.6-py2.py3-none-any.whl.

File metadata

  • Download URL: pymysql_split_tool-0.5.6-py2.py3-none-any.whl
  • Upload date:
  • Size: 12.2 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.12.1 pkginfo/1.4.2 requests/2.20.1 setuptools/40.6.2 requests-toolbelt/0.8.0 tqdm/4.28.1 CPython/3.6.7

File hashes

Hashes for pymysql_split_tool-0.5.6-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 74d8d0fb3fae6beba54d93afa0c0b575ad4f4dfa9ef1656bf3c6241256ddbbea
MD5 a151ffa72c1d55532cc41d8ae73bdabd
BLAKE2b-256 fecce0065c3d7b9af928acd83be075553fdc609247db2573d47e62e395d33ebd

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page