MySQL, how to backup large databases?

Question

MySQL

Actually the question is, there is a rather small base, about a terabyte.
At the moment, almost all myisam tables are likely to be transferred to innodb in the near future.
The question is, how do you backup large databases?

Answer 1

1. https://www.howtoforge.com/mirroring_with_rsync
2. https://www.lisenet.com/2014/setup-linux-software-...
3. https://www.percona.com/software/ mysql-database/pe...

Answer 2

on the slave
1. table lock
2. snapshot
3. unlock
4. mount backup
(if zfs, you can immediately transfer incremental snapshots)

Answer 3

I offay sql and copy the sql folder to a separate disk