Oracle 5.0, Reference Manual

Page: 1649 / 3232

ndb_config
— Extract MySQL Cluster Configuration Information
1629
Read configuration data from the
my.cnf
file.
•
--query=query-options
,
-q query-options
Command-Line Format
--query=string
-q
Permitted Values
Type
string
Default
This is a comma-delimited list of query options—that is, a list of one or more node attributes to be
returned. These include
id
(node ID), type (node type—that is,
ndbd
,
mysqld
, or
ndb_mgmd
), and
any configuration parameters whose values are to be obtained.
For example,
--query=id,type,indexmemory,datamemory
returns the node ID, node type,
DataMemory
[1559] , and
IndexMemory
[1560] for each node.
Note
If a given parameter is not applicable to a certain type of node, than an empty
string is returned for the corresponding value. See the examples later in this
section for more information.
•
--host=hostname
Command-Line Format
--host=name
Permitted Values
Type
string
Default
Specifies the host name of the node for which configuration information is to be obtained.
Note
While the hostname
localhost
usually resolves to the IP address
127.0.0.1
, this may not necessarily be true for all operating platforms and
configurations. This means that it is possible, when
localhost
is used in
config.ini
, for
ndb_config --host=localhost
to fail if
ndb_config
is run on a different host where
localhost
resolves to a different address
(for example, on some versions of SUSE Linux, this is
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
localhost
in the same fashion.
•
--id=node_id
--nodeid=node_id
Either of these options can be used to specify the node ID of the node for which configuration
information is to be obtained.
--nodeid
is the preferred form.
•
--nodes
Command-Line Format
--nodes
Permitted Values
Type
boolean