0
votes
2answers
291 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
321 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 ...
0
votes
3answers
82 views

What is a good tool/method for version controlling a part of a live database?

Sometimes if a database gets corrupted, a replicated database could also replicate that same corruption. What is the best way to replicate/backup a database and prevent something like this from ...
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 ...
-2
votes
2answers
249 views

how to use mylvmbackup [closed]

any useful tips or easiest way
-1
votes
6answers
242 views

backing up large database with large amount of data in a small time limit then restoring it within a small time of limit? [closed]

Backing up large database with large amount of data in a small time limit then restoring it within a small time of limit? Any useful ideas?
-1
votes
1answer
207 views

mysqlhotcopy — A Database Backup Program [duplicate]

is the mysqlhotcopy — A Database Backup Program best way to backup the large data in mySQL??
3
votes
5answers
4k views

How can I back up and replicate a large MySQL database?

How can I backup a large database in mysql? And what is the best way to replicate the database? what i'm looking for is backing up large database with large amount of data in a small time limit ...