Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 70: What is the correct order of actions to setup replication? – MySQL Question of the Day

Skip to content

Question 70: What is the correct order of actions to setup replication?

17. June 2010
By plogi in mysql questions

1 Comment

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. plogi — 17. 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.