List:Cluster« Previous MessageNext Message »
From:Martin Skold Date:February 9 2010 7:41am
Subject:Re: Location of Data in MySQL Cluster
View as plain text  
Hi!

Yes, internally the primary key can be used
to locate the primary partition (when using
default partitioning). This is used to decide
where the transaction coordinator should run,
the primary key of the first row (if available)
is used as "hint" when starting the transaction.
For user defined partitioning the partitioning
function decides.
This is transparent from SQL, but can be controlled
in the low level API (Ndb API).

BR
-- Martin

Anand Sriraman wrote:
> Hi,
> 
> I want to know whether it is possible to know which partitions of a table
> are stored in which data nodes (replicas and originals). Also is it possible
> to know that when an insert query is performed which data node the info is
> being written to?
> 
Thread
Location of Data in MySQL ClusterAnand Sriraman9 Feb
  • Re: Location of Data in MySQL ClusterMartin Skold9 Feb
    • Re: Location of Data in MySQL ClusterAnand Sriraman11 Feb
      • Re: Location of Data in MySQL ClusterMatthew Montgomery11 Feb
        • Re: Location of Data in MySQL ClusterAnand Sriraman12 Feb