Stewart,
Thanks so much. I will try that out and I think that
should solve my problem.
Regards
Brian
--- "Burnett, Stewart" <stewart.burnett@stripped>
wrote:
>
> Brian,
>
> Ndb.cfg (note case) needs to be set up in;
>
> ndbd start dir
> mysql data dir
>
> Contents:
> host=10.0.0.10:2200
>
> Where these refer to the host and port for the
> ndb_mgmd
> There are also command line options as an
> alternative when starting ndbd &
> mysqld
>
> Some links which give more details;
>
>
http://dev.mysql.com/doc/mysql/en/mysqld_process.html
> http://dev.mysql.com/doc/mysql/en/ndbd_process.html
>
> SB
>
> -----Original Message-----
> From: Brian L [mailto:tiger1763@stripped]
> Sent: 11 November 2004 00:57
> To: Burnett, Stewart; cluster@stripped
> Subject: RE: How to configure mysql cluster properly
>
>
> Hi,
>
> Thanks so much. I think I didnt set up the NDB.cfg
> properly. Do you know where I can find the
> information
> how to set up the NDB.cfg ?
>
> And I think I also start up the process in the
> different order. So it means that I have to start
> the
> ndb_mgmd first, then the ndbd.. then the mysqld,
> right.
>
> Regards
> Brian
> --- "Burnett, Stewart"
> <stewart.burnett@stripped>
> wrote:
>
> >
> > Hi,
> >
> > Looks like MySQL has not connected to NDBD.
> >
> > Try using ndb_mgm utility and use SHOW command.
> This
> > will tell you is every
> > thing is connected properly e.g.
> >
> > NDB> show
> > Cluster Configuration
> > ---------------------
> > [ndbd(NDB)] 2 node(s)
> > id=3 @127.0.0.1 (Version: 3.5.3, Nodegroup: 0,
> > Master)
> > id=4 (not connected, accepting connect from
> > 10.99.99.111)
> >
> > [ndb_mgmd(MGM)] 1 node(s)
> > id=1 @10.99.99.35 (Version: 3.5.3)
> >
> > [mysqld(API)] 2 node(s)
> > id=5 @127.0.0.1 (Version: 3.5.3)
> > id=6 @10.99.99.111 (Version: 3.5.3)
> >
> > Note in this example id=4 is not connected - one
> of
> > the NDB nodes. In your
> > case it sounds like the API node(s) have not
> > connected.
> >
> > Have you set up Ndb.cfg files correctly?
> >
> > Also need to start processes in order;
> >
> > ndm_mgmd on management server
> > ndbd on each server (using --initial option the
> > first time)
> > mysqld on each server
> >
> >
> >
> > SB
> >
> > -----Original Message-----
> > From: Brian L [mailto:tiger1763@stripped]
> > Sent: 10 November 2004 06:27
> > To: cluster@stripped
> > Subject: How to configure mysql cluster properly
> >
> >
> > Hi there,
> >
> > I was attempting to set up to run the mysql
> cluster
> > among two machines, so that when one machine down
> > and
> > the other can be up right away. Both of the
> machine
> > is
> > successfully running the mysqld daemon. And I set
> up
> > one machine as the management server. It ran the
> > ndbd
> > and ndb_mgmd daemon. And the other just ran the
> > ndbd.
> >
> > The following is my config.ini
> > [NDBD DEFAULT]
> > NoOfReplicas: 2
> >
> > [MYSQLD DEFAULT]
> > [NDB_MGMD DEFAULT]
> > [TCP DEAFULT]
> >
> > [NDB_MGMD]
> > HostName = 10.117.29.120
> >
> > [NDBD]
> > HostName = 10.117.29.120
> > DataDir: /var/local/mysql-cluster
> >
> > [NDBD]
> > HostName = 10.117.29.121
> > DataDir: /var/local/mysql-cluster
> >
> > [MYSQLD]
> > [MYSQLD]
> > [MYSQLD]
> >
> >
> > However, when I attempted to test and create table
> > on
> > one machine (e.g. 10.117.29.120), I got the error
> > message Error: Can't create table
> './test/ctest.frm'
> > (errno:4009).
> >
> > Please advice if anyone encountered similar
> > incidents.
> >
> >
> > Thanks so much
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Check out the new Yahoo! Front Page.
> > www.yahoo.com
> >
> >
> >
> > --
> > MySQL Cluster Mailing List
> > For list archives: http://lists.mysql.com/cluster
> > To unsubscribe:
> >
>
http://lists.mysql.com/cluster?unsub=1
> >
> >
> > This message contains information that may be
> > privileged or confidential and is the property of
> > the Capgemini Group. It is intended only for the
> > person to whom it is addressed. If you are not the
> > intended recipient, you are not authorized to
> read,
> > print, retain, copy, disseminate, distribute, or
> > use this message or any part thereof. If you
> receive
> > this message in error, please notify the sender
> > immediately and delete all copies of this
> message.
> >
> >
> > --
> > MySQL Cluster Mailing List
> > For list archives: http://lists.mysql.com/cluster
> > To unsubscribe:
> >
>
http://lists.mysql.com/cluster?unsub=1
> >
> >
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Check out the new Yahoo! Front Page.
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
