René's URL Explorer Experiment

Title: GitHub - li199773/Distributed-MySQL: MyCat+MySQL+Python MySQL分布式集群存储 · GitHub

Open Graph Title: GitHub - li199773/Distributed-MySQL: MyCat+MySQL+Python MySQL分布式集群存储

X Title: GitHub - li199773/Distributed-MySQL: MyCat+MySQL+Python MySQL分布式集群存储

Description: MyCat+MySQL+Python MySQL分布式集群存储. Contribute to li199773/Distributed-MySQL development by creating an account on GitHub.

Open Graph Description: MyCat+MySQL+Python MySQL分布式集群存储. Contribute to li199773/Distributed-MySQL development by creating an account on GitHub.

X Description: MyCat+MySQL+Python MySQL分布式集群存储. Contribute to li199773/Distributed-MySQL development by creating an account on GitHub.

Opengraph URL: https://github.com/li199773/Distributed-MySQL

X: @github

direct link

Domain: github.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:5c305299-17a1-883d-cb92-7504899a5e95
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	9AFC:1ED2:20FFF41:2FE28E2:6A4D19C1
html-safe-nonce	17f11a74907dfa75308666df427d3c19f56ae3c01c7754efd2f6f89fba1e2da4
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QUZDOjFFRDI6MjBGRkY0MToyRkUyOEUyOjZBNEQxOUMxIiwidmlzaXRvcl9pZCI6IjYwNDcxNjY2OTMwMDc3NTk4MDkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac	3062ea6df921ba9402420590a61bce4f35fe179814a929fd7a3d5a2dea2ea01d
hovercard-subject-tag	repository:446717736
github-keyboard-shortcuts	repository,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	//
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/li199773/Distributed-MySQL
twitter:image	https://opengraph.githubassets.com/7c23fa28fa8e51fad8a36a61bf912859af6a65ff0804095ff9381f0a31a80db3/li199773/Distributed-MySQL
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/7c23fa28fa8e51fad8a36a61bf912859af6a65ff0804095ff9381f0a31a80db3/li199773/Distributed-MySQL
og:image:alt	MyCat+MySQL+Python MySQL分布式集群存储. Contribute to li199773/Distributed-MySQL development by creating an account on GitHub.
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	bcb4661e6fb4fe8b394c51ea02ccdb2236d40dc59afc75a3bbba50bf6517134c
turbo-cache-control	no-cache
go-import	github.com/li199773/Distributed-MySQL git https://github.com/li199773/Distributed-MySQL.git
octolytics-dimension-user_id	60172996
octolytics-dimension-user_login	li199773
octolytics-dimension-repository_id	446717736
octolytics-dimension-repository_nwo	li199773/Distributed-MySQL
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	446717736
octolytics-dimension-repository_network_root_nwo	li199773/Distributed-MySQL
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	fb70bd3c4b2bec429781b65419e912c66e2d5581
ui-target	canary-1
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/li199773/Distributed-MySQL#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fli199773%2FDistributed-MySQL
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fli199773%2FDistributed-MySQL
Sign up	https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=li199773%2FDistributed-MySQL
Reload	https://github.com/li199773/Distributed-MySQL
Reload	https://github.com/li199773/Distributed-MySQL
Reload	https://github.com/li199773/Distributed-MySQL
li199773	https://github.com/li199773
Distributed-MySQL	https://github.com/li199773/Distributed-MySQL
Notifications	https://github.com/login?return_to=%2Fli199773%2FDistributed-MySQL
Fork 0	https://github.com/login?return_to=%2Fli199773%2FDistributed-MySQL
Star 5	https://github.com/login?return_to=%2Fli199773%2FDistributed-MySQL
Code	https://github.com/li199773/Distributed-MySQL
Issues 0	https://github.com/li199773/Distributed-MySQL/issues
Pull requests 0	https://github.com/li199773/Distributed-MySQL/pulls
Actions	https://github.com/li199773/Distributed-MySQL/actions
Projects	https://github.com/li199773/Distributed-MySQL/projects
Security and quality 0	https://github.com/li199773/Distributed-MySQL/security
Insights	https://github.com/li199773/Distributed-MySQL/pulse
Code	https://github.com/li199773/Distributed-MySQL
Issues	https://github.com/li199773/Distributed-MySQL/issues
Pull requests	https://github.com/li199773/Distributed-MySQL/pulls
Actions	https://github.com/li199773/Distributed-MySQL/actions
Projects	https://github.com/li199773/Distributed-MySQL/projects
Security and quality	https://github.com/li199773/Distributed-MySQL/security
Insights	https://github.com/li199773/Distributed-MySQL/pulse
	https://github.com/li199773/Distributed-MySQL
