설명 없음

server.yaml 2.9KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. #
  2. # Licensed to the Apache Software Foundation (ASF) under one or more
  3. # contributor license agreements. See the NOTICE file distributed with
  4. # this work for additional information regarding copyright ownership.
  5. # The ASF licenses this file to You under the Apache License, Version 2.0
  6. # (the "License"); you may not use this file except in compliance with
  7. # the License. You may obtain a copy of the License at
  8. #
  9. # http://www.apache.org/licenses/LICENSE-2.0
  10. #
  11. # Unless required by applicable law or agreed to in writing, software
  12. # distributed under the License is distributed on an "AS IS" BASIS,
  13. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. # See the License for the specific language governing permissions and
  15. # limitations under the License.
  16. #
  17. ######################################################################################################
  18. #
  19. # If you want to configure governance, authorization and proxy properties, please refer to this file.
  20. #
  21. ######################################################################################################
  22. # mode:
  23. # type: Cluster
  24. # repository:
  25. # type: ZooKeeper
  26. # props:
  27. # namespace: governance_ds
  28. # server-lists: localhost:2181
  29. # retryIntervalMilliseconds: 500
  30. # timeToLiveSeconds: 60
  31. # maxRetries: 3
  32. # operationTimeoutMilliseconds: 500
  33. authority:
  34. users:
  35. - user: root@%
  36. password: root
  37. - user: sharding
  38. password: sharding
  39. privilege:
  40. type: ALL_PERMITTED
  41. transaction:
  42. defaultType: XA
  43. providerType: Atomikos
  44. sqlParser:
  45. sqlCommentParseEnabled: false
  46. sqlStatementCache:
  47. initialCapacity: 2000
  48. maximumSize: 65535
  49. parseTreeCache:
  50. initialCapacity: 128
  51. maximumSize: 1024
  52. logging:
  53. loggers:
  54. - loggerName: ShardingSphere-SQL
  55. additivity: true
  56. level: INFO
  57. props:
  58. enable: false
  59. sqlFederation:
  60. sqlFederationEnabled: false
  61. executionPlanCache:
  62. initialCapacity: 2000
  63. maximumSize: 65535
  64. props:
  65. system-log-level: INFO
  66. max-connections-size-per-query: 1
  67. kernel-executor-size: 16 # Infinite by default.
  68. proxy-frontend-flush-threshold: 128 # The default value is 128.
  69. # sql-show is the same as props in logger ShardingSphere-SQL, and its priority is lower than logging rule
  70. sql-show: false
  71. check-table-metadata-enabled: false
  72. # Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
  73. # The default value is -1, which means set the minimum value for different JDBC drivers.
  74. proxy-backend-query-fetch-size: -1
  75. proxy-frontend-executor-size: 0 # Proxy frontend executor size. The default value is 0, which means let Netty decide.
  76. proxy-frontend-max-connections: 0 # Less than or equal to 0 means no limitation.
  77. proxy-default-port: 3307 # Proxy default port.
  78. proxy-netty-backlog: 1024 # Proxy netty backlog.
  79. cdc-server-port: 33071 # CDC server port
  80. proxy-frontend-ssl-enabled: false
  81. proxy-frontend-ssl-cipher: ''
  82. proxy-frontend-ssl-version: TLSv1.2,TLSv1.3