Detailed configuration file of MySQLCluster (config. ini)

Source: Internet
Author: User

  1. ######################################## ###################################
  2. # MySQL CLuster configuration file
  3. # With [!] The parameter is described in detail. We recommend that you refer to the official description.
  4. # With [!] When setting this parameter, you should read the official description in detail.
  5. # For details about how to configure the SCI connection mode, refer to the official description.
  6. # Official description: http://dev.mysql.com/doc/refman/5.1/zh/ndbcluster.html
  7. ######################################## ###################################
  8. ######################################## ###################################
  9. # Define MySQL Cluster TCP/IP connection
  10. # TCP/IP is the default transmission protocol used by the MySQL cluster to establish connections. Normally, no connection is required.
  11. # * You can use the [tcp default] definition.
  12. ######################################## ###################################
  13. [Tcp default]
  14. # [TCP]
  15. # [!] TCP transmission Cache
  16. # The default value is 256KB.
  17. SendBufferMemory = 256 k
  18. # [!] Message ID transmitted over the network.
  19. # This feature is disabled by default. (value: Y/N or 1/0)
  20. # SendSignalId = 0
  21. # [!] Enabling this parameter will calculate the checksum for all parameters before all messages are placed in the sending buffer.
  22. # This feature is disabled by default. (value: Y/N or 1/0)
  23. # Checksum = 0
  24. # Specify the buffer size used to receive data from the TCP/IP Socket.
  25. # You almost do not need to change the default value of this parameter. The default value is 64 KB.
  26. ReceiveBufferMemory = 64 k
  27. ######################################## ###################################
  28. # Define a Management Server (MGM)
  29. #
  30. # Used to configure and manage server behavior. The following parameters can be ignored. If so, the default value is used.
  31. # If ExecuteOnComputer or HostName is not defined, it is specified as localhost
  32. # * You can use [NDB_MGMD DEFAULT] to define the DEFAULT behavior of multiple management nodes.
  33. ######################################## ###################################
  34. [NDB_MGMD DEFAULT]
  35. [NDB_MGMD]
  36. # Unique ID of a node in the cluster. value range: 1 ~ 63
  37. Id = 1
  38. # Specify the node host name or IP address
  39. HostName = 192.168.1.100
  40. # Reference one of the computers defined in [COMPUTER]
  41. # ExecuteOnComputer =
  42. # Manage the server listening port (default value: 2202)
  43. PortNumber = 2202
  44. # Node log Source Method
  45. # The following values are recommended:
  46. #1. CONSOLE
  47. # Output logs to the standard output device (stdout ).
  48. #2. SYSLOG: facility = syslog
  49. # Send the log to the syslog (System Log) soft device. Possible values:
  50. # Auth, authpriv, cron, daemon, ftp, kern, lpr, mail, news, syslog
  51. #, User, uucp, local0, local12 ~ 7
  52. #3. FILE: filename =/var/log/mgmd. log, maxsize = 1000000, maxfiles = 6
  53. # Output logs to files. You can specify the following values:
  54. # Filename: name of the log file.
  55. # Maxsize: the maximum size of a log file. When the size is greater than this size, a new log file is automatically created.
  56. # Maxfiles: Maximum number of log files
  57. LogDestination = FILE: filename =/var/log/mgmd. log
  58. # Specify which node plays the decision role. Only MGM nodes and SQL nodes can be used. (default value: 1)
  59. # Generally, set the value to 1, set all SQL nodes to 0, and use the MGM server as the Decision-Making Program.
  60. # One of the following values is recommended:
  61. #0: this node will never be used for decision-making.
  62. #1: The node has a high priority.
  63. #2: The node has a low limit.
  64. ArbitrationRank = 1
  65. # Specify the latency of the Management Server for decision-making requests, in milliseconds. The default value is 0.
  66. # Generally, you do not need to change it.
  67. ArbitrationDelay = 0
  68. # Save the location of the output file of the management server, including the log, process output file, and pid file of the program
  69. # You can set the FILE parameter of LogDestination to overwrite a log FILE.
  70. DataDir =/var/lib/mysql-cluster
  71. ######################################## ###################################
  72. # Define the DEFAULT behavior of data nodes (ndbd default)
  73. # NoOfReplicas is a required Parameter
  74. ######################################## ###################################
  75. [Ndbd default]
  76. # Define the number of copies for each table in the cluster, and specify the node group size.
  77. # A node group is a set of nodes that save the same information.
  78. # Generally, you do not need to specify a value for this parameter.
  79. # NoOfReplicas has no default value. The maximum value is 4.
  80. NoOfReplicas = 1
  81. ######################################## ###################################
  82. # Define a data node (NDBD)
  83. #
  84. # Used to configure the behavior of data nodes.
  85. # ExecuteOnComputer or HostName is a required parameter.
  86. # For various parameters, the suffix k, M, or G can be used to specify the unit.
  87. ######################################## ###################################
  88. [NDBD]
  89. # When starting a node, you can assign an id (that is, a data node id) in the command line, or in the configuration file.
  90. Id = 11
  91. # Specify the node host name or IP address
  92. HostName = 192.168.1.101
  93. # Reference one of the computers defined in [COMPUTER]
  94. # ExecuteOnComputer =
  95. # Specify the directory for storing trace files, log files, pid files, and error logs.
  96. DataDir =/var/lib/mysql-cluster
  97. # This parameter specifies all files, REDO logs, UNDO logs, and data file directories created for metadata.
  98. # Note: The directory must exist before the ndbd process starts.
  99. # FileSystemPath =
  100. # Specifies the directory for storing backups. The default value is {FileSystemPath}/BACKUP.
  101. # BackupDataDir =
  102. # Specify the data memory. The default value is 80 MB and the minimum value is 1 MB.
  103. DataMemory = 80 M
  104. # Specify the index memory. The default value is 18 MB and the minimum value is 1 MB.
  105. IndexMemory = 18 M
  106. # [!] Used to set the number of possible concurrent transactions in the node. The default value is 4096.
  107. # Parameters must be set to the same value for all nodes.
  108. # MaxNoOfConcurrentTransactions = 4096
  109. # [!] Set the number of records that can appear in the update phase or be locked at the same time. The default value is 32768.
  110. #
  111. # MaxNoOfConcurrentOperations = 32768
  112. # [!] By default, this parameter is calculated based on 1.1 * MaxNoOfConcurrentOperations,
  113. # It is suitable for systems that have many concurrent transactions but do not have any serious transactions.
  114. # If you need to handle extra-large transactions at a certain time and there are many nodes,
  115. # It is best to specify this parameter to overwrite the default value
  116. # MaxNoOfLocalOperations =
  117. # [!] The default value of this parameter is 8192.
  118. # Only when the unique hash index is required to perform extremely high parallel operations in rare cases,
  119. # It is necessary to increase the value.
  120. # If you are sure that the cluster does not require high parallel operations, you can use a smaller value and save memory.
  121. # MaxNoOfConcurrentIndexOperations = 8192
  122. # [!] The default value is 4000, which is sufficient for most cases.
  123. # In some cases, if you think that the requirements for parallel operations in the cluster are not high, you can even lower it.
  124. # MaxNoOfFiredTriggers = 4000
  125. # [!] The memory affected by this parameter is used to track the operations performed when updating the index table and reading the unique index.
  126. # This memory is used to save key and column information about such operations.
  127. # You almost do not need to change the default value of this parameter.
  128. # TransactionBufferMemory = 1 M
  129. # [!] This parameter controls the number of parallel scans that can be performed in the cluster.
  130. # The default value is 256 and the maximum value is 500.
  131. # Maxnoofconcurrentscradi= 256
  132. # [!] If many scans are not completely parallel, specify the number of local scan records.
  133. # MaxNoOfLocalScans =
  134. # [!] This parameter is used to calculate the number of locked records.
  135. # This type of record is required to process many concurrent scan operations.
  136. # The default value is 64. This value is closely related to the ScanBatchSize defined in the SQL node.
  137. # BatchSizePerLocalScan =
  138. # [!] The internal buffer used to transmit messages between a single node and a node.
  139. # Although it almost does not need to be changed, it is still configurable. By default, it is set to 1 MB.
  140. # LongMessageBuffer = 1 M
  141. # [!] Set the REDO log file size of the node. The default value is 8.
  142. # NoOfFragmentLogFiles = 8
  143. # [!] Set the maximum number of trace files. The default value is 25.
  144. # MaxNoOfSavedMessages = 25
  145. # [!] Set the number of attributes that can be defined in the cluster. The default value is 1000 and the minimum value is 32.
  146. # Maxnoofattribuckets = 1000
  147. # [!] Sets the maximum number of table objects in the cluster. The default value is 128, the minimum value is 8, and the maximum value is 1600.
  148. # MaxNoOfTables = 128
  149. # [!] The default value is 128.
  150. # MaxNoOfOrderedIndexes = 128
  151. # [!] The default value of this parameter is 64.
  152. # MaxNoOfUniqueHashIndexes = 64
  153. # [!] This parameter is used to set the maximum number of triggers in the cluster.
  154. # MaxNoOfTriggers = 768
  155. # For Many operating systems, the process can be locked in the memory to avoid switching with the disk.
  156. # Use it to ensure the real-time features of the cluster.
  157. # This feature is disabled by default (values: Y/N or 1/0)
  158. # LockPagesInMainMemory = 0
  159. # When an error occurs, this parameter specifies whether the NDBD process exits or automatically restarts.
  160. # This feature is enabled by default (values: Y/N or 1/0)
  161. # StopOnError = 1
  162. # [!] The specified cluster is "no disk ".
  163. # This feature is disabled by default (values: Y/N or 1/0)
  164. # Diskless = 0
  165. # [!] This feature can be accessed only when it is compiled as a debug version.
  166. # This feature is disabled by default.
  167. # RestartOnErrorInsert = 0
  168. # [!] Specifies the interval between monitoring thread checks. This parameter is in milliseconds.
  169. # The default value is 4000 milliseconds.
  170. # Timebetweenwatchdogcheck= 4000
  171. # [!] This parameter specifies the time when the cluster waits for all storage nodes to appear before the cluster initialization subroutine is called.
  172. # The default value is 30000 milliseconds (0 indicates infinite timeout)
  173. # StartPartialTimeout = 30000
  174. # [!] If the cluster is ready for startup but may still be isolated, the cluster will wait until the timeout period ends.
  175. # The default value is 60000 milliseconds.
  176. # StartPartitionedTimeout = 60000
  177. # [!] If the data node does not complete its startup sequence within the time specified by this parameter,
  178. # Node startup will fail. If this parameter is set to 0, data node timeout is not used.
  179. # The default value is 60000 milliseconds.
  180. # StartFailureTimeout = 60000
  181. # [!] Interval at which each data node sends a heartbeat signal to the SQL node.
  182. # The default value is 1500 milliseconds.
  183. # HeartbeatIntervalDbDb = 1500
  184. # [!] The default value is 1500 Ms.
  185. # HeartbeatIntervalDbApi = 1500
  186. # [!] The default value is 20.
  187. # TimeBetweenLocalCheckpoints = 20
  188. # [!] This parameter defines the interval between global checkpoint operations.
  189. # The default value is 2000 milliseconds.
  190. # TimeBetweenGlobalCheckpoints = 2000
  191. # [!] The default value is 1000 ms.
  192. # TimeBetweenInactiveTransactionAbortCheck = 1000
  193. # [!] If the transaction does not execute any query at present, it waits for further user input.
  194. # This parameter indicates the maximum waiting time before the transaction is abandoned.
  195. # The default value is 0.
  196. # TransactionInactiveTimeout = 0
  197. # [!] The timeout parameter specifies the time for the Transaction Coordinator to wait for another node to execute the query before the transaction is abandoned.
  198. # TransactionDeadlockDetectionTimeout = 1200
  199. # [!] This parameter specifies the speed at which local checkpoint operations are performed,
  200. # It Can Be Used with NoOfFragmentLogFiles, DataMemory, and IndexMemory.
  201. # The default value is 40 (mb data page per second)
  202. # NoOfDiskPagesToDiskAfterRestartTUP = 40
  203. # The unit used by this parameter is the same as that used by NoOfDiskPagesToDiskAfterRestartTUP.
  204. # The operation method is similar, but the speed of writing index pages from the index memory is limited.
  205. # The default value of this parameter is 20 index memory pages per second (mb per second)
  206. # NoOfDiskPagesToDiskAfterRestartACC = 20
  207. # [!] This parameter involves pages written from the data memory.
  208. # The default value is 40 (3.2MB per second)
  209. # NoOfDiskPagesToDiskDuringRestartTUP = 40
  210. # [!] The default value of this parameter is 20 (1.6MB per second)
  211. # NoOfDiskPagesToDiskDuringRestartACC = 20
  212. # [!] Specifies the time for the data node to wait for the decision-making program to respond to the decision message.
  213. # The default value is 1000 milliseconds.
  214. # ArbitrationTimeout = 1000
  215. # [!] Specify the size of the UNDO index buffer.
  216. # The default value is 2 MB and the minimum value is 1 MB.
  217. # UndoIndexBuffer = 2 M
  218. # [!] Specify the size of the UNDO data buffer.
  219. # The default value is 16 MB and the minimum value is 1 MB.
  220. # UndoDataBuffer = 16 M
  221. # [!] Specifies the size of the REDO data buffer.
  222. # The default value is 8 MB and the minimum value is 1 MB.
  223. # RedoBuffer = 8 M
  224. # Log Level, used for events generated during process startup.
  225. # The default value is 1.
  226. # LogLevelStartup = 1
  227. # Log Level, used as an event generated when the node properly closes the process component.
  228. # The default value is 0.
  229. # LogLevelShutdown = 0
  230. # Log Level, used to count events, such as the number of reads by the primary key method, number of updates, number of inserts,
  231. # Information related to buffer usage.
  232. # The default value is 0.
  233. # LogLevelStatistic = 0
  234. # Log Level, used for events generated by local and global checkpoint operations.
  235. # The default value is 0.
  236. # LogLevelCheckpoint = 0
  237. # Log Level, used for events generated during node restart.
  238. # The default value is 0.
  239. # LogLevelNodeRestart = 0
  240. # Log Level, used for events generated by connections between cluster nodes.
  241. # The default value is 0.
  242. # LogLevelConnection = 0
  243. # Log Level, used for events generated by errors and warnings throughout the cluster.
  244. # This type of error will not cause any node failure. It is still worth recording.
  245. # The default value is 0.
  246. # LogLevelError = 0
  247. # Log Level, used to generate events for general cluster status information.
  248. # The default value is 0.
  249. # LogLevelInfo = 0
  250. # [!] Specifies the size of the Data Backup buffer.
  251. # The default value is 2 MB.
  252. # BackupDataBufferSize = 2 M
  253. # [!] Specify the size of the log backup buffer.
  254. # The default value is 2 MB.
  255. # BackupLogBufferSize = 2 M
  256. # This parameter is the sum of BackupDataBufferSize and BackupLogBufferSize.
  257. # The default value is 2 MB + 2 MB = 4 MB.
  258. # BackupMemory = 4 M
  259. # This parameter specifies the size of messages written to the disk by backup log buffering and backup data buffering.
  260. # The default value is 32 KB.
  261. # BackupWriteSize = 32 k
  262. ######################################## ###################################
  263. # Define MySQL Server (MYSQLD)
  264. #
  265. # Define the behavior of a MySQL Server (SQL node) used to access cluster data
  266. # * You can use [NDB_MGMD DEFAULT] to define the DEFAULT behavior of multiple management nodes.
  267. ######################################## ###################################
  268. # [Mysqld default]
  269. [MYSQLD]
  270. # Unique ID of a node in the cluster. value range: 1 ~ 63
  271. Id = 21
  272. # Specify the node host name or IP address
  273. HostName = 192.168.1.102
  274. # Reference one of the computers defined in [COMPUTER]
  275. # ExecuteOnComputer =
  276. # For normal configuration, use the Management Server as the Decision-Making Program.
  277. # Set its ArbitrationRank to 1 (default ),
  278. # Set ArbitrationRank of all SQL nodes to 0.
  279. ArbitrationRank = 0
  280. # Specify the latency of the Management Server for decision-making requests, in milliseconds. The default value is 0.
  281. # Generally, you do not need to change it.
  282. ArbitrationDelay = 0
  283. # [!] This parameter is in bytes and the default value is 32 KB.
  284. # BatchByteSize = 32 k
  285. # [!] This parameter is in bytes. The default value is 64 and the maximum value is 992.
  286. # BatchSize = 64
  287. # [!] Specify the size of each batch of data sent from each data node.
  288. # The default value is 256KB, and the maximum value is 16 MB.
  289. # MaxScanBatchSize = 256 k

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.