[I] How to Add Encryption Rules to the ZooKeeper Governance Center [shardingsphere]

["dangmingyang (via GitHub)" <gi...@apache.org>]

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

   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   I am using ShardingSphere-JDBC to connect to the ZooKeeper governance center for data encryption of the Oracle database. When I need to modify the encryption rules, how should I operate? Do I need to connect to ZooKeeper via the ZooKeeper client, then re-create new encryption rules according to the rule storage path and data format of ShardingSphere in ZooKeeper? Has ShardingSphere encapsulated the corresponding interfaces? If yes, which programming languages are supported?


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

Re: [I] How to Add Encryption Rules to the ZooKeeper Governance Center [shardingsphere]

["terrymanu (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] How to Add Encryption Rules to the ZooKeeper Governance Center [shardingsphere]

["terrymanu (via GitHub)" <gi...@apache.org>]

terrymanu closed issue #37501: How to Add Encryption Rules to the ZooKeeper Governance Center
URL: https://github.com/apache/shardingsphere/issues/37501


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