You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/11 06:12:09 UTC

[GitHub] [shardingsphere] strongduanmu opened a new issue, #21481: Supporting data source level heterogeneous database gateway

strongduanmu opened a new issue, #21481:
URL: https://github.com/apache/shardingsphere/issues/21481

   ## Feature Request
   
   ### Is your feature request related to a problem?
   
   No.
   
   ### Describe the feature you would like.
   
   Currently, in issue#17619, we have implemented basic heterogeneous database gateway feature. Users can use the MySQL protocol to access the backend PostgreSQL database. But it will require that the databases in the same logic database must be of the same type, otherwise an exception will be thrown. 
   
   In a real heterogeneous database scenario, the backend storage in the same logical database may be a mix of databases such as MySQL and PostgreSQL. Therefore, we need to implement heterogeneous support at the data source level, allowing users to mix different databases for storage.
   
   In order to achieve this goal, we first need to adjust the metadata to support the database type judgment at the data source level.
   
   ```java
   /**
    * ShardingSphere resources.
    */
   public final class ShardingSphereResources {
       
       private final Map<String, ShardingSphereResource> resources;
       ...
   }
   
   public final class ShardingSphereResource {
   
       private final DataSource dataSource;
   
       // 每一个 DataSource 对应一个 databaseType
       private final DatabaseType databaseType;
       
       @Getter(AccessLevel.NONE)
       private final DataSourceMetaData dataSourceMetaData;
   ```
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] TeslaCN commented on issue #21481: Supporting data source level heterogeneous database gateway

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21481:
URL: https://github.com/apache/shardingsphere/issues/21481#issuecomment-1333321751

   Hi @strongduanmu 
   Have we finished this?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #21481: Supporting data source level heterogeneous database gateway

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #21481:
URL: https://github.com/apache/shardingsphere/issues/21481#issuecomment-1333332891

   Basically completed, except for the first subtask, I will adjust the first subtask as a separate issue and complete it in the next version.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu closed issue #21481: Supporting data source level heterogeneous database gateway

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #21481: Supporting data source level heterogeneous database gateway
URL: https://github.com/apache/shardingsphere/issues/21481


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #21481: Supporting data source level heterogeneous database gateway

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #21481:
URL: https://github.com/apache/shardingsphere/issues/21481#issuecomment-1333339343

   All task has been finished, so I will close this issue.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org