On 15.01.2012 19:58, Dieter Plaetinck wrote:
On Sat, 14 Jan 2012 22:07:43 +0100 Florian Pritz <bluewind@xinu.at> wrote:
On 14.01.2012 21:05, Ionut Biru wrote:
I was talking today with Florian about implementing a backup strategy, involving master-slave setup and dbs, pulling encrypted snapshots on the box and so on.
My idea is that we set up mysql slaves (with ssh tunnels) so we have live backups that can be restored easily. Everything combined we have around 8 write operations per second so that doesn't require powerful hardware.
if you do the wrong query ('drop database', 'drop table', 'delete from', 'truncate table', and so on), it will be executed on all slaves as well.
We could just create daily dumps on the slave then. Additionally the slave would prevent data loss in case the main server crashes and the database file there is corrupted.
besides, mysql replication is not very robust, a better way is to make dumps of the database.
Do you have something to back up that claim? -- Florian Pritz