Advertisement
yudjinDegtyarev

Untitled

May 23rd, 2023
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.71 KB | None | 0 0
  1. apiVersion: v1
  2. kind: ConfigMap
  3. metadata:
  4. name: {{ include "clickhouse.fullname" . }}
  5. labels:
  6. {{ include "clickhouse.labels" . | indent 4 }}
  7. data:
  8. config.xml: |-
  9. <?xml version="1.0"?>
  10. <yandex>
  11. <logger>
  12. <level>warning</level>
  13. <log>/var/log/clickhouse-server/clickhouse-server.log</log>
  14. <errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
  15. <size>100M</size>
  16. <count>7</count>
  17. </logger>
  18. <http_port>8123</http_port>
  19. <tcp_port>9000</tcp_port>
  20. <listen_host>0.0.0.0</listen_host>
  21. <max_connections>4096</max_connections>
  22. <keep_alive_timeout>3</keep_alive_timeout>
  23. <max_concurrent_queries>100</max_concurrent_queries>
  24. <uncompressed_cache_size>8589934592</uncompressed_cache_size>
  25. <mark_cache_size>5368709120</mark_cache_size>
  26. <path>/var/lib/clickhouse/</path>
  27. <tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
  28. <users_config>users.xml</users_config>
  29. <default_profile>default</default_profile>
  30. <default_database>default</default_database>
  31. <remote_servers incl="clickhouse_remote_servers" />
  32. <zookeeper incl="zookeeper-servers" optional="true" />
  33. <macros incl="macros" optional="true" />
  34. <builtin_dictionaries_reload_interval>3600</builtin_dictionaries_reload_interval>
  35. <max_session_timeout>3600</max_session_timeout>
  36. <default_session_timeout>60</default_session_timeout>
  37. <query_log>
  38. <database>system</database>
  39. <table>query_log</table>
  40. <flush_interval_milliseconds>7500</flush_interval_milliseconds>
  41. </query_log>
  42. <dictionaries_config>*_dictionary.xml</dictionaries_config>
  43. <compression incl="clickhouse_compression">
  44. </compression>
  45. <resharding>
  46. <task_queue_path>/clickhouse/task_queue</task_queue_path>
  47. </resharding>
  48. <distributed_ddl>
  49. <path>/clickhouse/task_queue/ddl</path>
  50. </distributed_ddl>
  51. </yandex>
  52. users.xml: |-
  53. <?xml version="1.0"?>
  54. <yandex>
  55. <profiles>
  56. <default>
  57. <max_memory_usage>10000000000</max_memory_usage>
  58. <use_uncompressed_cache>0</use_uncompressed_cache>
  59. <load_balancing>random</load_balancing>
  60. </default>
  61. <readonly>
  62. <readonly>1</readonly>
  63. </readonly>
  64. </profiles>
  65. <users>
  66. <{{ .Values.users.ro_user_name }}>
  67. <password>{{ .Values.users.ro_user_password }}</password>
  68. <networks incl="networks" replace="replace">
  69. <ip>::/0</ip>
  70. </networks>
  71. <profile>default</profile>
  72. <quota>default</quota>
  73. </{{ .Values.users.ro_user_name }}>
  74. <{{ .Values.users.rw_user_name }}>
  75. <password>{{ .Values.users.rw_user_password }}</password>
  76. <networks incl="networks" replace="replace">
  77. <ip>::/0</ip>
  78. </networks>
  79. <profile>default</profile>
  80. <quota>default</quota>
  81. </{{ .Values.users.rw_user_name }}>
  82. </users>
  83. <quotas>
  84. <default>
  85. <interval>
  86. <duration>3600</duration>
  87. <queries>0</queries>
  88. <errors>0</errors>
  89. <result_rows>0</result_rows>
  90. <read_rows>0</read_rows>
  91. <execution_time>0</execution_time>
  92. </interval>
  93. </default>
  94. </quotas>
  95. </yandex>
  96.  
  97.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement