Re: Is Clustering the right solution for me ?

[Peter Santos]

That's what I thought....
My last and final question.... Let's say I do have 2 MySQL sql nodes. Can the data be different between the 2 MySQL sql nodes. What I mean is if I create table T1 in the sql node 1, and T2 in my sql node 2, can I query any of the sql nodes to get to both table T1 and T2 or must I query node 1 for table T1 and node 2 for table T2.

From what I've been reading and your feedback it seems to be that I can split the tables between different MySQL sql nodes, and have it all reside in a cluster that has 1 or more replicates, but I do have to query the MySQL sql node where the table was created... This clustered (in-memory) data can then be split among n number of physical machines to sustain the memory requirements ???

Thanks for all your feedback.
--peter