Re: Newbie/Basic Stuff
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.
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
951
January 10, 2007 03:40AM
914
January 28, 2007 07:25PM
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.