Hi,
Peter Santos wrote:
> 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.
>
And here's my final answer :)
You can create the table in any MySQL Server and you can see all the content of it from
any MySQL Server. To see the tables you need to create the same database in all MySQL
Servers but the tables are "auto-discovered" if the database exists and you try to use the
tables.
The actual content of the tables are stored in the data nodes of the cluster and distribution
is transparent to the server.
> 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 ???
>
Correct on last question and first question was answered above I hope.
> Thanks for all your feedback.
> --peter
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com