search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.79k stars 6.7k forks source link

Welcome to leave your article link #650

Closed terrymanu closed 3 years ago

terrymanu commented 6 years ago

Hi the community,

This is our article collection and official channel list, which you can learn more about Apache ShardingSphere. Moreover, welcome your posts! We will consider including them into our collection and publish them on other mainstream media. 😉

This link will direct you to our article collection 👉 Resources

这里有Apache ShardingSphere的资源汇总，您可以在这里了解到我们各大平台的官方账号，及最新的文章汇总列表。欢迎你的关注，也欢迎你贡献有关ShardingSphere的博客文章。我们会从中挑选出有价值的文章，汇总到官方资源集或在其他主流媒体发布！ 😉

点击这里查看最新文章精选吧 👉文章精选

xunzhaotianhe commented 6 years ago

天河的博客 ：https://my.oschina.net/u/3775437/blog

CharlesMaster commented 6 years ago

Talk About A Snowflake Error 《从一次Snowflake异常说起》

saaavsaaa commented 6 years ago

也不算文章吧，跟着调试读代码的记录，有理解错的地方，还望指出，查询的执行过程，后续有不同的情况会继续往里补充的 https://saaavsaaa.github.io/aaa/SpringBoot_ShardingJdbc_Code_Load_Run_Query.html

zongtanghu commented 6 years ago

写了一篇ShardingJdbc的应用开发文章，基于的是1.X版本的，后面还将2.X版本的集成至SpringBoot工程中，该篇应用文章为：《记一次使用ShardingJdbc切分数据库表的SpringBoot工程实践》：https://mp.weixin.qq.com/s/GZHmenOIOd1LJnI50ZW1ag 如果对使用ShardingJDBC1.X版本集成至SpringBoot工程不甚了解的，欢迎探讨和交流

zongtanghu commented 6 years ago

再次写了一篇ShardingJdbc的应用开发文章，这篇侧重于实战（主要结合了业务来说的），https://mp.weixin.qq.com/s/lLct0qY_D82-Wh5zrkzWiQ，欢迎探讨和交流

pkaq commented 6 years ago

mybatis plus整合sharding-jdbc在基于spring boot的项目中的单库分表应用

zhaojinchao95 commented 5 years ago

I just wrote it down, and I'm going to update it

https://github.com/zjcnb/sharding-sphere

feelwing1314 commented 5 years ago

借助sharding-sphere实现类多租户设计，实现的需求如下： 商户tmall，taobao，aliyun等每一个商户操作的表完全一样，但是操作的库不一样，tmall商户操作的库是xxx_tmall，taobao商户操作的库是xxx_taobao，aliyun商户操作的库是xxx_aliyun，以此类推：

参考文章地址：https://mp.weixin.qq.com/s/X34qKPAs2aHQTvE_6VStiQ 对应源码地址：https://github.com/feelwing1314/shardingsphere-multitenancy

本文除实现这个需求外，还衍生了另一个需求：某个库内只有部分表会分表，其他表都不分表。分表的逻辑为tmall访问的表是tb_order_tmall，taobao访问的表是tb_order_taobao，aliyun访问的表是tb_order_aliyun，以此类推。。。

feelwing1314 commented 5 years ago

Sharding-Proxy实战：解救分表后痛苦的测试小姐姐（通过部署sharding-proxy，让测试的Navicat或者其他客户端工具连接sharding-proxy，从而实现像操作单表一样操作分库分表）： 文章地址：https://mp.weixin.qq.com/s/jszqDnwRKrNWyujQy80usw

tswstarplanet commented 5 years ago

Shardingshere-jdbc初体验（介绍使用Shardingsphere-jdbc的入门文章） https://blog.csdn.net/dbqb007/article/details/87556551

manheiba commented 5 years ago

Sharding Sphere3.0.0下的springboot+druid+分表配置 https://www.jianshu.com/p/075a9f21d538

yinjihuan commented 5 years ago

