MySQL Forums
Forum List  »  NDB clusters

Re: SQL node not starting
Posted by: Shaun van Wyngaard
Date: November 28, 2017 07:40AM

Thank you for your response.

I edited my sql node's my.ini file and added the basedir & datadir options, it now looks like the following...

[mysqld]
# Options for mysqld process:
ndbcluster #run NDB storage engine
basedir=C:/MySQL/
datadir=C:/MySQL/Data

[mysql_cluster]
# Options for NDB Cluster processes:
ndb-connectstring=192.168.7.112 #location of management server 1


Again, it starts up and then seems to stop, i.e. giving me the normal command prompt again.

This is the contents of my error file:

2017-11-28T13:39:46.038508Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-28T13:39:46.397864Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-11-28T13:39:46.491616Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-11-28T13:39:46.585399Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 992aac5f-d441-11e7-98c6-000c29a6c4de.
2017-11-28T13:39:46.600992Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-11-28T13:39:46.600992Z 1 [Note] A temporary password is generated for root@localhost: m/tcel2e=y*J

This is what it looks like in the command prompt:
C:\mysql\bin>mysqld --initialize --user=mysql

C:\mysql\bin>



Edited 1 time(s). Last edit at 11/28/2017 07:41AM by Shaun van Wyngaard.

Options: ReplyQuote


Subject
Views
Written By
Posted
367
November 28, 2017 04:20AM
254
November 28, 2017 05:57AM
Re: SQL node not starting
157
November 28, 2017 07:40AM
136
November 29, 2017 02:06AM
137
November 29, 2017 06:19AM


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.