List:Cluster« Previous MessageNext Message »
From:Stewart Smith Date:November 11 2005 12:52am
Subject:Re: Structures Replication
View as plain text  
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

Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Thread
Disk-based storage...5.1?Jason Williams10 Nov
  • Re: Disk-based storage...5.1?Adam Dixon10 Nov
    • Re: Disk-based storage...5.1?Simon Garner10 Nov
RE: Disk-based storage...5.1?Jason Williams11 Nov
  • Re: Disk-based storage...5.1?pekka11 Nov
    • Structures ReplicationFabricio Mota11 Nov
      • Re: Structures ReplicationStewart Smith11 Nov
        • RES: Structures ReplicationFabricio Mota11 Nov
          • Re: RES: Structures ReplicationStewart Smith1 Feb
    • Re: Disk-based storage...5.1?Mark Kirkwood14 Nov
      • Re: Disk-based storage...5.1?pekka14 Nov
      • Re: Disk-based storage...5.1?Mikael Ronström15 Nov
RE: Disk-based storage...5.1?Jason Williams11 Nov
  • Re: Disk-based storage...5.1?Simon Garner11 Nov
  • Re: Disk-based storage...5.1?pekka11 Nov
    • Re: Disk-based storage...5.1?Kenji HIROHAMA11 Nov
  • RE: Disk-based storage...5.1?Stewart Smith12 Nov
RE: Disk-based storage...5.1?Jason Williams15 Nov
  • RE: Disk-based storage...5.1?Stewart Smith15 Nov
RE: Disk-based storage...5.1?Jason Williams15 Nov
  • Re: Disk-based storage...5.1?Simon Garner15 Nov