Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have two instances of MySQL running one a server, set up as master and slave. It's all working smoothly together and I'm only using the slave instance for backups to avoid locking up the live databases.

What settings would be ideal to lower the Slave instance requirements as much as possible, that aren't important for replication performance. For example, would setting the innodb buffer to the minimal amount make sense? Are there any other bits of MySQL that could be lowered or turned off?


Alternative backup solutions may not be an option due to having to run on Windows.

share|improve this question

1 Answer 1

Just a suggestion, but maybe you could look at Percona's hot backup solution here? It's free and open source. It allows for the hot backing up of InnoDB tables. HTH, Paul...

share|improve this answer
    
Valid suggestion, unfortunately I'm required to run on top of Windows. From what I understand Percona were working on a Windows version of XtraBackup but it was only at an Alpha stage of development. –  Mister Dai Feb 17 at 10:16
    
Long shot maybe, but could you try cygwin? –  Vérace Feb 21 at 14:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.