Title: ndbd
Author: [FIXME: author] [see http://docbook.sf.net/el/author]
Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
Date: 06/07/2021
Manual: MySQL Database System
Source: MySQL 5.7
Language: English
* Define some portability stuff
-----------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://bugs.debian.org/507673
http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----------------------------------------------------------------
* set default formatting
-----------------------------------------------------------------
disable hyphenation
disable justification (adjust text to left margin only)
-----------------------------------------------------------------
* MAIN CONTENT STARTS HERE *
-----------------------------------------------------------------
\w'ndbd options 'u ndbd options
ndbd is the process that is used to handle all the data in tables using the NDB Cluster storage engine. This is the process that empowers a data node to accomplish distributed transaction handling, node recovery, checkpointing to disk, online backup, and related tasks.
In an NDB Cluster, a set of ndbd processes cooperate in handling data. These processes can execute on the same computer (host) or on different computers. The correspondences between data nodes and Cluster hosts is completely configurable.
Options that can be used with ndbd are shown in the following table. Additional descriptions follow the table. .it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Table 21.22. Command-line options used with the program ndbd
Format |
: |
Description |
: |
Added, Deprecated, or Removed |
.T& |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l |
lB l l. |
--bind-address=name |
: |
Local bind address |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--character-sets-dir=path |
: |
Directory containing character sets |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--connect-delay=# |
: |
Time to wait between attempts to contact a management server, in |
seconds; 0 means do not wait between attempts |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--connect-retries=# |
: |
Set the number of times to retry a connection before giving up; 0 means |
1 attempt only (and no retries) |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--connect-retry-delay=# |
: |
Time to wait between attempts to contact a management server, in |
seconds; 0 means do not wait between attempts |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--connect-string=connection-string, |
-c |
: |
Same as --ndb-connectstring |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--core-file |
: |
Write core file on error; used in debugging |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--daemon, |
-d |
: |
Start ndbd as daemon (default); override with --nodaemon |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--defaults-extra-file=path |
: |
Read given file after global files are read |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--defaults-file=path |
: |
Read default options from given file only |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--defaults-group-suffix=string |
: |
Also read groups with concat(group, suffix) |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--foreground |
: |
Run ndbd in foreground, provided for debugging purposes (implies |
--nodaemon) |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--help, |
-? |
: |
Display help text and exit |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--initial |
: |
Perform initial start of ndbd, including file system cleanup; consult |
documentation before using this option |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--initial-start |
: |
Perform partial initial start (requires --nowait-nodes) |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--install[=name] |
: |
Used to install data node process as Windows service; does not apply on |
other platforms |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--logbuffer-size=# |
: |
Control size of log buffer; for use when debugging with many log |
messages being generated; default is sufficient for normal |
operations |
: |
ADDED: NDB 7.6.6 |
--login-path=path |
: |
Read given path from login file |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--ndb-connectstring=connection-string, |
-c |
: |
Set connect string for connecting to ndb_mgmd. Syntax: |
"[nodeid=id;][host=]hostname[:port]". Overrides entries in |
NDB_CONNECTSTRING and my.cnf |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--ndb-mgmd-host=connection-string, |
-c |
: |
Same as --ndb-connectstring |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--ndb-nodeid=# |
: |
Set node ID for this node, overriding any ID set by --ndb-connectstring |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--nodaemon |
: |
Do not start ndbd as daemon; provided for testing purposes |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--no-defaults |
: |
Do not read default options from any option file other than login file |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--nostart, |
-n |
: |
Do not start ndbd immediately; ndbd waits for command to start from |
ndb_mgm |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--nowait-nodes=list |
: |
Do not wait for these data nodes to start (takes comma-separated list of |
node IDs); requires --ndb-nodeid |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--ndb-optimized-node-selection |
: |
Enable optimizations for selection of nodes for transactions. Enabled by |
default; use --skip-ndb-optimized-node-selection to |
disable |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--print-defaults |
: |
Print program argument list and exit |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--remove[=name] |
: |
Used to remove data node process that was previously installed as |
Windows service; does not apply on other platforms |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--usage, |
-? |
: |
Display help text and exit; same as --help |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--verbose, |
-v |
: |
Write extra debugging information to node log |
: |
(Supported in all NDB releases based on MySQL 5.7) |
--version, |
-V |
: |
Display version information and exit |
: |
(Supported in all NDB releases based on MySQL 5.7) |
.it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Note
All of these options also apply to the multithreaded version of this program (ndbmtd) and you may substitute "ndbmtd" for "ndbd" wherever the latter occurs in this section.
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--bind-address=name |
Type |
: |
String |
Default Value |
: |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--character-sets-dir=path |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--connect-delay=# |
Deprecated |
: |
Yes |
Type |
: |
Numeric |
Default Value |
: |
5 |
Minimum Value |
: |
0 |
Maximum Value |
: |
3600 |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--connect-retries=# |
Type |
: |
Numeric |
Default Value |
: |
12 |
Minimum Value |
: |
0 |
Maximum Value |
: |
65535 |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--connect-retry-delay=# |
Type |
: |
Numeric |
Default Value |
: |
5 |
Minimum Value |
: |
0 |
Maximum Value |
: |
4294967295 |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--connect-string=connection-string |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--core-file |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--daemon |
Type |
: |
Boolean |
Default Value |
: |
TRUE |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--defaults-extra-file=path |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--defaults-file=path |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--defaults-group-suffix=string |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--foreground |
Type |
: |
Boolean |
Default Value |
: |
FALSE |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--help |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--initial |
Type |
: |
Boolean |
Default Value |
: |
FALSE |
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
.it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Warning
To avoid the possibility of eventual data loss, it is recommended that you not use the --initial option together with StopOnError = 0. Instead, set StopOnError to 0 in config.ini only after the cluster has been started, then restart the data nodes normally\(emthat is, without the --initial option. See the description of the StopOnError parameter for a detailed explanation of this issue. (Bug #24945638)
.it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Important
This option does not affect either of the following types of files:
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--initial-start |
Type |
: |
Boolean |
Default Value |
: |
FALSE |
.\}
shell> ndbd --ndb-nodeid=2 --nowait-nodes=3 --initial-start shell> ndbd --ndb-nodeid=4 --nowait-nodes=3 --initial-start shell> ndbd --ndb-nodeid=5 --nowait-nodes=3 --initial-start
.it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Important
Do not confuse this option with the --nowait-nodes option for ndb_mgmd, which can be used to enable a cluster configured with multiple management servers to be started without all management servers being online.
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--install[=name] |
Platform Specific |
: |
Windows |
Type |
: |
String |
Default Value |
: |
ndbd |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--logbuffer-size=# |
Introduced |
: |
5.7.22-ndb-7.6.6 |
Type |
: |
Integer |
Default Value |
: |
32768 |
Minimum Value |
: |
2048 |
Maximum Value |
: |
4294967295 |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--login-path=path |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--ndb-connectstring=connection-string |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--ndb-mgmd-host=connection-string |
Type |
: |
String |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--ndb-nodeid=# |
Type |
: |
Integer |
Default Value |
: |
[none] |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--ndb-optimized-node-selection |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--nodaemon |
Type |
: |
Boolean |
Default Value |
: |
FALSE |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--no-defaults |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--nostart |
Type |
: |
Boolean |
Default Value |
: |
FALSE |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--nowait-nodes=list |
Type |
: |
String |
Default Value |
: |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--print-defaults |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--remove[=name] |
Platform Specific |
: |
Windows |
Type |
: |
String |
Default Value |
: |
ndbd |
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--usage |
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
Command-Line Format |
: |
--version |
ndbd generates a set of log files which are placed in the directory specified by DataDir in the config.ini configuration file.
These log files are listed below. node_id is and represents the node\*(Aqs unique identifier. For example, ndb_2_error.log is the error log generated by the data node whose node ID is 2.
\h'-04'\(bu\h'+03'\c .\}
.\}
Date/Time: Saturday 30 July 2004 - 00:20:01 Type of error: error Message: Internal program error (failed ndbrequire) Fault ID: 2341 Problem data: DbtupFixAlloc.cpp Object of reference: DBTUP (Line: 173) ProgramName: NDB Kernel ProcessID: 14909 TraceFile: ndb_2_trace.log.2 ***EOM***
.it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1
Important
The last entry in the error log file is not necessarily the newest one (nor is it likely to be). Entries in the error log are not listed in chronological order; rather, they correspond to the order of the trace files as determined in the ndb_node_id_trace.log.next file (see below). Error log entries are thus overwritten in a cyclical and not sequential fashion.
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
\h'-04'\(bu\h'+03'\c .\}
It is recommended not to use a directory mounted through NFS because in some environments this can cause problems whereby the lock on the .pid file remains in effect even after the process has terminated.
To start ndbd, it may also be necessary to specify the host name of the management server and the port on which it is listening. Optionally, one may also specify the node ID that the process is to use.
.\}
shell> ndbd --connect-string="nodeid=2;host=ndb_mgmd.mysql.com:1186"
See Section 21.3.3.3, "NDB Cluster Connection Strings", for additional information about this issue. For more information about data node configuration parameters, see Section 21.3.3.6, "Defining NDB Cluster Data Nodes".
When ndbd starts, it actually initiates two processes. The first of these is called the "angel process"; its only job is to discover when the execution process has been completed, and then to restart the ndbd process if it is configured to do so. Thus, if you attempt to kill ndbd using the Unix kill command, it is necessary to kill both processes, beginning with the angel process. The preferred method of terminating an ndbd process is to use the management client and stop the process from there.
The execution process uses one thread for reading, writing, and scanning data, as well as all other activities. This thread is implemented asynchronously so that it can easily handle thousands of concurrent actions. In addition, a watch-dog thread supervises the execution thread to make sure that it does not hang in an endless loop. A pool of threads handles file I/O, with each thread able to handle one open file. Threads can also be used for transporter connections by the transporters in the ndbd process. In a multi-processor system performing a large number of operations (including updates), the ndbd process can consume up to 2 CPUs if permitted to do so.
For a machine with many CPUs it is possible to use several ndbd processes which belong to different node groups; however, such a configuration is still considered experimental and is not supported for MySQL 5.7 in a production setting. See Section 21.1.7, "Known Limitations of NDB Cluster".
Copyright \(co 1997, 2021, Oracle and/or its affiliates.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.