Settings for a MySQL backup only slave instance

Posted on

Question :

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.

Answer :

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…

Leave a Reply

Your email address will not be published. Required fields are marked *