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/29/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\&.
87
166
.\" ndb_config: version option
88
167
.\" version option: ndb_config
89
168
\fB\-\-version\fR,
119
198
.\" ndb_config: ndb-connectstring option
120
199
.\" ndb-connectstring option: ndb_config
121
200
\fB\-\-ndb\-connectstring=\fR\fB\fIconnect_string\fR\fR
131
\fBCommand\-Line Format\fR
133
\-\-ndb\-connectstring=name
137
\-\-connect\-string=name
146
\fBPermitted Values \fR
160
202
Specifies the connectstring to use in connecting to the management server\&. The format for the connectstring is the same as described in
161
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
162
204
localhost:1186\&.
179
221
.\" ndb_config: config-file option
180
222
.\" config-file option: ndb_config
181
223
\fB\-\-config\-file=\fR\fB\fIpath\-to\-file\fR\fR
231
\fBCommand\-Line Format\fR
233
\-\-config\-file=path
238
\fBPermitted Values \fR
183
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
185
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
196
308
.\" ndb_config: query option
197
309
.\" query option: ndb_config
198
310
\fB\-\-query=\fR\fB\fIquery\-options\fR\fR,
345
457
.\" ndb_config: id option
346
458
.\" id option: ndb_config
347
\fB\-\-id=\fR\fB\fInode_id\fR\fR,
459
\fB\-\-id=\fR\fB\fInode_id\fR\fR
349
461
.\" ndb_config: nodeid option
350
462
.\" nodeid option: ndb_config
399
511
to print information from parameters defined in
401
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
403
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
1052
1276
.SH "COPYRIGHT"
1055
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.
1057
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.