1
vote
1answer
78 views

Backups from MySQL slave server — Good idea or bad?

I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
2
votes
1answer
262 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
0
votes
2answers
309 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
1
vote
1answer
323 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
6
votes
3answers
1k views

Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables

I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I ...