Re: mysql cluster on Windows Server 2008r2
Posted by:
LUCA FATA
Date: March 13, 2012 05:04AM
If I try to run the show command I see this result:
ndb_mgm> show
Cluster Configuration
---------------------
[Ndbd (NDB)] 2 node (s)
id = 2@192.168.1.2 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0,
id = 3@192.168.1.3 (mysql-5.5.19 ndb-7.2.4, Nodegroup: 0)
[Ndb_mgmd (MGM)] 1 node (s)
id = 1@192.168.1.4 (mysql-5.5.19 ndb-7.2.4)
[Mysqld (API)] 2 node (s)
id = 101 (not connected, accepting connect from 192.168.1.4)
id = 102 (not connected, accepting connect from 192.168.1.4)
or by status to see this:
ndb_mgm> all status
Node 2: started (mysql-5.5.19 ndb-7.2.4)
Node 3: started (mysql-5.5.19 ndb-7.2.4)
I see this engine while throwing the show:
mysql> SHOW ENGINES
->;
+ -------------------- + --------- + ------------------ ------------------------------
---------------- + -------------- + ------ + ----------- - +
| Engine | Support | Comment
| Transactions | XA | Savepoints |
+ -------------------- + --------- + ------------------ ------------------------------
---------------- + -------------- + ------ + ----------- - +
| FEDERATED | NO | Federated MySQL storage engine
| NULL | NULL | NULL |
| MRG_MYISAM | YES | Collection of identical MyISAM tables
| NO | NO | NO |
| MyISAM | YES | MyISAM storage engine
| NO | NO | NO |
| BLACKHOLE | YES | / dev / null storage engine (anything you write to
Disappears en) | NO | NO | NO |
| CSV | YES | CSV storage engine
| NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for tempor
ary tables | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine
| NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and f
oreign keys | YES | YES | YES |
| PERFORMANCE_SCHEMA | YES | Performance Scheme
| NO | NO | NO |
+ -------------------- + --------- + ------------------ ------------------------------
---------------- + -------------- + ------ + ----------- - +
9 rows in set (0.00 sec)
my cnf files and are configured so ... I can not figure out where wrong ..
[mysqld]
ndb-nodeid = 101
ndbcluster
datadir = C: \ Users \ Administrator \ MySql_Cluster \ My_Cluster \ data \ Node1
port = 3306
ndb-ConnectString = 192.168.1.4: 1186
thanks again
Subject
Views
Written By
Posted
2278
March 12, 2012 10:44AM
1155
March 13, 2012 01:49AM
907
March 13, 2012 02:55AM
922
March 13, 2012 04:45AM
Re: mysql cluster on Windows Server 2008r2
969
March 13, 2012 05:04AM
914
March 14, 2012 03:48AM
848
March 14, 2012 04:16AM
968
March 14, 2012 06:05AM
824
March 14, 2012 06:19AM
1590
March 14, 2012 06:52AM
936
March 14, 2012 10:43AM
857
March 15, 2012 06:33AM
1047
March 15, 2012 08:12AM
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.