MySQL Forums
Forum List  »  NDB clusters

dynamic database model
Posted by: Balasubramanian Azhagappan
Date: February 16, 2005 03:43AM

Hello,
I have a question regarding dynamic change of database table structure.

I had some 10 clients doing Read/Write operation on 6 tables randomly. The tables has 1 Million Records each.
Then i altered one table, by adding an integer field. During the operation there was no problem at the client sides.
But when the operation was about to finish, all clients say
"Got Error 241; Invalid Schema Object Version from ndbcluster."

from the query to the table in which i was altering.

Is it that i miss something here. Should i need to increase the ConcurrentOperations value in config.ini or something like else...

If i stop the clients and do the above operation, i have no problem and it says that it has altered 1 Million Rows. The total operation took roughly around 3 mins to complete.

I need this dynamic altering behaviour very badly. Its very important for our project. This is an important parameter from which it will be decided whether to take MYSQL CLUSTER or not.

Thanks in advance.

regards,
Bala

Options: ReplyQuote


Subject
Views
Written By
Posted
dynamic database model
3394
February 16, 2005 03:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.