Hi Marcel, On Fri, Dec 5, 2008 at 2:02 PM, Marcel Grandemange <[EMAIL PROTECTED]> wrote: > Good Day. > > Im wondering if someone can assist me. > > Ive been using replication for a while now and it tends to fail very easily.
Do you have the error messages?. > > One of my sites lost connectivity for a while and when it came back > obviously replication broke again. If connectivity is lost it should recover later, how long is the network down for?. > > How can I get it to populate all data from master again? Depending on your data set size its probably easiest just to take a snapshot of and transfer from the master to slave with nc or some fast copy. > > Load data from master; is being depreciated and doesn't really work anyhow. > I do not wish to create dump and do this manually every time it fails. If replication stops you can restart it from the same position if the necessary binlogs are available, therefore unless something really bad has happened you dont need to copy all the data over. If you have some inconsistencies between the master and slave you can use something like the Maatkit mk-table-checksum and mk-sync-table tools to synchronize the data between the two. > > > Advise? > > Also is replication really this unreliable? It breaks at the slightest > hiccup... You will need to be more specific, what does "SHOW SLAVE STATUS\G" say when it fails. Cheers, Ewen > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
