Joseph and Devananda --
That was it. When I first set up MySQL Cluster I used TYPE=NDB.
I inadvertently dropped it in my testing somewhere along the line.
Thanks!
-- Jim
--- "Joseph E. Sacco, Ph.D." <jsacco@stripped> wrote:
> Hello Jim,
>
> At the risk of stating the obvious, did you specify TYPE=NDB when
> creating the cluster tables?
>
> I have observed that a mysql server can have both local and cluster
> tables. If a table is not in the cluster, other mysql servers connected
> to the cluster will never see it.
>
> I did a simple experiment using the "test" database that is present with
> all MySQL installs. I first created a table in the cluster [TYPE=NDB]
> using a mysql server on one conputer. On a different computer I then
> fired up another mysql server that was connected to the cluster. The
> cluster table "magically" appeared.
>
> I then shut down one of the mysql servers, edited it's my.cnf file to
> remove it from the cluster, and brought it back up again. The server
> knew about the existence of cluster table [metadata had been copied
> locally] but certainly could not access the data. I then dropped that
> table the database, brought down the mysql server, edited it's my.cnf to
> put it back into the cluster, and brought the server back up. Like
> "magic" the cluster table reappeared.
>
> Hope that helps...
>
>
> -Joseph
>
> =============================================================
>
>
> On Fri, 2004-07-09 at 18:14, Jim Hoadley wrote:
> > Hello --
> >
> > I have a similar problem to the one Luca describes.
> >
> > 2 nodes on 2 computers (configured for 2 replicas)
> > 2 APIs on these same 2 computers
> >
> > All NDB tests are fine, meaning I can CREATE, INSERT, DELETE, SELECT as
> well as
> > stop either node. However I can only "see" the Cluster database from one of
> the
> > APIs. Connecting to the other, the database doesn't exist.
> >
> > Martin's suggestion 'need to do "CREATE DATABASE ..;" on all MySQL
> instances'
> > did not fix my problem.
> >
> > Sequence I follow is:
> >
> > 1. connect (from 3rd computer) to API on node_1 and create database
> >
> > mysql> create table city(col1 integer not null primary key, col2
> char(20));
> > Query OK, 0 rows affected (0.04 sec)
> >
> > mysql> insert into city values(1, 'Walnut Creek');
> > Query OK, 1 row affected (0.03 sec)
> >
> > mysql> insert into city values(2, 'Bologna');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select * from city;
> > +------+--------------+
> > | col1 | col2 |
> > +------+--------------+
> > | 1 | Walnut Creek |
> > | 2 | Bologna |
> > +------+--------------+
> > 2 rows in set (0.00 sec)
> >
> > mysql> quit
> > Bye
> >
> > 2. connect (from 3rd computer) to the API on node_2 and read from database
> >
> > mysql> select * from city;
> > Empty set (0.00 sec)
> >
> > mysql> quit
> > Bye
> >
> > I'm starting the API on node_1 with the connect string like:
> > export NDB_CONNECTSTRING="host=localhost:2200;nodeid=11"
> > I'm starting the API on node_2 with the connect string like:
> > export NDB_CONNECTSTRING="host=node_1:2200;nodeid=12"
> >
> > I can see the API connected to the mgm_ndbd on node_1
> >
> > NDB> show
> > Cluster Configuration
> > ---------------------
> > 2 NDB Node(s)
> > DB node: 2 (Version: 3.5.0)
> > DB node: 3 (Version: 3.5.0)
> >
> > 4 API Node(s)
> > API node: 11 (Version: 3.5.0)
> > API node: 12 (Version: 3.5.0)
> > API node: 13 (not connected)
> > API node: 14 (not connected)
> >
> > 1 MGM Node(s)
> > MGM node: 1 (Version: 3.5.0)
> >
> > NDB>
> >
> > Am I missing something? Any debugging ideas?
> >
> > -- Jim
> > Jim Hoadley
> > Senior Software Engineer
> >
> > Dealer Fusion, Inc.
> > 1450 Enea Circle, Suite 100
> > Concord, CA 94520
> > j_hoadley[at]yahoo[dot]com
> > (925) 969-8300 x125
> >
> >
> > --- Luca Villani <luca.villani@stripped> wrote:
> > > Alle 15:15, venerd 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
> permissions
> > > in standard tables of mysql database, stored on local filesystem, do we
> need
> > > 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
> > > the OperationRecords limit... ;-)
> > >
> > > As long as we normally perform a 2-3.000.000 lines updates, are there
> some
> > > problems in setting an appropriate OperationRecords limit?
> > >
> > > Occasionally we've performed an alter table on very big tables
> (15-25.000.000
> > >
> > > lines), are there some problem on ndb?
> > >
> > >
> > >
> > >
> > > P.S.: yes, we work togheter all italian mobile telcos... :-)
> > >
> > >
> > >
> > > --
> > > 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
> > >
> > >
> > > --
> > > MySQL Cluster Mailing List
> > > For list archives: http://lists.mysql.com/cluster
> > > To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
> > >
> > >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > New and Improved Yahoo! Mail - Send 10MB messages!
> > http://promotions.yahoo.com/new_mail
> --
> Joseph E. Sacco, Ph.D. <jsacco[at]earthlink[dot]net>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
