Good, but:
1. If any server fails, the system ensures the alteration will be undone in
the other servers (such as rollback)?
2. The system waits for the general aceptance (consensus) of the new
modification to 'commit' it into all?
FM
-----Mensagem original-----
De: Stewart Smith [mailto:stewart@stripped]
Enviada em: quinta-feira, 10 de novembro de 2005 21:53
Para: Fabricio Mota
Cc: cluster@stripped
Assunto: Re: Structures Replication
On Thu, 2005-11-10 at 21:13 -0300, Fabricio Mota wrote:
> I'm a novice in terms of MySQL cluster.
> Anybody could tell me if, when I proceed a structural modification (such
as
> create table or alter table), the cluster ensures the replication of the
> modification fidelly into the other machines?
> (i.e, is it warranted atomic and uniform replication?)
You should be careful when doing ALTER TABLE as table locks are not
replicated across mysql servers (yet).
There's information in the list archives on this topic - as well as in
the manual.
Also keep in mind that an ALTER TABLE creates a new table and copies
everything across - not exactly efficient for large tables. We are
working on making things more 'online' so that this copy doesn't occur.
--
Stewart Smith, 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
