MySQL Forums
Forum List  »  NDB clusters

Re: Mysqld Start failed. * 22: Error * The process has wrong type. Expected a DB process.: Permanent error: Application error
Posted by: Tim Lee
Date: December 10, 2014 08:51PM

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)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.