Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Welcome to leave your article link #650

Closed
terrymanu opened this issue Mar 18, 2018 · 62 comments
Closed

Welcome to leave your article link #650

terrymanu opened this issue Mar 18, 2018 · 62 comments

Comments

@terrymanu
Copy link
Member

terrymanu commented Mar 18, 2018

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
Copy link

@CharlesMaster
Copy link

CharlesMaster commented Mar 20, 2018

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

@saaavsaaa
Copy link
Contributor

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

@zongtanghu
Copy link

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

@zongtanghu
Copy link

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

@terrymanu terrymanu changed the title Welcome to leave link if you write some article for Sharding-JDBC(如果您写了关于Sharding-JDBC的文章,欢迎留下链接) May 14, 2018
@zhaojinchao95
Copy link
Contributor

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

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

@terrymanu terrymanu pinned this issue Apr 19, 2019
@terrymanu terrymanu changed the title Welcome to leave link if you write some article for Sharding-Sphere(如果您写了关于Sharding-Sphere的文章,欢迎留下链接) Apr 19, 2019
@terrymanu terrymanu changed the title Welcome to leave link of article you written for ShardingSphere(欢迎留下您写的关于ShardingSphere的文章链接) Apr 19, 2019
@terrymanu terrymanu changed the title Welcome to leave article link you written for ShardingSphere(欢迎留下关于ShardingSphere的文章链接) Apr 19, 2019
@terrymanu terrymanu changed the title Welcome to leave article link for ShardingSphere(欢迎留下关于ShardingSphere的文章链接) Apr 19, 2019
@KomachiSion KomachiSion unpinned this issue Apr 23, 2019
@terrymanu terrymanu pinned this issue Apr 23, 2019
@feelwing1314
Copy link

借助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
Copy link

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

@tswstarplanet
Copy link

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

@manheiba
Copy link

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

@yinjihuan
Copy link

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
Copy link
Contributor

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等
以及集成各个框架遇到的问题和分析处理结果

@apache apache deleted a comment from xiepenghui15750707754 Aug 27, 2019
@wgy8283335 wgy8283335 unpinned this issue Sep 30, 2019
@wgy8283335 wgy8283335 pinned this issue Sep 30, 2019
@wgy8283335
Copy link
Contributor

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

@haetao
Copy link
Contributor

haetao commented Oct 21, 2019

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

@wgy8283335
Copy link
Contributor

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

@tristaZero
Copy link
Contributor

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
Copy link
Contributor

yang-7777 commented Aug 28, 2020

文章汇总


版本迭代


新闻快讯


活动讲座


社区之路


深度揭秘


进阶实践


原理分析


视频资源


音频资源


第三方项目整合


官方账号

@apache apache deleted a comment from wubingting Aug 28, 2020
@wenweibin
Copy link
Contributor

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

@tristaZero
Copy link
Contributor

tristaZero commented Aug 29, 2020

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

@yang-7777 Please include this one, thx.

@yang-7777
Copy link
Contributor

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

@yang-7777
Copy link
Contributor

yang-7777 commented Sep 23, 2020

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

@qinxiaojian1028
Copy link

sharding-proxy 能做集群吗?

@tristaZero
Copy link
Contributor

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

@xuup
Copy link
Contributor

xuup commented Dec 8, 2020

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

@lzn-black
Copy link

lzn-black commented Dec 9, 2020

@JiekerTime
Copy link
Member

JiekerTime commented Jan 3, 2021

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
Copy link

dafanzhi commented Jan 6, 2021

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

@terrymanu terrymanu unpinned this issue Jan 19, 2021
@tristaZero
Copy link
Contributor

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

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

@tristaZero tristaZero pinned this issue Mar 18, 2021
@tristaZero
Copy link
Contributor

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

@Samhom
Copy link

Samhom commented Apr 22, 2021

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
Copy link
Contributor

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

@terrymanu terrymanu changed the title Welcome to leave your article link(欢迎留下关于ShardingSphere的文章链接) Jun 7, 2021
@trycache-npe-lab
Copy link

trycache-npe-lab commented Jul 28, 2021

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
Copy link
Contributor

@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
Copy link

@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.

@apache apache locked and limited conversation to collaborators Sep 7, 2021
@menghaoranss menghaoranss unpinned this issue Sep 7, 2021

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →