MySQL Forums
Forum List  »  MySQL Administrator

backing up mysql binlogs
Posted by: Oliver Leach
Date: June 02, 2013 05:19AM

Hi,

I would like to implement a mysql backup schedule on my database which is in master / slave replication. My DB is around 10GB, with 1-2 tables about 1GB large. I would like to avoid locking these tables if necessary.

I am backing up the database at 6:00am using mysql dump. Should I be backing up the mysql binlog files hourly to get a point in time (within the hour) recovery? I would be using mysqlbinlog tool to do this and therefore this method I assume would avoid locking the tables appart from @ 6:00am.

Should I flush the mysqlbinlogs after the backup?

What would happen to the replication is I flushed the mysql binlog files?

Many thnaks,
Oli



Edited 1 time(s). Last edit at 06/02/2013 05:20AM by Oliver Leach.

Options: ReplyQuote


Subject
Written By
Posted
backing up mysql binlogs
June 02, 2013 05:19AM


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.