(mysql.info) multi-initial

(mysql.info) multi-load-data-queries
 
 15.3.4 Initial Startup
 ----------------------
 
 Starting the cluster is not very difficult after it has been
 configured. Each cluster node process must be started separately, and
 on the host where it resides. Although it is possible to start the
 nodes in any order, it is recommended that the management node be
 started first, followed by the storage nodes, and then finally by any
 SQL nodes:
 
   1. On the management host, issue the following command from the
      system shell to start the MGM node process:
 
           shell> ndb_mgmd -f /var/lib/mysql-cluster/config.ini
 
      Note that `ndb_mgmd' must be told where to find its configuration
      file, using the -f or -config-file option. (See 
      ndb-mgmd-process, for details.)
 
   2. On each of the data node hosts, run this command to start the
      `ndbd' process for the first time:
 
           shell> ndbd --initial
 
      Note that it is very important to use the -initial parameter
      _only_ when starting `ndbd' for the first time, or when restarting
      after a backup/restore operation or a configuration change. This
      is because the -initial option causes the node to delete any files
      created by earlier `ndbd' instances that are needed for recovery,
      including the recovery log files.
 
   3. If you used RPM files to install MySQL on the cluster host where
      the SQL node is to reside, you can (and should) use the startup
      script installed in `/etc/init.d' to start the MySQL server
      process on the SQL node. Note that you need to install the `-max'
      server RPM _in addition to_ the Standard server RPM to run the
      `-max' server binary.
 
 If all has gone well, and the cluster has been set up correctly, the
 cluster should now be operational. You can test this by invoking the
 `ndb_mgm' management node client.  The output should look like that
 shown here, although you might see some slight differences in the
 output depending upon the exact version of MySQL that you are using:
 
      shell> ndb_mgm
      -- NDB Cluster -- Management Client --
      ndb_mgm> SHOW
      Connected to Management Server at: localhost:1186
      Cluster Configuration
      ---------------------
      [ndbd(NDB)]     2 node(s)
      id=2    @192.168.0.30  (Version: 5.0.19, Nodegroup: 0, Master)
      id=3    @192.168.0.40  (Version: 5.0.19, Nodegroup: 0)
 
      [ndb_mgmd(MGM)] 1 node(s)
      id=1    @192.168.0.10  (Version: 5.0.19)
 
      [mysqld(SQL)]   1 node(s)
      id=4   (Version: 5.0.19)
 
 * If you are using an older version of MySQL, you may see the SQL
 node referenced as `[mysqld(API)]'. This reflects an older usage that
 is now deprecated.
 
 You should now be ready to work with databases, tables, and data in
 MySQL Cluster. See  multi-load-data-queries, for a brief
 discussion.
Info Catalog
(mysql.info) multi-config
(mysql.info) multi-computer
(mysql.info) multi-load-data-queries
automatically generated byinfo2html