terrymanu opened a new issue #8581: URL: https://github.com/apache/shardingsphere/issues/8581
The ShardingSphere-Proxy can support single database type which must keep consist with frontend database protocol and backend database only. For example, current ShardingSphere-Proxy can support `MySQL protocol + MySQL database` and `PostgreSQL protocol + PostgreSQL database`. We plan to add a new feature of `data gateway` which should support multiple backend databases. The `data gateway` can use one protocol and query different databases which related SQL dialect. For example, data gateway can support user use MySQL\PostgreSQL protocol to query MySQL, PostgreSQL, SQLServer and Oracle for now, and will support Hive, ClickHouse and other JDBC related drivers and dialects. One logic schema need to use same backend databases, different schemas can use different databases types. The tasks for this feature are: - [ ] Split frontend database type and backend database type - [ ] Add a configuration item for configure frontend database type - [ ] Check configured frontend database type and throw exception if necessary - [ ] Keep same frontend database type with backend if configuration absent - [ ] Recognize backend database type via driver ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
