From: Andrew Morgan
Date: September 13 2012 12:39pm
Subject: RE: Improve cluster performances in certain cases
List-Archive: http://lists.mysql.com/cluster/8401
Message-Id: <52529efd-dc91-405f-93fb-8197b73997b5@default>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi Jerome,

 No, there no such option. The MySQL Server must connect to all data nodes =
and for any given query will access the data node(s) where the active parti=
tion(s) for the row(s) is stored. The partitioning of the data between the =
data nodes is performed by hashing the primary key (or specific columns wit=
hin the PK if you override the default behaviour) and so you cannot force t=
hem to be in an active partition on a specific data node. There is no abili=
ty to read or write data in the secondary/backup partition on a data node.

Andrew.

> -----Original Message-----
> From: Jerome Blanchard [mailto:jerome.blanchard@stripped]
> Sent: 13 September 2012 12:31
> To: cluster@stripped
> Subject: Improve cluster performances in certain cases
>=20
> Hello,
>=20
> I have 4 data nodes on my cluster. NoOfReplica is set to 4.
>=20
> I have SQL nodes on the same servers.
>=20
> Is there a parameter to say "Connect to local data node if online" ? In
> =3D my case, it would prevent a lot of useless networking and improve =3D
> response times.
>=20
> Thank you
>=20
> Jerome
>=20
>=20
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster
>=20