2
.\" Title: \fBndb_waiter\fR
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
.\" Manual: MySQL Database System
10
.TH "\FBNDB_WAITER\FR" "1" "03/01/2010" "MySQL 5\&.1" "MySQL Database System"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
23
ndb_waiter \- wait for MySQL Cluster to reach a given status
25
.HP \w'\fBndb_waiter\ \fR\fB\fIoptions\fR\fR\ 'u
26
\fBndb_waiter \fR\fB\fIoptions\fR\fR
30
repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the
32
limit is exceeded, then exits\&. By default, it waits for the cluster to achieve
34
status, in which all nodes have started and connected to the cluster\&. This can be overridden using the
37
\fB\-\-not\-started\fR
39
Additional Options)\&.
41
The node states reported by this utility are as follows:
51
NO_CONTACT: The node cannot be contacted\&.
62
UNKNOWN: The node can be contacted, but its status is not yet known\&. Usually, this means that the node has received a
66
command from the management server, but has not yet acted on it\&.
77
NOT_STARTED: The node has stopped, but remains in contact with the cluster\&. This is seen when restarting the node using the management client\'s
92
process has started, but the node has not yet joined the cluster\&.
103
STARTED: The node is operational, and has joined the cluster\&.
114
SHUTTING_DOWN: The node is shutting down\&.
125
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode\&.
134
ndb_waiter [\-c \fIconnect_string\fR]
140
\fBAdditional Options\fR:
150
.\" ndb_waiter: no-contact option
151
.\" no-contact option: ndb_waiter
152
\fB\-\-no\-contact\fR,
155
Instead of waiting for the
159
continues running until the cluster reaches
161
status before exiting\&.
172
.\" ndb_waiter: not-started option
173
.\" not-started option: ndb_waiter
174
\fB\-\-not\-started\fR
176
Instead of waiting for the
180
continues running until the cluster reaches
182
status before exiting\&.
193
.\" ndb_waiter: timeout option
194
.\" timeout option: ndb_waiter
195
\fB\-\-timeout=\fR\fB\fIseconds\fR\fR,
196
\fB\-t \fR\fB\fIseconds\fR\fR
198
Time 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)\&.
201
\fBSample Output\fR. Shown here is the output from
203
when run against a 4\-node cluster in which two nodes have been shut down and then started again manually\&. Duplicate reports (indicated by
204
\(lq\&.\&.\&.\(rq) are omitted\&.
210
shell> \fB\&./ndb_waiter \-c localhost\fR
211
Connecting to mgmsrv at (localhost)
213
State node 2 NO_CONTACT
215
State node 4 NO_CONTACT
216
Waiting for cluster enter state STARTED
221
State node 4 NO_CONTACT
222
Waiting for cluster enter state STARTED
225
State node 2 STARTING
227
State node 4 NO_CONTACT
228
Waiting for cluster enter state STARTED
231
State node 2 STARTING
234
Waiting for cluster enter state STARTED
237
State node 2 STARTING
239
State node 4 STARTING
240
Waiting for cluster enter state STARTED
245
State node 4 STARTING
246
Waiting for cluster enter state STARTED
252
Waiting for cluster enter state STARTED
253
NDBT_ProgramExit: 0 \- OK
263
.nr an-no-space-flag 1
271
If no connectstring is specified, then
273
tries to connect to a management on
274
localhost, and reports
275
Connecting to mgmsrv at (null)\&.
281
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
283
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.
285
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
287
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
290
For more information, please refer to the MySQL Reference Manual,
291
which may already be installed locally and which is also available
292
online at http://dev.mysql.com/doc/.
294
Sun Microsystems, Inc. (http://www.mysql.com/).