Re: MySQL cluster works, but not copying tables

[Tim Pearson]

Thanks for your reply.

I had created the database as empty on both nodes. Do I need to create the tables on both nodes?

When I tried creating new tables on one node, the tables were not replicated to the other node.

Tim

---EDIT---

Could this be the problem:

All machines used in the cluster must have the same architecture; that is, all machines hosting nodes must be either big-endian or little-endian, and you cannot use a mixture of both. For example, you cannot have a management node running on a PPC which directs a data node that is running on an x86 machine. This restriction does not apply to machines simply running mysql or other clients that may be accessing the cluster's SQL nodes.

I am running the storage nodes on Fedora Core x86 (little endian) and the management node on OpenWRT (little endian).

Do the nodes have to be the same OS, or just the same endian-ness?

Tim

---EDIT AGAIN---

I THINK I FOUND IT!!!
But I don't know how to fix it....

The second node that I can't get to update is refusing to connect to the MySQLD(API). See ndb_mgm show results below:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.50 (Version: 4.1.14, Nodegroup: 0, Master)
id=3 @192.168.0.55 (Version: 4.1.14, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.12 (Version: 4.1.14)

[mysqld(API)] 2 node(s)
id=4 @192.168.0.50 (Version: 4.1.14)
id=5 (not connected, accepting connect from any host)

Two questions:

1. Why is it connected to the storage node and not the API node
2. Would this cause the symptoms I am experiencing?

Thanks,

Tim



Edited 3 time(s). Last edit at 10/14/2005 02:09AM by Tim Pearson.