MySQL than bekapit large base?

The actual question is fairly small base, about terabytes.
Currently almost all of the myisam table is likely in the near future will translate to innodb.
The question is, how do you bekapit base of a large volume?
July 2nd 19 at 17:04
3 answers
July 2nd 19 at 17:06
Well, rsync and soft raid I hardly need.
And here are 3 of the item you use? at what volumes? - judge.Litt commented on July 2nd 19 at 17:09
: use item 1: rsync, too, by the way I suggest in section 3... But when lots and doing Raid1 (mirror) and simply replace the drive. - Kyleigh_Hills commented on July 2nd 19 at 17:12
July 2nd 19 at 17:08
the slave
1. lock tables
2. snapshot
3. unlock
4. mounted becaem
(if zfs, you can just incremental snapshots to share)
by the way, uses anyone the galley on large myisam? how's it going? pain and suffering are? - judge.Litt commented on July 2nd 19 at 17:11
After I made snapshot and and remontiroval much do gives the speed (in zfs, lvm)?
In my case, the slave separately for backups, and it can be turned off or is not available at the time of backup. - Kyleigh_Hills commented on July 2nd 19 at 17:14
: on ext3 Yes, after the backup, the snapshot you want to delete :) and select points in this slave is not worth it to send.
about mysql on zfs will not prompt, in prod there, and filopovic deceleration is not felt ~3 TB (snapshots are not deleted and matirovannym condition, hour, day, week, month). - Jeanne54 commented on July 2nd 19 at 17:17
July 2nd 19 at 17:10
offal sql and copy the sql folder to a separate disk
In principle, the way is now being done, there is a shelf with deduplication, and there are filled with files. And not try for example extra backup from perkon? - judge.Litt commented on July 2nd 19 at 17:13
: nope I handles make - Kyleigh_Hills commented on July 2nd 19 at 17:16
and not try for example to make your own scripts with bacula/bareos for example?
how to monitor and verify backups? - Jeanne54 commented on July 2nd 19 at 17:19
: no, backup does not check - judge.Litt commented on July 2nd 19 at 17:22

Find more questions by tags Backing upMySQL