SHARE
TWEET

polar56-dimitrik-110k.cnf

a guest Jul 19th, 2019 108 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. ## Replication account info. Note, user_name will always be 'replicator' and user_password will be generated by control system randomly. All replica will use this account to build replication. Different PolarDB cluster(means one primary with multiple replicas) will have different user_passwordl.
  3. loose_polar_master_user_name = replicator
  4. loose_polar_master_user_password = 22192219
  5. loose_polar_master_port = 7250
  6. loose_polar_master_host = 127.0.0.1
  7.  
  8. ## Variable needed by PolarFS, every role in one specified PolarDB cluster must have unique value.
  9. loose_polarfs_host_id = 1
  10. skip-log-bin
  11. port=7250
  12. innodb_polar_log_file_extend_method=0
  13.  
  14. # general
  15. max_connections=4000
  16. table_open_cache=8000
  17. table_open_cache_instances=16
  18. back_log=1500
  19. #default_password_lifetime=0
  20. ssl=0
  21. performance_schema=OFF
  22. max_prepared_stmt_count=512000
  23. skip_log_bin=1
  24. character_set_server=latin1
  25. collation_server=latin1_swedish_ci
  26. transaction_isolation=REPEATABLE-READ
  27.  
  28. # files
  29. innodb_file_per_table
  30. innodb_log_file_size=1024M
  31. innodb_log_files_in_group=3
  32. innodb_open_files=4000
  33.  
  34. # buffers
  35. innodb_buffer_pool_size=32000M
  36. innodb_buffer_pool_instances=16
  37. innodb_log_buffer_size=64M
  38.  
  39. # tune
  40. innodb_doublewrite=0
  41. innodb_thread_concurrency=0
  42. innodb_flush_log_at_trx_commit=1
  43. innodb_max_dirty_pages_pct=90
  44. innodb_max_dirty_pages_pct_lwm=10
  45.  
  46. join_buffer_size=32K
  47. sort_buffer_size=32K
  48. innodb_use_native_aio=1
  49. innodb_stats_persistent=1
  50. innodb_spin_wait_delay=6
  51.  
  52. innodb_max_purge_lag_delay=300000
  53. innodb_max_purge_lag=0
  54. innodb_flush_method=O_DIRECT_NO_FSYNC
  55. innodb_checksum_algorithm=crc32
  56. innodb_io_capacity=4000
  57. innodb_io_capacity_max=20000
  58. innodb_lru_scan_depth=9000
  59. innodb_change_buffering=none
  60. innodb_read_only=0
  61. innodb_page_cleaners=4
  62. innodb_undo_log_truncate=off
  63.  
  64. # perf special
  65. innodb_adaptive_flushing=1
  66. innodb_flush_neighbors=0
  67. innodb_read_io_threads=16
  68. innodb_write_io_threads=16
  69. innodb_purge_threads=4
  70. innodb_adaptive_hash_index=0
  71.  
  72. # monitoring
  73. innodb_monitor_enable='%'
  74.  
  75. performance_schema = OFF
  76.  
  77. [mysql]
  78. default-character-set=latin1
  79.  
  80. [mysqlshow]
  81. default-character-set=latin1
  82.  
  83. [mysqlimport]
  84. default-character-set=latin1
  85.  
  86. [mysqlcheck]
  87. default-character-set=latin1
  88.  
  89. [mysql_upgrade]
  90. default-character-set=latin1
  91. tmpdir=/disk12/xin/polardb/bu/mysql-test/var/tmp
  92.  
  93. [mysqld.1]
  94. #!run-master-sh
  95. #1 log-bin=master-bin
  96. #2 loose-enable-performance-schema
  97. basedir=/disk12/xin/polardb/bu
  98. tmpdir=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1
  99. character-sets-dir=/disk12/xin/polardb/bu/share/charsets
  100. lc-messages-dir=/disk12/xin/polardb/bu/share/
  101. datadir=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/data
  102. polar_node_basedir=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/data
  103. pid-file=/disk12/xin/polardb/bu/mysql-test/var/run/mysqld.1.pid
  104. #host=localhost
  105. port=15000
  106. socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock
  107. #log-error=/disk12/xin/polardb/bu/mysql-test/var/log/mysqld.1.err
  108. #general_log=1
  109. general_log_file=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/mysqld.log
  110. #4 slow_query_log=1
  111. slow_query_log_file=/disk12/xin/polardb/bu/mysql-test/var/mysqld.1/mysqld-slow.log
  112. #user=root
  113. #password=
  114. server-id=1
  115. secure-file-priv=/disk12/xin/polardb/bu/mysql-test/var
  116. ssl-ca=/disk12/xin/polardb/bu/mysql-test/std_data/cacert.pem
  117. ssl-cert=/disk12/xin/polardb/bu/mysql-test/std_data/server-cert.pem
  118. ssl-key=/disk12/xin/polardb/bu/mysql-test/std_data/server-key.pem
  119.  
  120. # [mysqlbinlog]
  121. #5 disable-force-if-open
  122. #6 character-sets-dir=/disk12/xin/polardb/bu/share/charsets
  123.  
  124. [ENV]
  125. MASTER_MYPORT=15000
  126. MASTER_MYSOCK=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock
  127.  
  128. [client]
  129. password=
  130. user=root
  131. port=15000
  132. host=localhost
  133. socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock
  134.  
  135. # [mysqltest]
  136. #ssl-ca=/disk12/xin/polardb/bu/mysql-test/std_data/cacert.pem
  137. #ssl-cert=/disk12/xin/polardb/bu/mysql-test/std_data/client-cert.pem
  138. #ssl-key=/disk12/xin/polardb/bu/mysql-test/std_data/client-key.pem
  139. #skip-ssl=1
  140.  
  141. [client.1]
  142. password=
  143. user=root
  144. port=15000
  145. host=localhost
  146. socket=/disk12/xin/polardb/bu/mysql-test/var/tmp/mysqld.1.sock
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top