Skip to content
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

[Summer 2022] Nacos多数据源插件化建设 #8312

Closed
realJackSun opened this issue May 7, 2022 · 13 comments
Closed

[Summer 2022] Nacos多数据源插件化建设 #8312

realJackSun opened this issue May 7, 2022 · 13 comments
Labels
Milestone

Comments

@realJackSun
Copy link
Collaborator

realJackSun commented May 7, 2022

Background

The current configuration center module of Nacos is not perfect for the ability to access multiple data sources. With the growing voice of the community, we need to improve the plug-ins that support multiple data sources in Nacos. The existing SQL operations are abstracted from the SPI interface, and the implementation of Mysql is provided, and the existing SQL operations are transformed to support plug-in.

Target

Nacos configuration management includes many SQL statements, and currently only the implementation of the MySQL version is provided. This project is dedicated to building plug-ins that generate corresponding SQL for multiple data sources (including databases such as MySQL, Oracle, etc.).

Difficulty

Basic

Mentor

@li-xiao-shuang
644968328@qq.com

Output Requirements

  • Sort out the SQL operations of the Nacos configuration management module, and abstract a set of SPI interfaces that are easy to expand;
  • Convert existing configuration management SQL operations into pluggables using appropriate design patterns;
  • Provide sound design documentation and add unit tests;

Technical Requirements

  • Learn about SQL;
  • Familiar with Java;
  • Learn about Nacos;
  • Those who love open source, have perseverance, and have the ability to learn by themselves can ignore the above points;

背景

Nacos 目前的配置中心模块对于接入多数据源的能力是不完善的,随着社区的呼声越来越高,我们需要完善Nacos 支持多数据源的插件。将现有的 SQL 操作抽象出 SPI 接口,并提供Mysql 的实现,改造现有的 SQL 操作,让它支持插件化。

目标

Nacos配置管理中包括许多SQL语句,目前只提供了MySQL版本的实现。该项目致力于构建多数据源的相应SQL(包括MySQL、Oracle等数据库)生成的插件。

难度

基础

导师

@li-xiao-shuang
644968328@qq.com

产出要求

  • 梳理Nacos配置管理模块的SQL操作,抽象出一套易于扩展的SPI接口;
  • 使用合适的设计模式将现有的配置管理SQL操作转化为插件化;
  • 提供完善的设计文档,并添加单元测试;

能力要求

  • 了解 SQL;
  • 熟悉 Java;
  • 了解 Nacos;
  • 热爱开源、有毅力、有自学能力的人可以忽略以上几点;
@realJackSun realJackSun changed the title [Summer 2022] Multi-data source plug-in construction in Nacos. [Summer 2022] Nacos多数据源插件化建设 May 11, 2022
@The-Gamer-01
Copy link
Contributor

将现有的 SQL 操作抽象出 SPI 接口,现有的SQL操作指的是配置中心模块里面的源码中的SQL部分吗

@li-xiao-shuang
Copy link
Collaborator

将现有的 SQL 操作抽象出 SPI 接口,现有的SQL操作指的是配置中心模块里面的源码中的SQL部分吗

嗯 是的 可以先看配置中心模块的

@bodhili
Copy link

bodhili commented May 15, 2022

请问这个可以怎么参与呢?

@li-xiao-shuang
Copy link
Collaborator

请问这个可以怎么参与呢?

需要是在校生,如果是的话联系我就行

@The-Gamer-01
Copy link
Contributor

请问这个可以怎么参与呢?

去搜一下开源之夏,里面有详细介绍什么的,需要是在校生,申请参加的

@lrh15983478476
Copy link

我是在校大学生,可以参加该项目吗 @li-xiao-shuang

@li-xiao-shuang
Copy link
Collaborator

我是在校大学生,可以参加该项目吗 @li-xiao-shuang

可以的 你对多数据感兴趣?

@lrh15983478476
Copy link

我是在校大学生,可以参加该项目吗 @li-xiao-shuang

可以的 你对多数据感兴趣?

感兴趣,具体怎么参与呢?

@li-xiao-shuang
Copy link
Collaborator

我是在校大学生,可以参加该项目吗 @li-xiao-shuang

可以的 你对多数据感兴趣?

感兴趣,具体怎么参与呢?

参考 开源之夏官网 的指南 https://summer-ospp.ac.cn/,需要编写申请书,不明白的在我主页添加联系方式交流

@lrh15983478476
Copy link

我是在校大学生,可以参加该项目吗 @li-xiao-shuang

可以的 你对多数据感兴趣?

感兴趣,具体怎么参与呢?

参考 开源之夏官网 的指南 https://summer-ospp.ac.cn/,需要编写申请书,不明白的在我主页添加联系方式交流

项目的项目id怎么看呀?

@xueqizhang121
Copy link

请问这个建设目前建设完了么,有没有release或者rc可以使用

@wuchubuzai2018
Copy link
Contributor

一个B端工作的Java开发者路过,我的工作是BI行业,做过BI系统的多数据源,对Nacos支持多数据源感兴趣,可以参与开发吗

@The-Gamer-01
Copy link
Contributor

这个是一个比赛的issue,是专门给在校学生参加用的,暂时不面向其他的朋友;朋友你可以看看其他的issue的

The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 10, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 10, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 10, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 11, 2022
li-xiao-shuang pushed a commit that referenced this issue Sep 12, 2022
* [ISSUE #8312] Create ConfigInfoTagMapper, HisConfigInfoMapper and TenantInfoMapper.

* [ISSUE #8312] Add more mapper.

* [ISSUE #8312]Let mappers extend Mapper.
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 25, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 27, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Sep 29, 2022
li-xiao-shuang pushed a commit that referenced this issue Sep 30, 2022
* [ISSUE #8312]Finish the datasource plugin.

* [ISSUE #8312]Update derby PersistService impl.
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
* [ISSUE alibaba#8312] Create ConfigInfoTagMapper, HisConfigInfoMapper and TenantInfoMapper.

* [ISSUE alibaba#8312] Add more mapper.

* [ISSUE alibaba#8312]Let mappers extend Mapper.
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
* [ISSUE alibaba#8312]Update the mappers.

* [ISSUE alibaba#8312]Update derby mappers.
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
* [ISSUE alibaba#8312]Finish all mappers.

* [ISSUE alibaba#8312]Fix some bugs about mapper.
KomachiSion pushed a commit to KomachiSion/nacos that referenced this issue Oct 24, 2022
* [ISSUE alibaba#8312]Finish the datasource plugin.

* [ISSUE alibaba#8312]Update derby PersistService impl.
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
li-xiao-shuang pushed a commit that referenced this issue Oct 24, 2022
* [ISSUE #8312]Merge sql.

* [ISSUE #8312]Fix bugs.
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 24, 2022
li-xiao-shuang added a commit that referenced this issue Oct 25, 2022
* fix sql

* fix history sql

* fix clone sql

* fix beta sql
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 25, 2022
The-Gamer-01 added a commit to The-Gamer-01/nacos that referenced this issue Oct 25, 2022
@KomachiSion KomachiSion added this to the 2.2.0 milestone Oct 26, 2022
@KomachiSion KomachiSion added Summer and removed Summer labels Apr 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

8 participants