From: Wagner Bianchi
Date: February 7 2011 2:52pm
Subject: Re: Hibernate - locking tables
List-Archive: http://lists.mysql.com/cluster/7972
Message-Id: <AANLkTi=vA3cKbxKbzHN7QpFVyDEY14OZ9D63Ds50tQkN@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f85bb832c968049bb260a7

--001485f85bb832c968049bb260a7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Martinez,

I understand the unique and efficient way to lock tables on MySQL Cluster
SQL NODES is using "SINGLE-USER MODE". LOCK TABLES [WRITE | READ] will work
as expected, but, using only one SQL NODE. You'll LOCK TABLE t1 TO WRITE on
SQL NODE 1, but your application will can access the same table through the
SQL NODE 2 and write to that table.

Let us know more about your project and perhaps we can help you.

Best regards.
--
Wagner Bianchi

2011/2/7 Diego Mart=EDnez <tabarem@stripped>

> Hi,
>
> Members of the list have experience using MySQL Cluster through Hibernate=
?
> I
> am worried, because I understand that MySQL Cluster does not support
> locking
> tables for example.
>
> Do you know design patterns to use this new engine?
>
> Best regards, Diego Mart=EDnez
>

--001485f85bb832c968049bb260a7--