> I am trying to emulate on a single pc a multiple machine set up that we have
> put in place as a development resource for the cluster that we are building,
> v7.0.9. The cluster itself has a private lan on which to do the cluster
> synch operations as well as another lan that allows for other management
> When I emulate the set up on a single machine I have a very std 1
> management, 2 data node, 1 single sql api node setup.
> The problem that I have is that I am trying to get the sql api node to
> connect using a particular NIC address (the single machine has several
> virtual ip addresses) using the --defaults-file option when starting the
> mysqld process ie something like mysqld_safe --defaults-file=/path/to/my.cnf
> & and the my.cnf file has a corresponding bind-address in the file. It
> appears that the default file is ignored and an address is randomly grabbed
> and used for connection. If I try another approach of specifying all
> parameters on the command line, eg mysqld_safe
> --bind-address=192.168.100.101 --ndb-connectstring &,
This is what you actually used to start the mysqld?
--ndb-connectstring requires the IP address or hostname of the
management server. You also need --ndbcluster to enable NDB support.
mysqld_safe --ndbcluster --ndb-connectstring=192.168.100.100 &
Try that first (substituting the correct address for the management
server), make sure it works, then try restarting the mysqld with the
same options plus the --bind-address option.
this too appears to be
> ignored and I get error messages about 'Federated' plugin disabled, InnoDB
> started ......
> Can anyone confirm how to use default file or command line parameters with
> mysqld - a basic question I know but any help would be greatly appreciated.
Jon Stephens - jon.stephens@stripped
MySQL Documentation Team
Sun Microsystems AB
MySQL and Software Infrastructure Group
Liljeholmen (Stockholm), Sweden
Summer: UTC +02.00 / Winter: UTC +01.00
Mobile: +46 (0) 736 773 993