Schema Changes

[David Rusenko]

Hi All,

What is the preferred method to change table schema while the cluster is online? Our current configuration is of 2 data nodes (NDBD), 1 management node, and 2 api nodes. All are version 5.0.18.

We have noticed that sometimes when doing a schema change (alter table add...) about every 1 out of 4 times, the entire cluster will come crashing down (first data node will come down -- Node 2: Forced node shutdown completed. Initiated by signal 11. Caused by error 6000: 'Error OS signal received(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'. -- and then the next data node will come down shortly afterwards). When restarting, the cluster will start, then come down again in the same way -- only solution is to flush data and start new with --initial.

We must be doing something wrong here. What is the best way to change table schema while the cluster is online?

Thanks!

-David