Hi,
On Sat, Feb 6, 2010 at 3:19 AM, Tom Hanlon <Tom.Hanlon@stripped> wrote:
> Anand Sriraman wrote:
>
>> Hi,
>> I want to know how to specify the config file for the mysqld process other
>> than my.cnf. I've tried
>>
>> mysqld --defaults-file=<path>
>>
>
> That command line option should tell mysqld to read that file and that file
> only.
>
> What would be needed in the mysqld section would be an
> ndb-connectstring=123.123.123.12
>
> And that should work.
>
That is exactly what I want. I want the mysqld process to "read that file
and that file only". Now the problem I'm getting is that the mysql command
doesn't return any error messages. However the API node doesn't show up as
connected in the mgmt node's show command.
When I execute "mysqld --defaults-file=<path>&" all I get is a message
giving me the process ID but it's not connecting to the Management server.
If I give "service mysql start" it gives me an error stating " Manager of
pid-file quit without updating.
The thing is I'm trying to install the Data and SQL process on the same
machine. So I configure the my.cnf file to suit the API node then the data
node doesn't connect and vice-versa.
>
> By default mysqld looks for a number of files, well the same file a number
> of locations.
>
> /etc/my.cnf
> /usr/local/mysql/my.cnf
> ~.my.cnf
>
> so it can get a little confusing.
>
> --defaults-file should overide this behavior and have mysql look for one
> file only.
>
> This page is a nice reference to all the options.
> http://dev.mysql.com/doc/refman/5.1/en/dynindex-option.html
>
> You could always try to start it with what you need on the command line and
> then sort it out from there.
>
> Something like.
> mysqld --nbd-conecstring= --ndbcluster(is this still needed ? )
> --user=mysql --skip-daefaults &&
>
> Beware of perhaps another mysqld laying around.. so many tools use mysql
> that which mysqld had better show you the mysqld that you are expecting.
>
> --
> Tom
>
>
>
>> but by doing this my API node isn't showing up as connected in the
>> management server when i try show command.
>>
>> This is related to my earlier query on setting up both API and data node
>> on
>> the same machine.
>> http://lists.mysql.com/cluster/7338
>>
>> Thanks in advance.
>>
>
>
> --
>
> Tom Hanlon
> Certified MySQL DBA
> Certified Cloudera Certified Hadoop Professional (CCHP)
>
>
--
Anand
