Hello All: Thank you for all the advise provided on this issue. Much appreciate Andrew's detailed answers and alternate solution.
I will investigate the Replication method and try to devise some strategy to make sure that the Slave mirrors the Master as closely as possible. Also taking advantage of using the Slave to read data off from can prove to be very advantageous to me. Again, thank you all very much. Gowtham. --- Russell Horn <[EMAIL PROTECTED]> wrote: > Andrew Braithwaite wrote: > > > Each slave keeps a heartbeat to the master and in > the event of a failure, > > changes it's master to master2. > > So how does this bit work? If one master falls over > and slaves move to > master two, how do you rebuild master one without > downtime? Don't the slaves > try and use Master 1 as soon as it's back online > even though its data is out > of sync? > > What if one of the slaves loses its heartbeat with > master one and falls over > to master two when other slaves can still see master > one. Don't you then > have inconsistencies in your data? > > Russell. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
