Skip to content

By plogi in mysql questions

With Mysql it can be challenging to backup large databases without read-locking the tables.
One way of getting around the problem is to setup mysql replication.
What is the correct order of the steps necessary?
 
a) verify slave status & error log
b) issue change master command
c) create consistent backup on master server & write down binlog position
d) start slave
e) restore backup on slave-server
 
[ Data Backup and Recovery Methods (15%) - Replication as an Aid to Backup ]

Tags: , ,

Comment Feed

One Response

  1. plogi17. June 2010 @ 18:13:56


    c e b d a

    Replication has more uses than only as a backup…
    Check http://dev.mysql.com/doc/refman/5.0/en/replication.html

You must be logged in to post a comment.