From: Luca Villani
Date: July 9 2004 3:23pm
Subject: Re: One frontend don't see changes made by another frontend
List-Archive: http://lists.mysql.com/cluster/112
Message-Id: <200407091723.13642.luca.villani@wseurope.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Alle 15:15, venerd=EC 9 luglio 2004, Martin Skold ha scritto:


> Also the creation of new databases is currently also not propagated
> between MySQL instances.
>
> This means you currently need to do "CREATE DATABASE ..;"
> on all MySQL instances.

Thank you very much, now every frontend seems to work fine. :-)

Here there is another question: as long as mysqld normally store permission=
s=20
in standard tables of mysql database, stored on local filesystem, do we nee=
d=20
to grant privileges onto all mysqld frontend?



> Any query referencing the table created through another MySQL instance
> will then make it visible and you can see it in a "SHOW TABLES;"

I've tested it and it's right.


But during a simple test I'm going in trouble with a simple update: I found=
=20
the OperationRecords limit... ;-)

As long as we normally perform a 2-3.000.000 lines updates, are there some=
=20
problems in setting an appropriate OperationRecords limit?

Occasionally we've performed an alter table on very big tables (15-25.000.0=
00=20
lines), are there some problem on ndb?




P.S.: yes, we work togheter all italian mobile telcos... :-)



=2D-=20
Luca Villani                Wireless Solutions spa - DADA group
NOC manager                 Europe HQ, via Castiglione 25 Bologna
http://www.wseurope.com     Tel: +39 051 2966826    Fax: +39 051 2966800
GPG public key available    Mobile: +39 348 5298542 UIN: 76272621