You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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")
);
it will be better if this could be resolved from the ShardingSphere core
The text was updated successfully, but these errors were encountered:
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.
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 schemainformation_schema
in MySQL.currently we have following steps to resolve this situation :
it will be better if this could be resolved from the ShardingSphere core
The text was updated successfully, but these errors were encountered: