7 messages in com.mysql.lists.clusterRe: error creating a table on cluster| From | Sent On | Attachments |
|---|---|---|
| Frank Xie | 25 Apr 2006 11:52 | |
| pek...@mysql.com | 25 Apr 2006 13:29 | |
| Frank Xie | 25 Apr 2006 13:34 | |
| Stewart Smith | 25 Apr 2006 14:14 | |
| Stewart Smith | 25 Apr 2006 14:15 | |
| Frank Xie | 25 Apr 2006 14:40 | |
| Ross McFarland | 25 Apr 2006 14:50 |
| Subject: | Re: error creating a table on cluster |
|---|---|
| From: | Ross McFarland (rwmc...@neces.com) |
| Date: | 04/25/2006 02:50:16 PM |
| List: | com.mysql.lists.cluster |
On 4/25/06, Frank Xie <fran...@yahoo.com> wrote:
I was trying to follow 5.0 manual 15.6.5.3 as much as possible. However, the
manual isn't very clear about a few things :
1. which process mgm ? ndbd ? mysqld ? need to be run before ndb_restore command
? What I found is that ndbds and ndb_mgmd have to run ahead of the restoration.
i think you'll need to start up all of the ndbd processes with --initial and to do that you'll have to have ndb_mgmd running.
2. Based on the manual, it seems to me that the database table definition and
triggers will be restored through ndb_restore too. However, after I ran
ndb_restore -m and ndb_restore -d sucessfully ( for restoring metadata and row
data ), I bring up mysql client and COULDN'T find the database and table
definitions.
only the table defs, not the triggers. triggers reside in the sql nodes, ndb doesn't know anything about them. it has no way to back them up. a related note is that you have to install all triggers etc on each sql node individually.
Thefefore, I feel it would be great if you can give a detailed step by step
restoration process, assuming there is only one nodegroup and replica = 2.
if you want step-by-step take a look at the book: http://www.amazon.com/gp/product/0672328550/sr=8-1/qid=1146001747/ref=pd_bbs_1/002-2492547-1598460?%5Fencoding=UTF8
-- -rm