Sharding-JDBC:查询量大如何优化？(http://cxytiandi.com/blog/detail/36374) Sharding-JDBC:垂直拆分怎么做(http://cxytiandi.com/blog/detail/36379) Sharding-JDBC:单库分表的实现 (http://cxytiandi.com/blog/detail/36400)

huangjian888 commented 5 years ago

SpringBoot2.x 集成ShardingSphere+Seata+Mybatis-Plus+DruidDataSource文章 文章地址：https://www.jianshu.com/p/41ebdaf403c8 主要介绍在SpringBoot中： 1：ShardingSphere启动->参数装配->连接池原理分析->DataSource创建 2：SeataATShardingTransactionManager相关源码解析 3：ShardingSphere使用Seata的@GlobalTransactional原理分析和如何使用注解方案 4：ShardingSphere下使用Mybatis-Plus等 以及集成各个框架遇到的问题和分析处理结果

wgy8283335 commented 4 years ago

sharding-core-parse模块分析，主要包括：模块结构、主要逻辑流程、设计模式和设计原则。 https://wgy8283335.github.io/2019/09/30/sharding-core-parse/

wgy8283335 commented 4 years ago

https://wgy8283335.github.io/2019/10/18/sharding-core-preprocess/ https://wgy8283335.github.io/2019/10/15/sharding-core-route/，写了两篇分析源代码的文章

haetao commented 4 years ago

https://blog.csdn.net/qq_30087985/article/details/102659478 写了sharding-core的子模块依赖和SQL的执行流程

wgy8283335 commented 4 years ago

sharding-core-rewrite模块的分析文章。https://wgy8283335.github.io/2019/10/22/sharding-core-rewrite/

wgy8283335 commented 4 years ago

sharding-sql-tes模块的分析文章。https://wgy8283335.github.io/2019/10/27/sharding-sql-test/

wgy8283335 commented 4 years ago

sharding-core-entry模块的分析文章，https://wgy8283335.github.io/2019/10/26/sharding-core-entry/。 sharding-core-execute模块的分析文章，https://wgy8283335.github.io/2019/10/24/sharding-core-execute/。

jiang2015 commented 4 years ago

sharding-jdbc之ANTLR4 SQL解析: https://my.oschina.net/u/3180962/blog/3100218/print

wangbo911 commented 4 years ago

基于sharding-jdbc 3.0.0M1 -3.0.0M4版本的测试SQL支持情况和使用注意事项整理如下，可以作为参考。并整理了扫描全表和扫描目标表的情况： http://note.youdao.com/noteshare?id=d1de661fb191f6ee8e158c85cb4ad970

lengyul commented 4 years ago

shardingsphere4.0.0分表学习笔记记录：https://blog.csdn.net/qq_34808893/article/details/103993659

fengyunhe commented 4 years ago

Apache ShardingSphere Proxy 负载均衡小练习： https://www.firegod.cn/2020/04/apache-shardingsphere-proxy-%e6%90%ad%e5%bb%ba%e6%96%87%e6%a1%a3/

fengyunhe commented 4 years ago

Apache ShardingSphere Proxy 分库分表小练习：https://www.firegod.cn/2020/04/apache-shardingproxy-%e5%88%86%e5%ba%93%e5%88%86%e8%a1%a8%e5%b0%8f%e7%bb%83%e4%b9%a0/

fengyunhe commented 4 years ago

Apache ShardingSphere Sharding-jdbc 分布式事务小练习：https://www.firegod.cn/2020/04/apache-sharding-sphere-%e5%88%86%e5%b8%83%e5%bc%8f%e4%ba%8b%e5%8a%a1/

klboke commented 4 years ago

文章标题：《JPA项目多数据源模式整合sharding-jdbc实现数据脱敏》 文章链接：http://www.kailing.pub/article/index/arcid/279.html 解决问题：在需要加解密的地方走sharding-jdbc数据源代理，即使有sql兼容问题也不影响原有的其他业务

wubingting commented 4 years ago

文章汇总

已合并到第一个post

tomato-cc commented 4 years ago

Jfinal框架整合 ShardingSphere,实现分表功能和数据库脱敏功能： https://github.com/tomato-cc/Jfinal-Shrading-JDBC

terrymanu commented 4 years ago

Jfinal框架整合 ShardingSphere,实现分表功能和数据库脱敏功能： https://github.com/tomato-cc/Jfinal-Shrading-JDBC

@tomato-cc Cool, updated to the list

wenweibin commented 4 years ago

1.分库分表 vs NewSQL数据库 https://www.jianshu.com/p/9131edd8fd2c 2.OLTP场景数据分布式实践-设计篇 https://www.jianshu.com/p/2551f6bdd4f7 3.OLTP场景数据分布式实践- 技术篇 https://www.jianshu.com/p/fa7442443063

tomato-cc commented 4 years ago

1.分库分表vs NewSQL数据库https://www.jianshu.com/p/9131edd8fd2c 2.OLTP场景数据分布式实践-设计篇https://www.jianshu.com/p/2551f6bdd4f7 3.OLTP场景数据分布式实践-技术文章https://www.jianshu.com/p/fa7442443063

4.Jfinal框架整合ShardingSphere，实现分表功能和数据库脱敏功能https://blog.csdn.net/tomatocc/article/details/103065192

terrymanu commented 4 years ago

1.分库分表 vs NewSQL数据库 https://www.jianshu.com/p/9131edd8fd2c 2.OLTP场景数据分布式实践-设计篇 https://www.jianshu.com/p/2551f6bdd4f7 3.OLTP场景数据分布式实践- 技术篇 https://www.jianshu.com/p/fa7442443063

Thank you, collected

terrymanu commented 4 years ago

1.分库分表vs NewSQL数据库https://www.jianshu.com/p/9131edd8fd2c 2.OLTP场景数据分布式实践-设计篇https://www.jianshu.com/p/2551f6bdd4f7 3.OLTP场景数据分布式实践-技术文章https://www.jianshu.com/p/fa7442443063

4.Jfinal框架整合ShardingSphere，实现分表功能和数据库脱敏功能https://blog.csdn.net/tomatocc/article/details/103065192

Thank you, collected

automvc commented 4 years ago

更适合作为DB表主键的ID生成算法。 雪花算法生成的ID强依赖时间，若某个时间点没有生成ID，则会造成ID不连续；越长时间没用，ID号码跳跃越严重。 作为DB的表主键，连续的ID更加合适。 各种分布式全局唯一ID生成算法汇总大全(共12种): https://blog.csdn.net/abckingaa/article/details/104541889

jacksparrow414 commented 4 years ago

基于ShardingSphere官方接口，自定义加密策略的简单实现 博文地址

tristaZero commented 4 years ago

@automvc @jacksparrow414 Hi Thanks for your blogs. We will give them a look and consider putting into community articles collection. :)

