[GitHub] [shardingsphere] taojintianxia opened a new issue, #22007: Add the actual schema mapping to information_schema

[GitBox <gi...@apache.org>]

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

   Hi, there
   
   for some IDE or data transmation tool usage, it will read the data of tables in `information_schema`, and now the inforamtion_schema in ShardingSphere is an empty logical schema. please add a mapping from actual schema `information_schema` in MySQL.
   
   currently we have following steps to resolve this situation :
   ```
   use some_other_schema;
   
   drop database information_schema;
   
   create database information_schema;
   
   use information_schema;
   
   add resource ds_0 (
    URL="jdbc:mysql://datasource-1.test:3306/information_schema?serverTimezone=UTC&useSSL=false",
    user=TEST_USER,
    password=PASSWORD,
    PROPERTIES("maximumPoolSize"=50,"idleTimeout"="6000")
   );
   ``` 


-- 
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] tuichenchuxin commented on issue #22007: Add the actual schema mapping to information_schema

[GitBox <gi...@apache.org>]

tuichenchuxin commented on issue #22007:
URL: https://github.com/apache/shardingsphere/issues/22007#issuecomment-1306791376

   Recently, shardingSphere have mocked information_schema's tables struct, but there's no data.
   I think it's better to collect data for information_schema, and save to zk node -> sys_data. 
   But there's huge data that's need to be collected and decorated.
   Mapping to information_schema will not be a final solution. So whether to do this, we still need to discuss it together.


-- 
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] taojintianxia commented on issue #22007: Add the actual schema mapping to information_schema

[GitBox <gi...@apache.org>]

taojintianxia commented on issue #22007:
URL: https://github.com/apache/shardingsphere/issues/22007#issuecomment-1306916263

   alll right, please let me know if there is a solution. thanks


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