Paul,
you should only have to create database on both sides.
frm files should be automatic.
If this is not the case something else is wrong;
mysqld 1> create table t1... engine=ndb;
mysqld 1> insert into t1...
mysqld 2> select * from t1;
and you should see your data...
if not:
verify that ndb is enabled; show variables like '%ndb%'
verify that the other mysqld is connected; mysqld 2> create table t2...
engine=ndb;
T
Paul Gardner wrote:
>Thanks Jason - though I'm afraid that doesn't seem to be the case -
>looks like I also have to copy over the .frm file for each and every
>table. Is this normal?
>
>
>On Thu, 7 Oct 2004 22:00:15 -0600, Jason J. W. Williams
><williamsjj-subs@stripped> wrote:
>
>
>>Paul,
>>
>> I believe you have to do a "CREATE DATABASE <databasename>;" for
>>every API node. However, once you do that the NDB tables should show up
>>inside.
>>
>>Best Regards,
>>Jason
>>
>>
>>
>>-----Original Message-----
>>From: Paul Gardner [mailto:paul.gardner@stripped]
>>Sent: Thursday, October 07, 2004 8:05 PM
>>To: cluster@stripped
>>Subject: Cluster questions from a newbie
>>
>>Hi all
>>
>>New to clustering - installed it tonight.
>>
>>All seems to be working fine, but when I create a new database on one of the
>>API nodes, it doesn't seem to appear on the other API nodes?
>>
>>It works if I scp the database dir (and .frm files) from the data dir to the
>>data dir on the other API node - then, and only then, do records inserted on
>>one node appear on the other node.
>>
>>Is this normal or have I missed something? Is it safe to copy around .frm
>>files on a running database?
>>
>>Thanks
>>Paul
>>
>>--
>>MySQL Cluster Mailing List
>>For list archives: http://lists.mysql.com/cluster
>>To unsubscribe:
>>http://lists.mysql.com/cluster?unsub=1
>>
>>
>>
>>
>
>
>
