MySQL Forums
Forum List  »  Newbie

MySQL Cluster - 4 node - Windows - 1st Install
Posted by: Barry Banhagel
Date: September 18, 2014 09:41AM

I'm installing MySQL cluster on Windows 2008 R2. 4 node configuration using the setup GUI. Everything working as expected 2 mgmt nodes are up/running 2 data nodes are showing up/running but the SQL/API nodes are not starting.
All relevant folders have full permissions to "network service'
the my.cnf and my.ini were created by the cluster installer and appear to be in use by the service as the error logs are writing to the location defined by the my.cnf
here is the service startup command:

"E:\Program Files\MySQL\MySQL Cluster 7.3\bin\mysqld.exe" --defaults-file=E:/MySQL/Cluster01/DATA/57/my.cnf N57

here is the contents of the my.cnf file created by the installer:
#
# Configuration file for MySQLCluster01
# Generated by mcc
#
[mysqld]
log-error=mysqld.57.err
datadir="E:/MySQL/Cluster01/DATA/57/"
tmpdir="E:/MySQL/Cluster01/DATA/57/tmp"
basedir="E:/Program Files/MySQL/MySQL Cluster 7.3/"
port=3306
ndbcluster=on
ndb-nodeid=57
ndb-connectstring=172.28.77.198:1186,172.28.77.199:1186,

here are the contents of the error log for mysqld:
2014-09-18 10:08:46 2664 [Note] Plugin 'FEDERATED' is disabled.
E:\Program Files\MySQL\MySQL Cluster 7.3\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
2014-09-18 10:08:46 2664 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-09-18 10:08:46 2664 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-18 10:08:46 2664 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-18 10:08:46 2664 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-18 10:08:46 2664 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-18 10:08:46 2664 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-18 10:08:46 2664 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-18 10:08:46 2664 [Note] InnoDB: Completed initialization of buffer pool
2014-09-18 10:08:46 2664 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-18 10:08:46 2664 [Note] InnoDB: The log sequence numbers 1600717 and 1600717 in ibdata files do not match the log sequence number 1600777 in the ib_logfiles!
2014-09-18 10:08:46 2664 [Note] InnoDB: Database was not shutdown normally!
2014-09-18 10:08:46 2664 [Note] InnoDB: Starting crash recovery.
2014-09-18 10:08:46 2664 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-09-18 10:08:46 2664 [Note] InnoDB: Restoring possible half-written data pages
2014-09-18 10:08:46 2664 [Note] InnoDB: from the doublewrite buffer...
2014-09-18 10:08:46 2664 [Note] InnoDB: 128 rollback segment(s) are active.
2014-09-18 10:08:46 2664 [Note] InnoDB: Waiting for purge to start
2014-09-18 10:08:46 2664 [Note] InnoDB: 5.6.19 started; log sequence number 1600777
2014-09-18 10:08:46 2664 [Note] NDB: Changed global value of binlog_format from STATEMENT to MIXED
2014-09-18 10:08:47 2664 [Note] NDB: NodeID is 57, management server '172.28.77.198:1186'
2014-09-18 10:08:47 2664 [Note] NDB[0]: NodeID: 57, all storage nodes connected
2014-09-18 10:08:47 2664 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
2014-09-18 10:08:47 2664 [Note] Starting Cluster Binlog Thread
2014-09-18 10:08:47 2664 [Note] NDB Binlog: Ndb object created with reference : 0x80040039, name : Ndb Binlog schema change monitoring
2014-09-18 10:08:47 2664 [Note] NDB Binlog: Ndb object created with reference : 0x80050039, name : Ndb Binlog data change monitoring
2014-09-18 10:08:47 2664 [Note] Server hostname (bind-address): '*'; port: 3306
2014-09-18 10:08:47 2664 [Note] IPv6 is available.
2014-09-18 10:08:47 2664 [Note] - '::' resolves to '::';
2014-09-18 10:08:47 2664 [Note] Server socket created on IP: '::'.
2014-09-18 10:08:47 2664 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Options: ReplyQuote


Subject
Written By
Posted
MySQL Cluster - 4 node - Windows - 1st Install
September 18, 2014 09:41AM


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.