Re: Mysqld Start failed. * 22: Error * The process has wrong type. Expected a DB process.: Permanent error: Application error
Jonathan Stephens Wrote:
-------------------------------------------------------
> Hi Timothy, that's not how you start an SQL node.
> START in the ndb_mgm client works only with data
> nodes.
>
> To start a MySQL server with the NDB support
> enabled, start it with the --ndbcluster option. To
> tell it which cluster it needs to join, start it
> with the --ndb-connectstring option also.
>
> The cluster must be running first, of course. Then
> you can start the SQL node from your system shell
> like this:
>
>
mysqld_safe --ndbcluster
> --ndb-connectstring=192.168.168.187 &
>
> Or put the options in a configuration file that's
> read by mysqld.
>
> Hope this helps.
Hi Stephens, thanks for your reply. I files were stored in another location. Hence the command below. Also an abstract from the error log, whats the problem here?:
[root@SQL1 ~]# tail -f /opt/SQL/61/mysqld.61.err
2014-12-11 10:45:42 2761 [Note] InnoDB: Waiting for purge to start
2014-12-11 10:45:42 2761 [Note] InnoDB: 5.6.15 started; log sequence number 2344998
2014-12-11 10:45:42 2761 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-11 10:45:42 2761 [Note] IPv6 is available.
2014-12-11 10:45:42 2761 [Note] - '::' resolves to '::';
2014-12-11 10:45:42 2761 [Note] Server socket created on IP: '::'.
2014-12-11 10:45:43 2761 [Note] Event Scheduler: Loaded 0 events
2014-12-11 10:45:43 2761 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.15-ndb-7.3.4-cluster-commercial-advanced' socket: '/opt/SQL/61/mysql.socket' port: 3306 MySQL Cluster Server - Advanced Edition (Commercial)
2014-12-11 10:46:13 2761 [Warning] NDB : Tables not available after 30 seconds. Consider increasing --ndb-wait-setup value
[root@SQL1 ~]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @192.168.168.179 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0, *)
id=2 @192.168.168.185 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0, *)
[ndb_mgmd(MGM)] 1 node(s)
id=51 @192.168.168.187 (mysql-5.6.15 ndb-7.3.4)
[mysqld(API)] 3 node(s)
id=61 (not connected, accepting connect from 192.168.168.187)
id=63 (not connected, accepting connect from 192.168.168.174)
id=65 (not connected, accepting connect from any host)