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" "11/04/2009" "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
\fBCommand Line Format\fR
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,
203
345
This is a comma\-delimited list of
205
\(em that is, a list of one or more node attributes to be returned\&. These include
346
query options\(emthat is, a list of one or more node attributes to be returned\&. These include
207
(node ID), type (node type \(em that is,
348
(node ID), type (node type\(emthat is,
210
351
ndb_mgmd), and any configuration parameters whose values are to be obtained\&.
213
354
.\" ndb_config: query option
214
355
.\" query option: ndb_config
215
356
\fB\-\-query=id,type,indexmemory,datamemory\fR
216
would return the node ID, node type,
357
returns the node ID, node type,
275
416
Specifies the host name of the node for which configuration information is to be obtained\&.
422
.nr an-no-space-flag 1
431
usually resolves to the IP address
432
127\&.0\&.0\&.1, this may not necessarily be true for all operating platforms and configurations\&. This means that it is possible, when
436
\fBndb_config \fR\fB\fB\-\-host=localhost\fR\fR
439
is run on a different host where
441
resolves to a different address (for example, on some versions of SUSE Linux, this is
442
127\&.0\&.0\&.2)\&. In general, for best results, you should use numeric IP addresses for all MySQL Clustewr configuration values relating to hosts, or verify that all MySQL Cluster hosts handle
444
in the same fashion\&.
286
457
.\" ndb_config: id option
287
458
.\" id option: ndb_config
288
\fB\-\-id=\fR\fB\fInode_id\fR\fR,
459
\fB\-\-id=\fR\fB\fInode_id\fR\fR
289
461
.\" ndb_config: nodeid option
290
462
.\" nodeid option: ndb_config
291
463
\fB\-\-nodeid=\fR\fB\fInode_id\fR\fR
299
\fBCommand Line Format\fR
306
\fBPermitted Values \fR
320
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\&.
364
511
to print information from parameters defined in
366
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
368
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
560
829
.\" ndb_config: configinfo option
561
.\" ndb_config: xml option
562
830
.\" configinfo option: ndb_config
563
.\" xml option: ndb_config
564
831
\fB\-\-configinfo\fR
574
\fBVersion Introduced\fR
576
5\&.1\&.34\-ndb\-7\&.0\&.6
579
\fBCommand Line Format\fR
586
\fBPermitted Values \fR
608
\fBVersion Introduced\fR
610
5\&.1\&.34\-ndb\-7\&.0\&.6
613
\fBCommand Line Format\fR
615
\-\-configinfo \-\-xml
620
\fBPermitted Values \fR
635
834
\fB\-\-configinfo\fR
636
835
option, added in MySQL Cluster NDB 6\&.3\&.25 and MySQL Cluster NDB 7\&.0\&.6, causes
740
You can obtain the output as XML by using the
742
option (also available beginning with MySQL Cluster NDB 6\&.3\&.25 and MySQL Cluster NDB 7\&.0\&.6) in addition to
743
\fB\-\-configinfo\fR\&. A portion of the resulting output is shown in this example:
939
.\" ndb_config: xml option
940
.\" xml option: ndb_config
951
\fBVersion Introduced\fR
953
5\&.1\&.34\-ndb\-6\&.3\&.25, 5\&.1\&.34\-ndb\-7\&.0\&.6
956
\fBCommand\-Line Format\fR
958
\-\-configinfo \-\-xml
963
\fBPermitted Values \fR
977
You can obtain the output of
984
option, available beginning with MySQL Cluster NDB 6\&.3\&.25 and MySQL Cluster NDB 7\&.0\&.6)\&. A portion of the resulting output is shown in this example:
781
1022
.nr an-break-flag 1
1028
Normally, the XML output produced by
1030
\fB\-\-configinfo\fR
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\&.
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
1037
option\&. This is shown by the presence of an
1039
attribute in the corresponding
1041
element\&. In addition (also beginning with MySQL Cluster NDB 6\&.3\&.29 and MySQL Cluster NDB 7\&.0\&.10), the restart type (system
1043
node) is also shown; if a given parameter requires a system restart, this is indicated by the presence of a
1045
attribute in the corresponding
1047
element\&. For example, changing the value set for the
1049
parameter requires a system initial restart, as shown here (with the
1053
attributes highlighted for visibility):
1059
<param name="Diskless" comment="Run wo/ disk" type="bool" default="false"
1060
\fIrestart="system" initial="true"\fR/>
1068
attribute is included in the XML output for
1070
elements corresponding to parameters which do not require initial restarts; in other words,
1072
is the default, and the value
1074
should be assumed if the attribute is not present\&. Similarly, the default restart type is
1076
(that is, an online or
1078
restart of the cluster), but the
1080
attribute is included only if the restart type is
1082
(meaning that all cluster nodes must be shut down at the same time, then restarted)\&.
1088
.nr an-no-space-flag 1
816
1124
\fB\-\-configinfo\fR
819
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
820
1128
\fB\-\-configinfo\fR
823
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
826
1134
\fB\-\-configinfo\fR
827
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
828
1136
\fB\-\-ndb\-connectstring\fR
830
1138
\fB\-\-config\-file\fR
905
1212
\fBndb_config\fR
906
1213
checks only data nodes (using the
908
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
910
1217
IndexMemory, and
972
Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc.
1279
Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
974
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.
982
1289
which may already be installed locally and which is also available
983
1290
online at http://dev.mysql.com/doc/.
985
Sun Microsystems, Inc. (http://www.mysql.com/).
1292
Oracle Corporation (http://dev.mysql.com/).