mlycore commented on issue #166:
URL: 
https://github.com/apache/shardingsphere-on-cloud/issues/166#issuecomment-1378565961

   Here's an example for MySQL:
   ```yaml
   apiVersion: shardingsphere.apache.org/v1alpha1
   kind: ComputeNode
   metadata:
     labels:
       app: test
     name: test
     namespace: oncloud-test
   spec:
     bootstrap:
       logbackConfig: "<?xml version=\"1.0\"?>\n<configuration>\n    <appender 
name=\"console\"
         class=\"ch.qos.logback.core.ConsoleAppender\">\n        <encoder>\n    
        <pattern>[%-5level]
         %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{36} - %msg%n</pattern>\n 
       </encoder>\n
         \   </appender>\n    <appender name=\"sqlConsole\" 
class=\"ch.qos.logback.core.ConsoleAppender\">\n
         \       <encoder>\n            <pattern>[%-5level] %d{yyyy-MM-dd 
HH:mm:ss.SSS}
         [%thread] [%X{database}] [%X{user}] [%X{host}] %logger{36} - 
%msg%n</pattern>\n
         \       </encoder>\n    </appender>\n    \n    <logger 
name=\"ShardingSphere-SQL\"
         level=\"info\" additivity=\"false\">\n        <appender-ref 
ref=\"sqlConsole\"
         />\n    </logger>\n    <logger name=\"org.apache.shardingsphere\" 
level=\"info\"
         additivity=\"false\">\n        <appender-ref ref=\"console\" />\n    
</logger>\n
         \   \n    <logger name=\"com.zaxxer.hikari\" level=\"error\" />\n    
\n    <logger
         name=\"com.atomikos\" level=\"error\" />\n    \n    <logger 
name=\"io.netty\"
         level=\"error\" />\n    \n    <root>\n        <level value=\"info\" 
/>\n        <appender-ref
         ref=\"console\" />\n    </root>\n</configuration> \n"
       serverConfig:
         authority:
           privilege:
             type: ALL_PERMITTED
           users:
           - user: root%
             password: root
         mode:
           type: Cluster
           repository:
             type: ZooKeeper
             props:
               timeToLiveSeconds: 600
               server-lists: ss-zookeeper.operatortest:2181
               retryIntervalMilliseconds: 500
               operationTimeoutMilliseconds: 5000
               namespace: governance_ds
               maxRetries: 3
         props:
           proxy-frontend-database-protocol-type: MySQL
     version: 5.3.0
     replicas: 1
     connector:
       type: mysql
       version: 5.1.47
     ports:
     - name: server
       containerPort: 3307
     service:
       type: ClusterIP
       ports:
         - name: server
           port: 3307
           targetPort: 3307
   ```


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

Reply via email to