MySQL Forums
Forum List  »  NDB clusters

Re: Newbie/Basic Stuff
Posted by: Gordon Leonard
Date: January 04, 2007 02:50AM

Adam Dixon Wrote:
-------------------------------------------------------
> Gordon Leonard Wrote:
> --------------------------------------------------
> -----
>
> > What happens when a machine, acting as a node,
> > with data in memory crashes? If NoOfReplicas is
> 2,
> > then we have a back up of the data as we
> already
> > replicate it? I am currently watching the
> Google
> > MySQL cluster video and feel the topic of node
> > failure could be rather complex?!?!
>
> If you have 2 datanodes, and replicas =2, and a
> datanode fails. The cluster can continue to work
> as it still has a full copy of data.

If the one node fails, and then is rebooted (or what ever), will it automatically sync to match the same state as the other node which we assumed has been working correctly whilst importing new data?


>
> > What about backups? If we have a cluster that
> has
> > been running for a week say, where an amount of
> > data is being added regularly, should a backup
> of
> > the data be taken from memory every so often
> (is
> > there a ball park figure people suggest)?
>
> The cluster checkpoints data to disk periodically
> (configurable) so that there is generally always a
> copy of the data on disk in case of major
> failures, where all data from the last completed
> checkpoint will be available on the disk.
>
> Cluster backups can be done online, you can do
> these as often as you feel necessary.
>
> > Just one more.....
> > In 5.1, does data that can be stored on disk,
> > automatically do so (this is coming in the
> video
> > right now)?
>
> You specify this at table creation time or alter a
> table into using a tablespace, indexed columns
> will still use memory space allocations however.

Options: ReplyQuote


Subject
Views
Written By
Posted
1653
January 03, 2007 03:17PM
923
January 03, 2007 09:24PM
Re: Newbie/Basic Stuff
993
January 04, 2007 02:50AM
910
January 04, 2007 04:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.