2
2
.\" Title: \fBndb_config\fR
3
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
6
.\" Manual: MySQL Database System
7
7
.\" Source: MySQL 5.1
8
8
.\" Language: English
10
.TH "\FBNDB_CONFIG\FR" "1" "07/06/2010" "MySQL 5\&.1" "MySQL Database System"
10
.TH "\FBNDB_CONFIG\FR" "1" "12/16/2011" "MySQL 5\&.1" "MySQL Database System"
11
11
.\" -----------------------------------------------------------------
12
12
.\" * set default formatting
13
13
.\" -----------------------------------------------------------------
26
26
\fBndb_config \fR\fB\fIoptions\fR\fR
29
This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from a cluster management node (and possibly its
29
This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: a MySQL Cluster management node, or its
31
file)\&. Beginning with MySQL Cluster NDB 6\&.3\&.25 and MySQL Cluster NDB 7\&.0\&.6, it can also provide an offline dump (in text or XML format) of all configuration parameters which can be used, along with their default, maximum, and minimum values and other information (see the discussion of the
33
file\&. By default, the management node is the source for the configuration data; to override the default, execute ndb_config with the
34
\fB\-\-config\-file\fR
37
option\&. Beginning with MySQL Cluster NDB 7\&.0\&.27 and MySQL Cluster NDB 7\&.1\&.16, it is also possible to use a data node as the source by specifying its node ID using
38
\fB\-\-config_from_node=\fR\fB\fInode_id\fR\fR\-
40
Beginning with MySQL Cluster NDB 6\&.3\&.25 and MySQL Cluster NDB 7\&.0\&.6,
42
can also provide an offline dump of all configuration parameters which can be used, along with their default, maximum, and minimum values and other information\&. The dump can be produced in either text or XML format; for more information, see the discussion of the
32
43
\fB\-\-configinfo\fR
35
46
options later in this section)\&.
48
Beginning with MySQL Cluster NDB 7\&.0\&.27 and MySQL Cluster NDB 7\&.1\&.16, you can filter the results by section (DB,
50
CONNECTIONS) using one of the options
53
\fB\-\-connections\fR\&.
37
55
The following table includes options that are specific to
38
56
\fBndb_config\fR\&. Additional descriptions follow the table\&. For options common to all MySQL Cluster programs, see
39
Section\ \&17.4.2, \(lqOptions Common to MySQL Cluster Programs\(rq\&.
57
Section\ \&16.4.2, \(lqOptions Common to MySQL Cluster Programs\(rq\&.
105
.\" ndb_config: config_from_node option
106
.\" config_from_node option: ndb_config
107
\fB\-\-config_from_node=#\fR
117
\fBVersion Introduced\fR
119
5\&.1\&.56\-ndb\-7\&.0\&.27, 5\&.1\&.56\-ndb\-7\&.1\&.16
122
\fBCommand\-Line Format\fR
124
\-\-config_from_node=#
129
\fBPermitted Values \fR
148
Obtain the cluster\'s configuration data from the data node that has this ID\&.
150
If the node having this ID is not a data node,
152
fails with an error\&. (To obtain configuration data from the management node instead, simply omit this option\&.)
154
\fB\-\-config_from_node\fR
155
was added in MySQL Cluster NDB 7\&.0\&.27 and MySQL NDB 7\&.1\&.16\&.
77
166
.\" ndb_config: version option
78
167
.\" version option: ndb_config
79
168
\fB\-\-version\fR,
85
175
\fBCommand\-Line Format\fR
104
198
.\" ndb_config: ndb-connectstring option
105
199
.\" ndb-connectstring option: ndb_config
106
200
\fB\-\-ndb\-connectstring=\fR\fB\fIconnect_string\fR\fR
114
\fBCommand\-Line Format\fR
116
\-\-ndb\-connectstring=name
121
\fBPermitted Values \fR
135
202
Specifies the connectstring to use in connecting to the management server\&. The format for the connectstring is the same as described in
136
Section\ \&17.3.2.3, \(lqThe MySQL Cluster Connectstring\(rq, and defaults to
203
Section\ \&16.3.2.3, \(lqThe MySQL Cluster Connectstring\(rq, and defaults to
137
204
localhost:1186\&.
154
221
.\" ndb_config: config-file option
155
222
.\" config-file option: ndb_config
156
223
\fB\-\-config\-file=\fR\fB\fIpath\-to\-file\fR\fR
231
\fBCommand\-Line Format\fR
233
\-\-config\-file=path
238
\fBPermitted Values \fR
158
251
Gives the path to the management server\'s configuration file (config\&.ini)\&. This may be a relative or absolute path\&. If the management node resides on a different host from the one on which
160
253
is invoked, then an absolute path must be used\&.
264
.\" ndb_config: mycnf option
265
.\" mycnf option: ndb_config
274
\fBCommand\-Line Format\fR
281
\fBPermitted Values \fR
295
Read configuration data from the
171
308
.\" ndb_config: query option
172
309
.\" query option: ndb_config
173
310
\fB\-\-query=\fR\fB\fIquery\-options\fR\fR,
212
354
.\" ndb_config: query option
213
355
.\" query option: ndb_config
214
356
\fB\-\-query=id,type,indexmemory,datamemory\fR
215
would return the node ID, node type,
357
returns the node ID, node type,
315
457
.\" ndb_config: id option
316
458
.\" id option: ndb_config
317
\fB\-\-id=\fR\fB\fInode_id\fR\fR,
459
\fB\-\-id=\fR\fB\fInode_id\fR\fR
318
461
.\" ndb_config: nodeid option
319
462
.\" nodeid option: ndb_config
320
463
\fB\-\-nodeid=\fR\fB\fInode_id\fR\fR
322
Used to specify the node ID of the node for which configuration information is to be obtained\&.
465
Either of these options can be used to specify the node ID of the node for which configuration information is to be obtained\&.
467
is the preferred form\&.
366
511
to print information from parameters defined in
368
sections only\&. Currently, using this option has no affect, since these are the only values checked, but it may become possible in future to query parameters set in
370
and other sections of cluster configuration files\&.)
513
sections only\&. Prior to MySQL Cluster NDB 7\&.0\&.27 and MySQL Cluster NDB 7\&.1\&.16, this option had no affect\&. This option cannot be used together with
514
\fB\-\-connections\fR
527
.\" ndb_config: connections option
528
.\" connections option: ndb_config
529
\fB\-\-connections\fR
537
\fBCommand\-Line Format\fR
544
\fBPermitted Values \fR
562
information only\&. This option existed prior to MySQL Cluster NDB 7\&.0\&.27 and MySQL Cluster NDB 7\&.1\&.16, but had no affect before then\&. This option cannot be used together with
576
.\" ndb_config: system option
577
.\" system option: ndb_config
587
\fBVersion Introduced\fR
589
5\&.1\&.56\-ndb\-7\&.0\&.27, 5\&.1\&.56\-ndb\-7\&.1\&.16
592
\fBCommand\-Line Format\fR
599
\fBPermitted Values \fR
619
This option was introduced in MySQL Cluster NDB 7\&.0\&.27 and MySQL Cluster NDB 7\&.1\&.16\&. It cannot be used together with the
765
1032
is formatted using one line per element; we have added extra whitespace in the previous example, as well as the next one, for reasons of legibility\&. This should not make any difference to applications using this output, since most XML processors either ignore nonessential whitespace as a matter of course, or can be instructed to do so\&.
768
Beginning with MySQL Cluster NDB 6\&.3\&.29 and MySQL Cluster NDB 7\&.0\&.10, the XML output also indicates when changing a given parameter requires that nodes be restarted using the
1035
Beginning with MySQL Cluster NDB 6\&.3\&.29 and MySQL Cluster NDB 7\&.0\&.10, the XML output also indicates when changing a given parameter requires that data nodes be restarted using the
769
1036
\fB\-\-initial\fR
770
1037
option\&. This is shown by the presence of an
777
1044
restart="system"
778
1045
attribute in the corresponding
780
element\&. For example, the
1047
element\&. For example, changing the value set for the
782
1049
parameter requires a system initial restart, as shown here (with the
857
1124
\fB\-\-configinfo\fR
860
is not supported\&. If you attempt to do so, the usual (current) result is that all other options besides
1127
is not supported\&. Currently, if you attempt to do so, the usual result is that all other options besides
861
1128
\fB\-\-configinfo\fR
864
are simply ignored\&. However, this behavior is not guaranteed and is subject to change at any time\&. In addition, since
1131
are simply ignored\&.
1132
\fIHowever, this behavior is not guaranteed and is subject to change at any time\fR\&. In addition, since
1133
\fBndb_config\fR, when used with the
867
1134
\fB\-\-configinfo\fR
868
option does not access the MySQL Cluster or read any files, trying to specify additional options such as
1135
option, does not access the MySQL Cluster or read any files, trying to specify additional options such as
869
1136
\fB\-\-ndb\-connectstring\fR
871
1138
\fB\-\-config\-file\fR
946
1212
\fBndb_config\fR
947
1213
checks only data nodes (using the
949
option), and shows the values for each node\'s ID and host name, and its
1215
option), and shows the values for each node\'s ID and host name, as well as the values set for its
951
1217
IndexMemory, and
1010
1276
.SH "COPYRIGHT"
1013
Copyright \(co 1997, 2010, Oracle and/or its affiliates. All rights reserved.
1279
Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
1015
1281
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.