From: Date: November 14 2007 3:42am
Subject: Re: Alter table in 5.0.45
List-Archive: http://lists.mysql.com/cluster/5461
Message-Id: <1195008166.15115.71.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-uqt3WNqllbFLK2K3ANWn"

--=-uqt3WNqllbFLK2K3ANWn
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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 column=
s
> 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.
--=20
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332

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

--=-uqt3WNqllbFLK2K3ANWn
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQIVAwUARzpgpb3yNwHyU3DLAQJ9yg//TlM9acRioUuMWq5Pg29JdSMbJYEADKyk
NhQI67e24xF1V6BSw05sj2c3DGad3+HixuEZpnBBPKJJdcoqbJvxILHM6KWfaIpY
FMF4bTufcvM0YRkgMMUOybBbPUf2X6x8npzLWNxPUz4LRXoPv7MBmTI98Ng4hM2f
f2p81a696DpZ3b+fSysOMGbpCry6+s/jUOOvapPBJ2gQJKE9RgK75HxDBeKY9N+L
g8VBbmQjFHtFEUNTP7l90Ob9u1b3QhTnDgYEv/3f+EteAN8a9a0R413rfVtiRL6h
sw1xnbNF1UghueYfSQe9cLrDvbdsGTr6gY+xENxIWWV1v1nZw+Y4W7wZ5EZoyy7T
Ga2DlmmfS1s0jNtIOwd4FhkOAdhO31hDRzbGYG6CtinsCUnVjlwn4EJR8OPrd88W
AFYma0ySc+F87dvDFhT6LDs+w5KKb6Ixsf/f+BUNMdYr448UZWYVPvl+gcsKpr48
S83dt8UAfwC9NWYH3rnshpp60cXfC417Vvi1odUwsiZDcg2Pp43TGksrtfdG41Mf
Q/mORsd/487UUr/hmXzMZSD7kYClboQ23+QRetMQlTeQCAmg0hxue13xXJ2TSQm5
kT+NfsQHw+KvFnibAAzHpuCH+t2BHJWFnB1KXmhs/X5owQe8grqgBRr1HZlVF/WQ
mAyWJ9x4oO0=
=znAF
-----END PGP SIGNATURE-----

--=-uqt3WNqllbFLK2K3ANWn--