MySQL Forums
Forum List  »  NDB clusters

Test My Cluster ?
Posted by: Schinas Florian
Date: February 24, 2015 02:07AM

Hello everyone.

I received as a project of a company to make a MySQL clustering on a WAMP environment.
We're not going to dwell on the environment "WAMP", just know that I have to do this on Windows. I prefer my first focus on the pure Cluster than the rest.
I'll try to make a diagram that shows you more precisely my ultimate goal (which can be interesting).

So here's what I use now (I do not have the hardware limitation since I work on a hypervisor)
- 1 Windows Server 2008
- 2 Windows 7

For those who know, to make a MySQL Cluster requires at a minimum:
- 2 NBDB (Data Node): W7 DATA1 & W7 DATA2 (191.168.2.251 & .252).
- 1 SQL Server (mysqld): Windows Server 2008 R2 (191.168.2.3).
- 1 Manager (MGMD): Windows Server 2008 R2 (same as the mysqld) (191.168.2.3).
For the moment I tried to follow a lot of tutorials without really understand and get there (especially confusing saw that everything from in all directions) and apparently I get to make the connection between them:



Now I have a little problem, I do not know how to go test it .. I am trying to connect to MySQL on each DATA (to see if it is replica) but I can not I get an error:

"ERROR 2003 (HY000): Can not connect to MySQL server on localhost (10061)". Then I have difficulty understanding how a client that connects to the front-end (MySQ) written on the DATA ..
Well, I hope you can enlighten me.

Thank you,
Original.

Options: ReplyQuote


Subject
Views
Written By
Posted
Test My Cluster ?
2075
February 24, 2015 02:07AM
755
February 24, 2015 05:13AM
706
February 24, 2015 05:32AM
809
February 24, 2015 05:49AM
715
February 24, 2015 06:08AM
709
February 24, 2015 07:01AM
706
February 25, 2015 03:39AM
682
February 25, 2015 09:50AM
806
February 26, 2015 03:16AM


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.