wubingting commented 4 years ago

@automvc This article seems not to be related to ShardingSphere.

dudiao commented 4 years ago

sharding jdbc，集成多数据源（Mybatis）：https://mp.weixin.qq.com/s/LOcjg0lrV9ZbELBVWlTR2g

wubingting commented 4 years ago

@dudiao Hi Thanks for your sharing. We will give it a look.

qiaojiang2 commented 4 years ago

《ShardingJdbc分库分表实战案例解析（上） 》 https://mp.weixin.qq.com/s/ZewY9KyVBsWqB1Fu2hNbSg 《ShardingJdbc分库分表实战案例解析（下） 》 https://mp.weixin.qq.com/s/wpzfIxixiAmDXEYuxLoZGQ

tristaZero commented 4 years ago

Hi @qiaojiang2 Thanks for your sharding. I gave them a glance and they look great. :-) We will include them in our article collection.

yang-7777 commented 4 years ago

文章汇总

版本迭代

新闻快讯

活动讲座

社区之路

深度揭秘

进阶实践

原理分析

视频资源

音频资源

第三方项目整合

官方账号

wenweibin commented 4 years ago

从源码看ShardingSphere设计-总览篇 https://www.jianshu.com/p/d927ad6a1b3e

tristaZero commented 4 years ago

Hi @wenweibin Thanks for your post, and it gives me an analytical sense. :-)

@yang-7777 Please include this one, thx.

yang-7777 commented 4 years ago

从源码看ShardingSphere设计-解析引擎篇 https://www.jianshu.com/p/b22030d1af10 Author: @wenweibin Thank you for your contribution!

yang-7777 commented 3 years ago

从源码看ShardingSphere设计-改写引擎篇 https://www.jianshu.com/p/8939bd7c9a23?utm_campaign=hugo 从源码看ShardingSphere设计-执行引擎篇 https://www.jianshu.com/p/d13a889a4359 Author: @wenweibin

qinxiaojian1028 commented 3 years ago

sharding-proxy 能做集群吗？

tristaZero commented 3 years ago

@qinxiaojian1028 Yep, but this is not a right place for your question. A new issue is suggested.

xuup commented 3 years ago

Sharding-Jdbc水平分表和垂直分表使样例搭建 https://xuup727.com/archives/shading-jdbc

lzn-black commented 3 years ago

shardingsphere 实践笔记

https://blog.csdn.net/lzn51/category_10646146.html