Home > Developer > MySQL

Detailed configuration file of MySQLCluster (config. ini)

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

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

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
web config configuration file location config ini location of php ini file config ini php php ini mail configuration xdebug configuration php ini php ini configuration
Related Article
The efficiency of MySQL nested query and connection query

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.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

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

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

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

    Open a Ticket

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

    Learn More