How do you properly do backup in live site?

Status
This content is read-only, or is not open for further replies.

Danny88

Guest
offline

I'm wondering if you have large site consisting about 100GB mysql size , how do you guys do get the backup data in accurate way?

Logical Mysql dump inconsistencies​

One of the biggest downsides to mysqldump is its lack of parallelism. The tool starts at the first database, alphabetically, then dumps each table within, one at a time. Consider a transaction that inserts data into tables ‘alpha’, and ‘zeta’. Now the backup begins. When the backup reaches table ‘delta’, another...

Read more

Continue reading...
 
Liked by:
Status
This content is read-only, or is not open for further replies.
Top Bottom