[CentOS] best ways to do mysql backup

[Benjamin Franz]

On 08/14/2010 12:51 PM, Agnello George wrote:
> we have multiple servers approx 10   and each has about 100 GB of data 
> in the /var/lib/mysql dir , excluding tar , mysqldump and replication 
> how do we take backup for these databases on to a remote machine and 
> store them datewise , ( the remote machine is a 2TB  HDD )
>
> currently tar  is not feasible as the data is too huge  and  the same 
> goes with mysqldump
>
> suggestion will be of great help

Assuming you installed using LVM partitions (and that you left space for 
snapshots ;) ), stop the database, take a LVM snapshot, restart the 
database, rsync the mysql data directory to the other machine, then 
release the snapshot.

-- 
Benjamin Franz