Hi,
Peter Santos wrote:
> Great thanks for the information...
>
> I have one more question regarding the
> architecture. So if I used 8 ndb data storage
> nodes, how many MySQL
> nodes would I need? Would I just need 2? And
> does the amount of memory matter as much on the
> MySQL sql nodes?
The amount of MySQL servers is mostly dependent on the load you
want to achieve. More MySQL servers can generate more queries
towards the cluster. In most cases one tends to use as many MySQL
servers as data nodes but there is no rule about it. If 2 is enough to
handle the load then that is ok.
> I suspect that when the cluster shuts down, the
> data gets written to disk, but on which nodes, the
> ndb nodes or the
> MySQL sql nodes?
>
The data gets written in the ndb nodes so MySQL Servers can be stopped
without jeopardizing the cluster.
From the ndb nodes point of view the MySQL Servers are clients and these
can be started and stopped without affecting anybody else in the cluster.
Rgrds Mikael
> Thanks again
> --peter
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com