Branches	https://github.com/li199773/Distributed-MySQL/branches
Tags	https://github.com/li199773/Distributed-MySQL/tags
	https://github.com/li199773/Distributed-MySQL/branches
	https://github.com/li199773/Distributed-MySQL/tags
127 Commits	https://github.com/li199773/Distributed-MySQL/commits/main/
	https://github.com/li199773/Distributed-MySQL/commits/main/
01 MySQL分区	https://github.com/li199773/Distributed-MySQL/tree/main/01%20MySQL%E5%88%86%E5%8C%BA
01 MySQL分区	https://github.com/li199773/Distributed-MySQL/tree/main/01%20MySQL%E5%88%86%E5%8C%BA
02 MyCat	https://github.com/li199773/Distributed-MySQL/tree/main/02%20MyCat
02 MyCat	https://github.com/li199773/Distributed-MySQL/tree/main/02%20MyCat
03 主从复制	https://github.com/li199773/Distributed-MySQL/tree/main/03%20%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6
03 主从复制	https://github.com/li199773/Distributed-MySQL/tree/main/03%20%E4%B8%BB%E4%BB%8E%E5%A4%8D%E5%88%B6
04 读写分离	https://github.com/li199773/Distributed-MySQL/tree/main/04%20%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB
04 读写分离	https://github.com/li199773/Distributed-MySQL/tree/main/04%20%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB
05 日期分片	https://github.com/li199773/Distributed-MySQL/tree/main/05%20%E6%97%A5%E6%9C%9F%E5%88%86%E7%89%87
05 日期分片	https://github.com/li199773/Distributed-MySQL/tree/main/05%20%E6%97%A5%E6%9C%9F%E5%88%86%E7%89%87
06 分库分表	https://github.com/li199773/Distributed-MySQL/tree/main/06%20%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8
06 分库分表	https://github.com/li199773/Distributed-MySQL/tree/main/06%20%E5%88%86%E5%BA%93%E5%88%86%E8%A1%A8
07 全局序列	https://github.com/li199773/Distributed-MySQL/tree/main/07%20%E5%85%A8%E5%B1%80%E5%BA%8F%E5%88%97
07 全局序列	https://github.com/li199773/Distributed-MySQL/tree/main/07%20%E5%85%A8%E5%B1%80%E5%BA%8F%E5%88%97
08 定时脚本	https://github.com/li199773/Distributed-MySQL/tree/main/08%20%E5%AE%9A%E6%97%B6%E8%84%9A%E6%9C%AC
08 定时脚本	https://github.com/li199773/Distributed-MySQL/tree/main/08%20%E5%AE%9A%E6%97%B6%E8%84%9A%E6%9C%AC
09 Mycat-Web	https://github.com/li199773/Distributed-MySQL/tree/main/09%20Mycat-Web
09 Mycat-Web	https://github.com/li199773/Distributed-MySQL/tree/main/09%20Mycat-Web
10 项目总结报告	https://github.com/li199773/Distributed-MySQL/tree/main/10%20%E9%A1%B9%E7%9B%AE%E6%80%BB%E7%BB%93%E6%8A%A5%E5%91%8A
10 项目总结报告	https://github.com/li199773/Distributed-MySQL/tree/main/10%20%E9%A1%B9%E7%9B%AE%E6%80%BB%E7%BB%93%E6%8A%A5%E5%91%8A
README.md	https://github.com/li199773/Distributed-MySQL/blob/main/README.md
README.md	https://github.com/li199773/Distributed-MySQL/blob/main/README.md
README	https://github.com/li199773/Distributed-MySQL
	https://github.com/li199773/Distributed-MySQL#mysql--python
	https://github.com/li199773/Distributed-MySQL#01-mysql分区将数据分成几个表格在数据库还是显示一个表格不是真正的逻辑物理分表
	https://github.com/li199773/Distributed-MySQL#1分区的分类
	https://github.com/li199773/Distributed-MySQL#2分区的修改和删除
	https://github.com/li199773/Distributed-MySQL#02-mycat
	https://github.com/li199773/Distributed-MySQL#为什么使用mycat
	https://github.com/li199773/Distributed-MySQL#mycat基于cobar进行二次开发
	https://github.com/li199773/Distributed-MySQL#mycat作用
	https://github.com/li199773/Distributed-MySQL#mycat配置详细信息见03-mycat配置py文件
	https://github.com/li199773/Distributed-MySQL#03-主从复制
	https://github.com/li199773/Distributed-MySQL#原理
	https://github.com/li199773/Distributed-MySQL#1master配置
	https://github.com/li199773/Distributed-MySQL#2slave配置
	https://github.com/li199773/Distributed-MySQL#3master2slave2同理修改id分别为34双主从复制情况下
	https://github.com/li199773/Distributed-MySQL#4重启-mysql-服务
	https://github.com/li199773/Distributed-MySQL#5两台主机上建立帐户并授权-slave用户
	https://github.com/li199773/Distributed-MySQL#6在从机上配置需要复制的主机
	https://github.com/li199773/Distributed-MySQL#04-读写分离
	https://github.com/li199773/Distributed-MySQL#不用针对每个表进行配置只需要在schemaxml中的元素上增加datanodedefaultdn属性并配置此datanode对应的真实物理数据库的database然后datahost开启读写分离功能即可配置实例详情见write-readpy文件
	https://github.com/li199773/Distributed-MySQL#05-日期分片
	https://github.com/li199773/Distributed-MySQL#常用的分片规则
	https://github.com/li199773/Distributed-MySQL#项目主要采用按日期天分片详细分片规则见sharding_by_datepy
	https://github.com/li199773/Distributed-MySQL#06-分库分表
	https://github.com/li199773/Distributed-MySQL#1垂直分库一个数据库由很多表的构成每个表对应着不同的业务垂直切分是指按照业务将表进行分类分布到不同的数据库上面这样也就将数据或者说压力分担到不同的库上面详情配置见01-垂直分库py
	https://github.com/li199773/Distributed-MySQL#2水平拆分相对于垂直拆分水平拆分不是将表做分类而是按照某个字段的某种规则来分散到多个库之中每个表中包含一部分数据简单来说可以将数据的水平切分理解为是按照数据行的切分将表中的某些行切分到一个数据库而另外的某些行又切分到其他的数据库中详情配置见02-水平拆分py
	https://github.com/li199773/Distributed-MySQL#07-全局序列
	https://github.com/li199773/Distributed-MySQL#在实现分库分表的情况下数据库自增主键已无法保证自增主键的全局唯一为此mycat-提供了全局-sequence并且提供了包含本地配置和数据库配置等多种实现方式
	https://github.com/li199773/Distributed-MySQL#操作实例见02-操作步骤py
	https://github.com/li199773/Distributed-MySQL#08-定时脚本
	https://github.com/li199773/Distributed-MySQL#更新完毕全局序列必须要重新启动mycat才可以生效每天定时开始执行脚本判断主程序是否在运行主程序在运行则等待主程序运行完毕在执行主程序不在执行则开始运行脚本重启mycat
	https://github.com/li199773/Distributed-MySQL#操作实例见01-restart_scriptpy
	https://github.com/li199773/Distributed-MySQL#09-mycat-web
	https://github.com/li199773/Distributed-MySQL#简介mycat-web是mycat可视化运维的管理和监控平台弥补了mycat在监控上的空白帮mycat分担统计任务和配置管理任务mycat-web引入了zookeeper作为配置中心可以管理多个节点
	https://github.com/li199773/Distributed-MySQL#10-项目总结报告
	https://github.com/li199773/Distributed-MySQL#项目为smtp-pop3-imap-邮件解析-mysql-分布式存储
	https://github.com/li199773/Distributed-MySQL#1pcapng文件解析smtp-pop3-imap-三种邮件协议
	https://github.com/li199773/Distributed-MySQL#2mysql分布式存储
mysql	https://github.com/topics/mysql
linux	https://github.com/topics/linux
python3	https://github.com/topics/python3
mycat	https://github.com/topics/mycat
dpkt	https://github.com/topics/dpkt
threadpoolexecutor	https://github.com/topics/threadpoolexecutor
Readme	https://github.com/li199773/Distributed-MySQL#readme-ov-file
Please reload this page	https://github.com/li199773/Distributed-MySQL
Activity	https://github.com/li199773/Distributed-MySQL/activity
0 forks	https://github.com/li199773/Distributed-MySQL/forks
Report repository	https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fli199773%2FDistributed-MySQL&report=li199773+%28user%29
Releases	https://github.com/li199773/Distributed-MySQL/releases
Packages 0	https://github.com/users/li199773/packages?repo_name=Distributed-MySQL
Please reload this page	https://github.com/li199773/Distributed-MySQL
Contributors	https://github.com/li199773/Distributed-MySQL/graphs/contributors
Please reload this page	https://github.com/li199773/Distributed-MySQL
Python 100.0%	https://github.com/li199773/Distributed-MySQL/search?l=python
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.