strongduanmu commented on issue #24642:
URL:
https://github.com/apache/shardingsphere/issues/24642#issuecomment-1471424308
After the pr merged, we can use following sql to register datasource for
system database, and then execute system table select statement.
```
USE information_schema;
REGISTER STORAGE UNIT information_schema (
URL="jdbc:mysql://127.0.0.1:3306/information_schema?clusterInstanceHostPattern=?.cluster-cpmlacsg9h47.rds.cn-northwest-1.amazonaws.com.cn",
USER="root",
PASSWORD="123456",
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000",
"connectionTimeoutMilliseconds"="30000")
);
USE mysql;
REGISTER STORAGE UNIT mysql (
URL="jdbc:mysql://127.0.0.1:3306/mysql?clusterInstanceHostPattern=?.cluster-cpmlacsg9h47.rds.cn-northwest-1.amazonaws.com.cn",
USER="root",
PASSWORD="123456",
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000",
"connectionTimeoutMilliseconds"="30000")
);
USE performance_schema;
REGISTER STORAGE UNIT performance_schema (
URL="jdbc:mysql://127.0.0.1:3306/performance_schema?clusterInstanceHostPattern=?.cluster-cpmlacsg9h47.rds.cn-northwest-1.amazonaws.com.cn",
USER="root",
PASSWORD="123456",
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000",
"connectionTimeoutMilliseconds"="30000")
);
USE sys;
REGISTER STORAGE UNIT sys (
URL="jdbc:mysql://127.0.0.1:3306/sys?clusterInstanceHostPattern=?.cluster-cpmlacsg9h47.rds.cn-northwest-1.amazonaws.com.cn",
USER="root",
PASSWORD="123456",
PROPERTIES("minPoolSize"="1","maxPoolSize"="20","idleTimeout"="60000",
"connectionTimeoutMilliseconds"="30000")
);
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
