[Article Contribution] Welcome to Leave Your Article Link Here

[terrymanu]

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]

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

[CharlesMaster]

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

[saaavsaaa]

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

[zongtanghu]

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

[zongtanghu]

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

[pkaq]

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

[zhaojinchao95]

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

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

[feelwing1314]

借助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]

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

[tswstarplanet]

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

[manheiba]

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

[yinjihuan]

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]

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]

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

[wgy8283335]

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

[lzn-black]

shardingsphere 实践笔记

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

[JiekerTime]

SharidngSphere JDBC（5.0.0 alpha）部分的学习笔记与各种方式整合的examples。值得注意的是，每个模块都带有详细的注解，并且使用了三种不同的配置方式：（yaml、properties、原生API）。欢迎相互讨论，共同进步。链接地址

SharidngSphere JDBC (5.0.0 alpha) part of the study notes and examples integrated in various ways. It is worth noting that each module has detailed annotations and uses three different configuration methods: (yaml, properties, native API). Welcome to discuss with each other and make progress together.link address

[dafanzhi]

Enhancer + ShardingSphere 超快速实现分布式应用开发：
https://forum.wuyuan.io/plate/qa/topic/5fdafe9c856fee309115a498

[wuwenrui]

ShardingSphere-Proxy搭建过程

[tristaZero]

Hi @wuwenrui @dafanzhi @JiekerTime @lzn-black @xuup

Thanks for your blogs to help users learn more about Apache ShardingSphere.
Have a good day.

[2892824942]

• ShardingSphere应用专题–4.1.1版本–章节导航（一）
• ShardingSphere应用专题--常见数据库架构的演进（二）
• ShardingSphere应用专题--4.1.1版本--版本介绍及功能点汇总（三）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC环境搭建（四）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC读写分离（五）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC分库分表（六）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC读写分离+分库分表（七）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC应用注意点（八）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC 字段加密之新业务加密（九）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC 字段加密之已上线业务加密（十）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC 字段加密之自定义加密策略（十一）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC Hint路由（十二）（TODO）
• ShardingSphere应用专题--4.1.1版本--Sharding-JDBC 分布式主键-LEAF主键（十三）（TODO）
• ShardingSphere应用专题--4.1.1版本--服务治理（十四）
• ShardingSphere应用专题–4.1.1版本–Sharding-UI的使用（十五）
• ShardingSphere应用专题–4.1.1版本–Sharding-Proxy的使用（十六）
• ShardingSphere应用专题–4.1.1版本–Sharding-Scaling实现弹性伸缩（十七）

[tristaZero]

Hi @2892824942 Cool! Thanks for your contribution to help more users have a deeper understanding about this wonderful project.

[Samhom]

Hi @wuwenrui @dafanzhi @JiekerTime @lzn-black @xuup

Thanks for your blogs to help users learn more about Apache ShardingSphere.
Have a

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

hello trista! are there any recent developments on sidecar on moss, or a more foreword view?

[tristaZero]

Hi @Samhom Yep, we are recruiting people who are interested at this one.

[JooKS-me]

• ShardingSphere-Agent插件机制梳理（Sort out ShardingSphere-Agent plugin mechanism）

[trycache-npe-lab]

To handle error caused by column name is ‘‘ of SQL query statement in Sharding-JDBC 4.1.1

Solution for 4.1.1

https://blog.csdn.net/u014698745/article/details/119174882

[tristaZero]

@trycache0828 I saw your post. If possible, could you consider checking whether it still exists on the master branch and fixing it? Therefore what you wrote will become a valuable part of this community. Look forwards to your PR and reply. Have a nice day.

[trycache-npe-lab]

@trycache0828 I saw your post. If possible, could you consider checking whether it still exists on the master branch and fixing it? Therefore what you wrote will become a valuable part of this community. Look forwards to your PR and reply. Have a nice day.

This problem has been solved in the latest version 5.0.0-beta,but the 4.1.1 version I use in my project.I just provide a solution. there may be a better solution in version 4.1.1 to fix it.

[fengzhenbing]

• Shardingsphere（5.0.0.beta）源码学习-总览
• Shardingsphere（5.0.0.beta）源码学习-元数据上下文

[tristaZero]

Hi cool!

[linghengqian]

• Invited by Springboot how to set acutualDataNodes dynamically #21503, I made a Chinese article. The blog post 潘多拉之匣手记--以 Java API 模拟部分 RDL DistSQL 观 ContextManager 在 ShardingSphere V5 生命周期的熵增 is located at https://www.yuque.com/linghengqian/meve2v/cgi5en , introducing some shallow logic of DistSQL RDL through the transformation of ShardingSphere JDBC API. 🦔