PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the--timeout limit is exceeded, then exits. By default, it waits for the cluster to achieveSTARTED status, in which all nodes have started and connected to the cluster. This can be overridden using the--no-contact and--not-started options.
The node states reported by this utility are as follows:
NO_CONTACT: The node cannot be contacted.UNKNOWN: The node can be contacted, but its status is not yet known. Usually, this means that the node has received aSTARTorRESTARTcommand from the management server, but has not yet acted on it.NOT_STARTED: The node has stopped, but remains in contact with the cluster. This is seen when restarting the node using the management client'sRESTARTcommand.STARTING: The node'sndbd process has started, but the node has not yet joined the cluster.STARTED: The node is operational, and has joined the cluster.SHUTTING_DOWN: The node is shutting down.SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode.
Options that can be used withndb_waiter are shown in the following table. Additional descriptions follow the table.
Table 25.51 Command-line options used with the program ndb_waiter
| Format | Description | Added, Deprecated, or Removed |
|---|---|---|
| Directory containing character sets | REMOVED: 8.0.31 | |
| Number of times to retry connection before giving up | (Supported in all NDB releases based on MySQL 8.0) | |
| Number of seconds to wait between attempts to contact management server | (Supported in all NDB releases based on MySQL 8.0) | |
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) | |
| Write core file on error; used in debugging | REMOVED: 8.0.31 | |
| Read given file after global files are read | (Supported in all NDB releases based on MySQL 8.0) | |
| Read default options from given file only | (Supported in all NDB releases based on MySQL 8.0) | |
| Also read groups with concat(group, suffix) | (Supported in all NDB releases based on MySQL 8.0) | |
| Display help text and exit | (Supported in all NDB releases based on MySQL 8.0) | |
| Read given path from login file | (Supported in all NDB releases based on MySQL 8.0) | |
| 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 8.0) | |
| Same as --ndb-connectstring | (Supported in all NDB releases based on MySQL 8.0) | |
| Set node ID for this node, overriding any ID set by --ndb-connectstring | REMOVED: 8.0.31 | |
| Enable optimizations for selection of nodes for transactions. Enabled by default; use --skip-ndb-optimized-node-selection to disable | REMOVED: 8.0.31 | |
| Wait for cluster to reach NO CONTACT state | (Supported in all NDB releases based on MySQL 8.0) | |
| Do not read default options from any option file other than login file | (Supported in all NDB releases based on MySQL 8.0) | |
| Wait for cluster to reach NOT STARTED state | (Supported in all NDB releases based on MySQL 8.0) | |
| List of nodes not to be waited for | (Supported in all NDB releases based on MySQL 8.0) | |
| Print program argument list and exit | (Supported in all NDB releases based on MySQL 8.0) | |
| Wait for cluster to enter single user mode | (Supported in all NDB releases based on MySQL 8.0) | |
| Wait this many seconds, then exit whether or not cluster has reached desired state | (Supported in all NDB releases based on MySQL 8.0) | |
| Display help text and exit; same as --help | (Supported in all NDB releases based on MySQL 8.0) | |
| Set output verbosity level; see text for input and return values | ADDED: 8.0.37 | |
| Display version information and exit | (Supported in all NDB releases based on MySQL 8.0) | |
| List of nodes to be waited for | (Supported in all NDB releases based on MySQL 8.0) |
Usage
ndb_waiter [-cconnection_string]Additional Options
Command-Line Format --character-sets-dir=pathRemoved 8.0.31 Directory containing character sets.
Command-Line Format --connect-retries=#Type Integer Default Value 12Minimum Value 0Maximum Value 12Number of times to retry connection before giving up.
Command-Line Format --connect-retry-delay=#Type Integer Default Value 5Minimum Value 0Maximum Value 5Number of seconds to wait between attempts to contact management server.
Command-Line Format --connect-string=connection_stringType String Default Value [none]Same as
--ndb-connectstring.Command-Line Format --core-fileRemoved 8.0.31 Write core file on error; used in debugging.
Command-Line Format --defaults-extra-file=pathType String Default Value [none]Read given file after global files are read.
Command-Line Format --defaults-file=pathType String Default Value [none]Read default options from given file only.
Command-Line Format --defaults-group-suffix=stringType String Default Value [none]Also read groups with concat(group, suffix).
Command-Line Format --login-path=pathType String Default Value [none]Read given path from login file.
Command-Line Format --helpDisplay help text and exit.
Command-Line Format --ndb-connectstring=connection_stringType String Default Value [none]Set connect string for connecting to ndb_mgmd. Syntax: "[nodeid=id;][host=]hostname[:port]". Overrides entries in NDB_CONNECTSTRING and my.cnf.
Command-Line Format --ndb-mgmd-host=connection_stringType String Default Value [none]Same as --
ndb-connectstring.Command-Line Format --ndb-nodeid=#Removed 8.0.31 Type Integer Default Value [none]Set node ID for this node, overriding any ID set by
--ndb-connectstring.--ndb-optimized-node-selectionCommand-Line Format --ndb-optimized-node-selectionRemoved 8.0.31 Enable optimizations for selection of nodes for transactions. Enabled by default; use
--skip-ndb-optimized-node-selectionto disable.--no-contact,-nInstead of waiting for the
STARTEDstate,ndb_waiter continues running until the cluster reachesNO_CONTACTstatus before exiting.Command-Line Format --no-defaultsDo not read default options from any option file other than login file.
Instead of waiting for the
STARTEDstate,ndb_waiter continues running until the cluster reachesNOT_STARTEDstatus before exiting.When this option is used,ndb_waiter does not wait for the nodes whose IDs are listed. The list is comma-delimited; ranges can be indicated by dashes, as shown here:
$> ndb_waiter --nowait-nodes=1,3,7-9ImportantDonot use this option together with the
--wait-nodesoption.Command-Line Format --print-defaultsPrint program argument list and exit.
--timeout=,seconds-tsecondsTime to wait. The program exits if the desired state is not achieved within this number of seconds. The default is 120 seconds (1200 reporting cycles).
The program waits for the cluster to enter single user mode.
Command-Line Format --usageDisplay help text and exit; same as
--help.Command-Line Format --verbose=#Introduced 8.0.37 Type Integer Default Value 2Minimum Value 0Maximum Value 2Controls verbosity level of printout. Possible levels and their effects are listed here:
0: Do not print (return exit code only; see following for exit codes).1: Print final connection status only.2: Print status each time it is checked.This is the same behavior as in versions of NDB Cluster previous to 8.4.
Exit codes returned byndb_waiter are listed here, with their meanings:
0: Success.1: Wait timed out.2: Parameter error, such as an invalid node ID.3: Failed to connect to the management server.
Command-Line Format --versionDisplay version information and exit.
--wait-nodes=,list-wlistWhen this option is used,ndb_waiter waits only for the nodes whose IDs are listed. The list is comma-delimited; ranges can be indicated by dashes, as shown here:
$> ndb_waiter --wait-nodes=2,4-6,10ImportantDonot use this option together with the
--nowait-nodesoption.
Sample Output. Shown here is the output fromndb_waiter when run against a 4-node cluster in which two nodes have been shut down and then started again manually. Duplicate reports (indicated by...) are omitted.
$> ./ndb_waiter -c localhostConnecting to mgmsrv at (localhost)State node 1 STARTEDState node 2 NO_CONTACTState node 3 STARTEDState node 4 NO_CONTACTWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 UNKNOWNState node 3 STARTEDState node 4 NO_CONTACTWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 STARTINGState node 3 STARTEDState node 4 NO_CONTACTWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 STARTINGState node 3 STARTEDState node 4 UNKNOWNWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 STARTINGState node 3 STARTEDState node 4 STARTINGWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 STARTEDState node 3 STARTEDState node 4 STARTINGWaiting for cluster enter state STARTED...State node 1 STARTEDState node 2 STARTEDState node 3 STARTEDState node 4 STARTEDWaiting for cluster enter state STARTED If no connection string is specified, thenndb_waiter tries to connect to a management onlocalhost, and reportsConnecting to mgmsrv at (null).
Prior to NDB 8.0.20, this program printedNDBT_ProgramExit - upon completion of its run, due to an unnecessary dependency on thestatusNDBT testing library. This dependency has been removed, eliminating the extraneous output.
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0