Some questions - MySQL Cluster
Hello everyone.
I created a new topic differentiate my two machinations.
I have currently implemented this with MySQL Cluster:
- 2 data nodes (Windows 7)
191.168.2.251
191.168.2.252
- 2 SQL nodes (API) - (Windows Server 2008)
191.168.2.2
191.168.2.3
- 2 Managers node (Windows Server 2008)
191.168.2.2
191.168.2.3
The cluster appears to work correctly, if a PC is dead, we always access to data, if the DATA down, you can still also.
Now I'd like to do two things, and therefore these are my questions:
- The users / programmers need access to MySQL course, however, I would like to ensure it only uses ONE IP and not the two APIs (invisible to them). How can I do?
- For now, to access MySQL, they use "phpMyAdmin" I like to know if there is something else that allows for MySQL Cluster? If possible with phpMyAdmin, do you know how?
- When my two DATA nodes is down, when I write on the other, it does not update when the UP DOWN returns. Is this normal? Can we do something about it?
Well, I hope you could help me, and I apologize for my English.
Best Regards,
Original.
Subject
Views
Written By
Posted
Some questions - MySQL Cluster
1760
February 26, 2015 07:33AM
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.