5

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.

asked Feb 7, 2014 at 8:54

1 Answer 1

3
+25

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...

answered Feb 13, 2014 at 12:26
2
  • 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. Commented Feb 17, 2014 at 10:16
  • Long shot maybe, but could you try cygwin? Commented Feb 21, 2014 at 14:39

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.