Re: Alter table in 5.0.45

[Stewart Smith]

On Tue, 2007-11-13 at 12:07 -0800, Jonathan Haddad wrote:
> It's not clear to me whether or not I can alter tables.  Can I add columns
> and indexes once the cluster is being used?  Thanks.

You can do any ALTER you want. However, if a data node fails at the
"wrong" point, you'll need to restart the cluster before any more ALTERs
can be done. This is relatively rare though.

All ALTERs in 5.0 will be copying alter tables. That means while the
ALTER is taking place, no other node should write to the table. SINGLE
USER MODE is of use here.

Also, since it's a copying alter table, the table is locked (locally,
hence SINGLE USER MODE). So nobody can access the table. Also, it's
copying - which needs you need free DataMemory and IndexMemory for the
new AND old table.
-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: [phone] Ext: 6616
VoIP: 6616@stripped
Mobile: [phone]

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc

Attachment: [application/pgp-signature]