terrymanu commented on issue #37501:
URL:
https://github.com/apache/shardingsphere/issues/37501#issuecomment-3690978987
Problem Understanding
- You’re using ShardingSphere-JDBC with ZooKeeper as the governance center
for Oracle encryption. You want to modify encryption rules and ask whether to
edit ZooKeeper nodes directly or use a ShardingSphere-provided interface (and
which languages are supported).
Problem Root Cause
- This is a usage misunderstanding: in governance mode, rule changes
should go through ShardingSphere DistSQL so the framework persists and
propagates them, rather than manual ZooKeeper edits.
Problem Analysis
- Governance mode stores rules in ZooKeeper, but the supported entry point
for creating/updating/dropping encryption rules is DistSQL (CREATE/ALTER/DROP
ENCRYPT RULE).
- DistSQL is SQL-based, so any client/language that can send SQL via
ShardingSphere-JDBC or ShardingSphere-Proxy can manage the rules; no extra
language-specific SDK is needed.
- Editing ZooKeeper nodes directly risks breaking format/consistency and
isn’t the recommended approach.
- Encrypt rule DistSQL syntax:
https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/encrypt-rule/
--
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]
