Software requirements for cluster
Setting up my first MySql Cluster(Linux):
1. For the "MySql Server" portion of the cluser, in the white paper it shows 3 machines, can I use one primary machine and use another linux machine I have that serves my intranet pages as a secondary "MySql Server" to prevent SPOF, or does it HAVE to be a dedicated, identical machine?
2.For the Management Node, that is required only for starting up the cluster but "not essental" while the cluster is up, can I use another linux machine I have that serves as an email server, so when it is not being a "Management Node" (sounds like MOST of the time from the whitepaper) It can still be a mail server?
3.For the Data Nodes: what kind of IP space do I need, and what ports will the interface need -- That is If I make the machine viewable from the intra/internet does only the top level "Web/Application/Mysql Server" need to be visable, or do the nodes need to be visable as well?
4.For Replication: If setting up an Identical Cluster for replication and backup at another site (to prevent SPOF).
A: Does the hardware need to be identical or can it be similar?
B: What kind of IP space will I need: will 2 "Web/Application/MySql Servers" need to see eachother, or the nodes directly.
C: What is the naming convention of the machines supposed to be like: Identical, or like Primary: "server1, node1a, node1b" / Replicated: "server2, node2a, node2b"
5.What kind of hardware do I REALLY need?
A: I know cluster is a memory baised database, but WHERE does the memory need to be? In the "Web/Application/MySql Servers" or In the Data Nodes?
B: Where does the storage really need to be -- can I do cluster with a 10 GB drive in the "Web/Application/MySql Servers" and Multi GB RAID at the nodes or do I need it both places?